I wrote about a web page running a Stored proc that kicks off a DTS package earlier. We abandoned the process and instead set a trigger on insert to a table that runs the Stored proc.
The issue now is if you insert data into the table with the trigger the dts package cannot do a select on any tables. If you enter data directly to the table the trigger works and the whole process works. The web page is on another server. We're stumped. Rights issues seem to be taken care of, but one never knows. Any ideas out there.
The issue now is if you insert data into the table with the trigger the dts package cannot do a select on any tables. If you enter data directly to the table the trigger works and the whole process works. The web page is on another server. We're stumped. Rights issues seem to be taken care of, but one never knows. Any ideas out there.