I have a SSIS package, the first step of which is to create a DBF file consisting of several fields, including a Sum and Group By, from two tables. I need several more DBF files consisting of the same information but for only some of the records. I could create these files by running the same T-SQL statement, but it seems that it would be more efficient to just select the desired records from the first DBF file, which contains all the records. However, I cannot find any task that allows me to run a T-SQL statement between two flat files. Can this be done?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
T-SQL in SSIS flatfile to flatfile
- Thread starter grnzbra
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
