Since I was unable to get the rowcount value from the bulk insert TSQL command in a DTS Execute SQL Task into a global variable,...

phillcart:

I would really like to use staging tables and do the loads like that, but the client is very much against staging tables. They are using staging tables now and...

RGR'us:

I appreciate your assistance with this matter.

If it is possible to use the DTS Bulk Insert Task while firing triggers, please identify exactly how to do so. There is...

I appreciate your response.

The bulk insert is done by an Execute SQL task. I need to fire triggers on the table during the insert and it is my understanding...

I don't know what was causing all the problems getting the data from the dispatch recordset variable, but I reviewed that article, made some changes, and now everything is file. I...

Thanks, this article looks promising.