DTS doesn't execute properly when called from asp

DTS doesn't execute properly when called from asp

Post by Chris Kenn » Wed, 09 Feb 2005 00:39:01


When I execute a DTS via an ASP page it doesn't execute properly. I am
deleting from some tables and then copying some data from an Access db. It
seems to be coping then deleting rather than the other way round. When I
execute from Enterprise Manager it does things correctly. I am outputting
the steps on the ASP page and backs up the wrong order theory. Any ideas?
Regards. Here is the output.


Copy Data from tbl_Picture to [magnets].[dbo].[tbl_Picture] Step
Copy Data from tbl_ProdGroup to [magnets].[dbo].[tbl_ProdGroup] Step
Copy Data from tbl_ProdType to [magnets].[dbo].[tbl_ProdType] Step
Copy Data from tbl_Product to [magnets].[dbo].[tbl_Product] Step
DTSStep_DTSExecuteSQLTask_1
DTSStep_DTSExecuteSQLTask_2
DTSStep_DTSExecuteSQLTask_3
DTSStep_DTSExecuteSQLTask_4
DTSStep_DTSExecuteSQLTask_5
DTSStep_DTSExecuteSQLTask_6
DTSStep_DTSExecuteSQLTask_7
DTSStep_DTSDataPumpTask_1
DTSStep_DTSDataPumpTask_2
DTSStep_DTSExecuteSQLTask_8
DTSStep_DTSExecuteSQLTask_9