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)
 Flat file properties in extracting data using SSIS

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

Posted - 2008-07-30 : 19:35:29
1. Yes as it would only be reading from the file.
2. Just read should be necessary

What issue are you having?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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

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=107659
In 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.

Webfred


There are 10 types of people in the world: Those who understand binary, and those who don't...
Go to Top of Page
   

- Advertisement -