Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqldba2k6
Posting Yak Master
176 Posts |
 Posted - 2007-07-25 : 13:45:14
|
| I am importing the data from sqlserver to .csv file.when i am executed the dts package i got below error.error opening network file:datafile was not foundHow do i specify the destination path where .csv file to be generated...I have mentioned the path like:\\mysystemname\C:\Documents and Settings\Desktop\Dirname\test.csvPlease help ...... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-25 : 13:48:54
|
| That is not a valid path. Are you familiar with how to reference shares? Hint, you use $.You should always test your paths via a cmd prompt before putting them in a package, application, job, etc...Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sqldba2k6
Posting Yak Master
176 Posts |
Posted - 2007-07-25 : 13:59:54
|
| Thanks for the reply..I am not familiar with reference shares.can yu give me some more hints or examples...I am specifying the path in .csv properties in designer package |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-25 : 14:04:52
|
| Admin shares require $, custom shares do not. C is an admin share as are other drives.Admin share:\\myServer\e$\SomeFolder\SomeFile.txtCustom share:\\myServer\SomeShare\SomeFile.txtTara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sqldba2k6
Posting Yak Master
176 Posts |
Posted - 2007-07-25 : 14:16:55
|
| Thanks it works fine!!!!!!! |
|
|
|
|
|
|
DTS Error