(Step I) I'm building a Package where I need to run Query to update a table say "mytable1"
Mytable is a tmp table
(Step 2) then I need to run a store procedure which will update certain records in "mytable"
(Step 3) : Send the data to network drive as a text file
Is it possible to design all this in SSIS package ? (I know yes)
I'm able to design Step I by Datasource
then I need to run store procedure which depends on the sucess of Step 1- how to do this step? because I still have to create the text file which is step3
Please let me know ASAP, thanks