question

NicolasBrawerman-4613 avatar image
0 Votes"
NicolasBrawerman-4613 asked ZoeHui-MSFT answered

Execute SSIS Package with Configuration command line

Hi

there is a way (command line) to execute an SSIS Package according to one of my 2 configurations?

my command is :
"C:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTExec.exe" /F "C:\NicoTest\newTests1nico\Package.dtsx"

I have create a project parameter that is different according to the selected configuration - run it manually works as expected.

thanks in advance

111833-image.png


sql-server-integration-services
image.png (26.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @NicolasBrawerman-4613,

Enable package configurations and then execute the package from a batch file.

Details you may refer:

https://www.sqlservercentral.com/articles/how-to-execute-an-ssis-package-from-the-command-line-or-a-batch-file

Not sure if this could meet your need. You may have a try.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.