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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2011-08-25 : 05:57:39
|
| Hi there,I'm brand new to SSIS and would like to ask a question.I want to import a text file to a SQL2008 table and then run a query against it using running totals, the results of this query will be added to another table. Then I'd like the package to export the table to a text file.At the moment I've used a Flat file source to connect to the flat file. and I've added a ADO Net Destination object to add the text file to a table in SQL Server.My question is, how do I add the text file to the table and then run the query and add the results to another table and then extract back to text file?Any help on this would be much appreciated:) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-25 : 06:00:40
|
| you need1. data flow task with flat file source and oldeb destination to move file data to table2. execute sql task to execute update query and inserting to other tables3. finally anothr data flow task with oledb source to connect to final table and flat file destination to move it back to text file.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
cidr
Posting Yak Master
207 Posts |
Posted - 2011-08-25 : 10:46:36
|
| That worked perfectly, thanks for your help Visakh! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-25 : 12:56:32
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
T-SQL update table in SSIS