x

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

Dave P gravatar image

Dave P
23 1 1 1

(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

John Arnott gravatar image

John Arnott
36

Thanks, John, I kind of figured this was the case, but I was hoping there was an easier softer way around it.
Oct 20, 2009 at 09:04 AM Dave P
(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

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

(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

Khalid Dhariwal gravatar image

Khalid Dhariwal
1

(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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1951
x946

asked: Oct 19, 2009 at 02:28 PM

Seen: 5821 times

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