dtUtil question - How to include miscellaneous files in deployment?

Hello,

I'm wondering how to use the dtUtil command to deploy an ssis package but also include any of the miscellaneous files, such as some dtsconfig files. I'd like to be able to use the dtUtil command to specify where to put any "dependencies" that I have. If I create a deployment utility from BI Studio, I have the option on the third screen to choose the folder for dependencies, how come I don't see any parameters for that on the dtUtil command? Is it possible, or do I HAVE to deploy using the deployment utility created for me by BI Studio?

Thanks in advance,

Andy

When deploying to a file system /copy option should work for dependencies as well.

For example:

dtutil /File c:\2.reg /copy File;c:\3.reg

|||[quote]
dtutil /File c:\2.reg /copy File;c:\3.reg
[/quote]
That's very interesting; as long as you are 'deploying' to the same machine. Maybe it's just me, but 'deploying' to the same machine isn't really 'deployment' - normally you need to do it to a remote machine; and if you try to specify a /destserver, you get....

The File destination cannot be specified with the DTS, SQL, Server, User, or Password destinations.

dtutil and xml configuration file

Hi,

Im loading the packages with a dutil-batch from the file-system into the sqlserver.

All the packages have xml-configuration-file.

for %%f in (*.dtsx) do dtutil /FILE %%f /COPY SQL;%%~nf /DestServer server /QUIET

When I try to run the packages in the sqlserver environment there is no configuration file found.

Is there a possibility to transfer also the link to the xml-configuration-file xml-configuration-file with dtutil?

Thanks Gerd

Moving to a better forum|||Try using the DTSDeployment utility to deploy packages that reference configuration files. The deployment utility will allow you to specify where to put the config files and will update the packages accordingly.|||

Hi

I am also in the same boat. I dont want to use deployment utility as I want to create a batch file. adminstrator will use this batch file to deploy on prod server.

I have configuration file that needs to be deployed on server along with package. please tell me if it possible or please give me work around for this.

|||You can specify the location of the configuration file when you run the package by using the /ConfigFile switch of DTEXEC.

dtutil and xml configuration file

Hi,

Im loading the packages with a dutil-batch from the file-system into the sqlserver.

All the packages have xml-configuration-file.

for %%f in (*.dtsx) do dtutil /FILE %%f /COPY SQL;%%~nf /DestServer server /QUIET

When I try to run the packages in the sqlserver environment there is no configuration file found.

Is there a possibility to transfer also the link to the xml-configuration-file xml-configuration-file with dtutil?

Thanks Gerd

Moving to a better forum|||Try using the DTSDeployment utility to deploy packages that reference configuration files. The deployment utility will allow you to specify where to put the config files and will update the packages accordingly.|||

Hi

I am also in the same boat. I dont want to use deployment utility as I want to create a batch file. adminstrator will use this batch file to deploy on prod server.

I have configuration file that needs to be deployed on server along with package. please tell me if it possible or please give me work around for this.

|||You can specify the location of the configuration file when you run the package by using the /ConfigFile switch of DTEXEC.

dtutil and xml configuration file

Hi,

Im loading the packages with a dutil-batch from the file-system into the sqlserver.

All the packages have xml-configuration-file.

for %%f in (*.dtsx) do dtutil /FILE %%f /COPY SQL;%%~nf /DestServer server /QUIET

When I try to run the packages in the sqlserver environment there is no configuration file found.

Is there a possibility to transfer also the link to the xml-configuration-file xml-configuration-file with dtutil?

Thanks Gerd

Moving to a better forum|||Try using the DTSDeployment utility to deploy packages that reference configuration files. The deployment utility will allow you to specify where to put the config files and will update the packages accordingly.|||

Hi

I am also in the same boat. I dont want to use deployment utility as I want to create a batch file. adminstrator will use this batch file to deploy on prod server.

I have configuration file that needs to be deployed on server along with package. please tell me if it possible or please give me work around for this.

|||You can specify the location of the configuration file when you run the package by using the /ConfigFile switch of DTEXEC.