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-30 : 19:11:53
|
Hi all, what flat file properties should have to extract data into a SQL table using SSIS?1. can we extract with having Read-only permissions?2. is flat file or folder should have full control or full access properties?-Thanks N Regards,Chinna. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
kkiranvr
Yak Posting Veteran
54 Posts |
Posted - 2008-07-30 : 20:21:43
|
I am extracting data from a flat file, i have tested by keeping the flat file in some source directory and it was working very fine, but while i am extracting from the original path it is not taking. and throwing 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.-Thanks N Regards,Chinna. |
 |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-31 : 02:30:09
|
Please don't open new threads for same question.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107659In other thread you have posted the "original path" but you also posted that you run a loop so that i think you have to look in that sourcefolder to see that there is at least one file which name cannot be handled by the package.WebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
 |
|
|
|
|