DTS error executing from Stored Procedure

Question

Post reply

DTS error executing from Stored Procedure

Dean Reedy

SSChasing Mays

Points: 632
More actions
May 24, 2005 at 2:53 pm

#89019

When I call my DTS package from a stored procedure by:
exec master.dbo.xp_cmdshell 'dtsrun /S ntserver5 /U username /P password /N "New Package"'
I get the following error:
Error string: The Microsoft Jet database engine could not find the object 'jungtran2'. Make sure the object exists and that you spell its name and the path name correctly.
Now when I run it from Enterprise Manager under DTS and Local Packages it runs fine.
This DTS loads a dbf file named "jungtrans2.dbf" and I have the dts using UNC path: \\public\Dean\Junge\
Any ideas?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 1

are you using an odbc connection, is that connection present on the server?

Dean Reedy SSChasing Mays Points: 632 More actions · Answer 2

Yes, the connection I think is on the server as we have other DTS using the same connection and they have schedule jobs

mdaniel SSCarpal Tunnel Points: 4616 More actions · Answer 3

Does the user that you use in your DTS have access to the share?

Dean Reedy SSChasing Mays Points: 632 More actions · Answer 4

Yep, everyone has full permissions on this share/folder.

I just tried to schedule the DTS and the Job agent fails to run aswell.

Scott-144766 SSCarpal Tunnel Points: 4333 More actions · Answer 5

Try logging on as the account you use to run SQL Server Agent and run the package. If there's a permissions issue, you should see where the process fails.

--
Scott

Dean Reedy SSChasing Mays Points: 632 More actions · Answer 6

ok, Now I get a new error, when running the job agent, please note this is a DBF file I am trying to load:

Executed as user: \. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from DeanTest to [Tech].[dbo].[ftsys_whse_production_junge_temp] Step DTSRun OnError: Copy Data from DeanTest to [Tech].[dbo].[ftsys_whse_production_junge_temp] Step, Error = -2147467259 (80004005) Error string: External table is not in the expected format. Error source: Microsoft JET Database Engine Help file: Help context: 5003274 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -328602519 (EC69EC69) Error string: External table is not in the expected format. Error source: Microsoft JET Database Engine Help file: Help context: 5003274 DTSRun OnFinish: Copy Data from DeanTest to [Tech].[dbo].[ftsys_whse_production_junge_temp] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.