I have a DTS Package that is called from an ASP.Net page. The package takes in 4 global variables it needs for certain steps. If I execute the package using DtsRunUi.exe it will execute okay. But when called from my aspx page, I will get the following error when I look at the Event Viewer:
I can’t find any helpful information on this error code/context id. The only difference between this step and the others that completed successfully is that this SQL task is using 2 databases. The SQL statement is “Insert Into Database1.dbo.Table1 (Col001, Col002) Select Col001, Col002 From Database2.dbo.Table2”. Both data sources are defined in the package.
I don’t know if the fact that I am trying to use two data sources is messing with ASP.net. Anyone seen anything like this? Any help would be great.
Thanks,
Journeyman -- The Order of the Seekers of Truth and Penitence
Code:
Step 'DTSStep_DTSExecuteSQLTask_10' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description: The task reported failure on execution.
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID: 1100I can’t find any helpful information on this error code/context id. The only difference between this step and the others that completed successfully is that this SQL task is using 2 databases. The SQL statement is “Insert Into Database1.dbo.Table1 (Col001, Col002) Select Col001, Col002 From Database2.dbo.Table2”. Both data sources are defined in the package.
I don’t know if the fact that I am trying to use two data sources is messing with ASP.net. Anyone seen anything like this? Any help would be great.
Thanks,
Journeyman -- The Order of the Seekers of Truth and Penitence