how to pass parameters to dtsinstall.exe
hi,
Please let me know how to execute the "dtsinstall.exe" by passing parameters using command Prompt
July 6th, 2011 8:17am
What are you trying to do? Is it possible that dtutil.exe will work for you?http://sqlblog.com/blogs/jamie_thomson/ |
@jamiet |
About me
Free Windows Admin Tool Kit Click here and download it now
July 6th, 2011 8:36am
How then would one use dtsintall.exe to do an unattended install? I don't want to have to double-click on a .deploymentmanifest file in order to deploy it. I want to call dtsinstall.exe (or similar) and pass it all of the parameters that it requires such
as file system or SQL Server, location on file system/SQL Server etc...
July 6th, 2011 8:40am
Try using dtutil.exe instead.
And kindly don't submit the same question twice. thanks.http://sqlblog.com/blogs/jamie_thomson/ |
@jamiet |
About me
Free Windows Admin Tool Kit Click here and download it now
July 6th, 2011 9:05am
Hi,
Thanks for the reply but I want to changes the values in manifest file with the values of commandpromt by using dtsinstall.exe. Can you please help me on this
July 6th, 2011 9:20am
What values do you want to change?
I am asking because this utility only accepts
one parameter: the name of the manifest file, this is it.
Thus, I believe you ought to reconsider using the DTUtil.exe or may be your intention is to pass some config values/run time variables? Then you need the DTExec.exeArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 6th, 2011 10:03am
Hi,
When I run the manifest file using dtsinstall.exe I will get a wizard with the my manifest details like SQL Server Name and Database. Now I would Like to change those values dynamically.
July 6th, 2011 10:49am
Have several manifests to alternateArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 6th, 2011 11:25am