Deploy Packages using DTUTIL

Question

Post reply

Deploy Packages using DTUTIL

Welsh Corgi

SSC Guru

Points: 116520
More actions
April 20, 2016 at 7:24 am

#400047

It has been a long time since I used DTUTIL to deploy packages to the root of msdb.
This example does not seem complete?
dtutil /SQL srcPackage /COPY DTS;destPackage
Or this one:
DTUTIL /FILE CreateSalesForecastInput.dtsx
/COPY
SQL;CreateSalesForecastInput
I'm trying to find a good tutorial video.
The ones that I found had such a small font that you could not read it.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 5 posts - 1 through 5 (of 5 total)

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

I tried executing the following from the command line:

CD C:\RefreshTestFromProduction\SSIS\Drop_Constraints_629 Foreign_Key_ConstraintsDrop.dtsx

/COPY

SQL;Drop_Constraints_629 Foreign_Key_ConstraintsDrop /DESTSERVER "ServerName"

I get the following error:

'SQL' is not recognized as an internal or external command

What is the correct syntax?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I put everything on 1 line:

CD C:\RefreshTestFromProduction\SSIS\Drop_Constraints_629 Foreign_Key_ConstraintsDrop.dtsx /COPY SQL;Drop_Constraints_629 Foreign_Key_ConstraintsDrop /DESTSERVER "PRODDATA6"

I get the error 'system does not recognize the path specified'

Any ideas?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I performed a remote session to the Server using the following command:

DTUTIL /FILE Foreign_Key_ConstraintsDrop.dtsx /COPY SQL;Foreign_Key_ConstraintsDrop

It returns a response that Foreign_Key_ConstraintsDrop already exists. Do you want to overwrite it.

I create a job and attempt to add the package as a job but it is not displayed.

Any ideas?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

The issue has been resolved.

I found the package in msdb.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/