October 10, 2008 at 10:27 am
Hello,
I'm new to SSIS and still trying to map/mimic DTS functionality within SSIS.
I created a package (from SSIS import wizard) to import/refresh data into 3 tables. After the completion of each process, I would like to run a SQL statement task to populate another table "Audit" that collets the table name and import name and success/fail status ... how do i do this? what tool from toolbox?
re:
In my package, under tab Control Flow, I have a box "Data Flow Task" and "Email Send" (see attachment SSISScreen3)... if i dbl click, it moves to the Data Flow tab ... under this i have a total of 6 boxes ... 2 for each table refresh process ... for example, for table 1, i have 2 boxes joined (data flow path editor) with "Source -" and "Destination-" (see attchment SSISScreen1) ... in DTS, I use to use "Execute SQL Task" right after "Destination" before starting Table 2 import/refresh process ... which i dont see in SSIS ... how do i add/mimic this?
Many thanks. Jeff
October 13, 2008 at 7:36 am
Execute SQL task is there - you use it in the control flow tab so after your data flow.
If you want to do it after each table then you need to split the one combined data flow into 3 with execute sql task after each and only one table's transfer in each data flow. Use cut and paste to pull the source and dest components and their link from one dataflow to another.
Suggest you get a book or two and go on a course if you're going to do much more - it's very different to DTS.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply