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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Connection string

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?
Go to Top of Page

kkiranvr
Yak Posting Veteran

54 Posts

Posted - 2008-07-30 : 12:21:37
\\Tk2mpprfildtr03\CorpReporting\INTERNALPARTNERS\XBOX
-Thanks N Regards,
Chinna.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -