Sql-server – dtexec returns immediately without any messages

dtexecsql serversql-server-2012ssisssis-2012

I'm trying to setup a command-line call to dtexec to validate packages, using the project model. I'm calling dtexec like this:

dtexec /val /proj my.ispac /pack my.dtsx  /rep v

Though the real paths to the ispac and dtsx are longer. WHen I run this, all I see on the console is:

Microsoft (R) SQL Server Execute Package Utility
Version 11.0.7001.0 for 32-bit
Copyright (C) 2016 Microsoft. All rights reserved.

Started:  10:40:01 AM
PS D:\>

The whole thing runs in under a second which leads me to believe that it did nothing. And no messages of any kind are issued., even though I asked for verbose reporting.

Any ideas out there as to how to make this work?

Best Answer

You are almost there, the syntax you are using is correct by you cannot use an abbreviation /Val. From the official documentation, you can see that:

/Rep[orting] level [;event_guid_or_name[;event_guid_or_name[...]]

/Pack[age] PackageName: (Optional). Specifies the package that is executed.

/Rep[orting] level [;event_guid_or_name[;event_guid_or_name[...]]

/Proj[ect] ProjectFile: (Optional). Specifies the project from which to retrieve the package that is executed.

Validation and execution phase: The package is run, or validated without running if the /VALIDATE option was specified.

Also note that when executing package from a project don't add the package extension .dtsx

Based on that try to use the following command:

dtexec /Proj my.ispac /Pack my  /Rep V  /VALIDATE
Related Question