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 |
|
bondwiththebest
Starting Member
46 Posts |
 Posted - 2008-10-05 : 21:28:59
|
| Hi everyone,I have bunch of files(aprrox 100) named in the format like this "No. date time Pass N ItemID .txt"i.e "001 20081005 0912 Pass 1 01abcd .txt".I need to read first pass(Pass 1) and last pass(Pass N) for each ITEM ID. I have FTP'ed all these files into a single folder,but I am not sure how to read first and last file only and then pass these files names to the data flow task.I am using FOR EACH LOOP, but I am not sure how can i pass the file names to the FOR EACH LOOP, Can anyone please help me or give me an idea ?? |
|
|
bondwiththebest
Starting Member
46 Posts |
Posted - 2008-10-06 : 22:05:49
|
| I tried to use a Script task and then use a sequence container inside a for each loop(to read each loop). Can any one help me with the scirpt task???I am trying to read the first and last pass for each ITEM ID. I am planning to storing the first and last file names into global variables and then execute sequence container.Then goto next file, But i am not sure how do it using scripting task......can some one help me ...with that??? |
 |
|
|
|
|
|
Reading a file name!