Prerequisite to run dtexec.exe from the command line?

I developed an SQL 2005 SSIS package that I want to run from the command line on another computer, when I run the package on my machine, with SQL 2005 Developer installed and VB6, the process runs just fine, but slow (reason we are trying to run on another machine). I have copied over the specific DLLs, but the package still fails to run. I would post the specific error, but the machine died when I attemped to install SQL 2005 Express.

Any assistance with determining what needs to be on the remote machine would be greatly appreciated.!

more ▼

asked Oct 19, 2009 at 02:28 PM in Default

avatar image

Dave P
23 1 1 3

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

SSIS is not part of SQL Express, nor is it a client type application the way DTS was from SQL 2000. You must run it on a machine upon which one of the full SQL Server editions installed (Developer, Standard, or Enterprise) has been installed.

more ▼

answered Oct 19, 2009 at 07:33 PM

avatar image

John Arnott
36 2 1

(comments are locked)
10|1200 characters needed characters left

If it's a .NET dependency, then you really need to look at the content of the generated exception to look at what module you would need to load.

If it's a native dependency, then the Dependency Walker tool will give you a good idea of what DLLs you need.

more ▼

answered Oct 19, 2009 at 07:17 PM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

(comments are locked)
10|1200 characters needed characters left

You can put the dtexec statement in sqlcmd statement and kick it off from remote machine e.g.:

sqlcmd.exe -S SQLServername -U SQLUsername -P SQLUserPassword -Q "xp_cmdshell 'dtexec /sq \Packagename /ser SQLServername /User SQLUsername /Password SQLUserPassword'"

Maybe someone can suggest improvements, but this worked for me

Regards, Khalid Dhariwal

more ▼

answered Oct 28, 2009 at 11:47 AM

avatar image

Khalid Dhariwal

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 19, 2009 at 02:28 PM

Seen: 6717 times

Last Updated: Oct 20, 2009 at 04:37 AM

Copyright 2018 Redgate Software. Privacy Policy