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 2008 Forums
 SSIS and Import/Export (2008)
 SSIS Question

Author  Topic 

messi6331
Starting Member

1 Post

Posted - 2014-07-17 : 21:24:51
I am new to SSIS and am trying to create an SSIS package.
I have value per line in a text file. There is a table consisting of records with each of the values in the text file. The SSIS package should generate text files for each of the value in the text file with the data from the table.
Details:
Text File – abcd.txt
10
11
12
13
Table
1 10
2 11
3 12
4 13
5 10
6 11
7 12
8 13
9 10

The SSIS package should create the following text files with the records that are associated with 10, 11,12 and 13:
10.txt
11.txt
12.txt
13.txt
Thanks in advance

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-07-18 : 07:44:08
What have you got so far?
Go to Top of Page
   

- Advertisement -