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 |
kkiranvr
Yak Posting Veteran
54 Posts |
Posted - 2008-07-29 : 18:49:22
|
Here i am extracting data from flat files, and using for each loop container, and i am getting data into my tables well with one test path, whrere as i am trying the same with the original path it is not working, and it is giving the below error.[Connection manager "Test_Full"] Error: The file name property is not valid. The file name is a device or contains invalid characters.while i am opening the original path i could able to open the path and i am having the data in flat files as well. So can any one help me out in this?-Thanks N Regards,Chinna. |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-29 : 22:48:06
|
What's your 'original path'? Can you post your code? |
 |
|
kkiranvr
Yak Posting Veteran
54 Posts |
Posted - 2008-07-30 : 12:21:37
|
\\Tk2mpprfildtr03\CorpReporting\INTERNALPARTNERS\XBOX-Thanks N Regards,Chinna. |
 |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-30 : 22:29:39
|
Does sql service account have permission to access that path. |
 |
|
|
|
|