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)
 read text file in script task in ssis

Author  Topic 

sky2aone
Starting Member

5 Posts

Posted - 2008-09-25 : 17:20:56
how can i read one row at a time from text file in for loop
i have text file like this:
ABC
DEF
GHI

first time loop will get only ABC..so on

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-09-26 : 08:14:51
moved from script library

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-26 : 09:01:19
Foreach loop container .
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 09:36:49
I think you can use script task and access file content using file system object. can i ask why you need row by row data?
Go to Top of Page
   

- Advertisement -