November 26, 2002 at 2:50 pm
Trying to run DTS Package via stored procedure importing a text file into sqlserver database table.I am able to run the package from design mode with no problem. I was able to run through sp before with no problem. Nothing has changed. No upgrades. I am getting the following error message
---
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: Create Table results Step
DTSRun OnError: Create Table results Step, Error = -2147217887 (80040E21)
Error string: Errors occurred
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
---
Thanks for your help.
November 26, 2002 at 5:26 pm
Check the connections in the package. I think these are login errors. When you run in design mode, the package is running form your workstation. When you run it from a stored proc, it is running from the server. The context is different.
Steve Jones
November 26, 2002 at 5:28 pm
Have you tried running the DTS package by hand to verify it is not the problem instead? It can be caused by various reasons and sometimes running by hand may explain a little more. Also, open the DTS package and make sure all the connections are in proper working order, sometimes we may forget changes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply