CODEWITHSUNDEEP
ssissql-server-2008-r2
Nobody
Nobody

Reputation: 539

SSIS Package not visible after DTUTIL import

I'm able to import package into integration services via DTUTIL import, however when I access integration services I cannot find the package in question.

The command used is as follows:

DTUTIL /FILE C:\temp\<PackageFile>.dtsx /DestServer <servername> /copy SQL;<Packagename>/DestU <Username> /DestP <Password>

When I import the package.dtsx from the SQL management studio integration services, will successful import and render the package.

I'm not sure whether we need to include additional parameters to specify the root of the msdb (root).

Upvotes: 2

Views: 781

Answers (2)

Nobody
Nobody

Reputation: 539

Resolved the issue, by specifying the path in quotes as shown below:

/COPY SQL;\<Package>

instead of

/COPY SQL; <Package>

That works

Upvotes: 1

billinkc
billinkc

Reputation: 61211

Your syntax for uploading a package to the root is correct. Try running a query to ensure the packages exist as you expect them-SSIS Package Query

That should build out a result set showing all the packages you have in your <servername> instance. If those are showing, then it's a matter of fiddling with the Integration Services Service. Is there more than one instance on this box?

Upvotes: 1

Related Questions