I have the following command that imports my package into SSIS but i
can't seem to set ProtectionLevel 5 (ServerStorage). I can do this
manually if I select import package but not from the command line.

DTUtil /DestS SERVER\INSTANCE /FILE "D:\MyPackage.dtsx" /COPY
SQL;"\Packages\MyPackage"

Does anyone have any suggestion please.

Regards

Toby.

Hi Tobi,

It writes a new copy when you encrypt, so there is no need to specify /COPY.
Do the following:

DTUtil /FILE "D:\MyPackage.dtsx" /Encrypt SQL;"MyPackage";5 /DestS
SERVER\INSTANCE

Cheers,

Charles Kangai, MCT, MCDBA

"Tobi" wrote:

Tobi wrote:
I just used the "Save Copy of mypackage.dtsx as ..." in Visual Studio
and selected SQL Server and setting it at the bottom of the form. I
never got it to work on the command line either.

HTH
Dave