The Other Mike
2010-05-14 18:14:44 UTC
I am very new to SSIS 2005
I have a sql command Select count(*) from table_a. The result is stored in
a global variable. In a script task, if the record count is 0 then I want
the flow to go to a task where it sends me an email of "no records found".
If there are records, then I want to execute a data flow into an excel
spreadsheet. I had it working in sql 2000, but now I don't know how to
program it. Could someone help.
Thanks
Mike
I have a sql command Select count(*) from table_a. The result is stored in
a global variable. In a script task, if the record count is 0 then I want
the flow to go to a task where it sends me an email of "no records found".
If there are records, then I want to execute a data flow into an excel
spreadsheet. I had it working in sql 2000, but now I don't know how to
program it. Could someone help.
Thanks
Mike