Help With DTSInstall.exe
Nov 29, 2005
All I need to do is copy a deployment package that I created with Visual Studio 2005 to another server location, installed in that server's file system (not msdb). I am hoping to use a simple deployment script, but I can't find any info on how to call dtsinstall.exe to automate this for me. I keep reading references to this utility, but how does one use it in silent mode and send it parameters? At the command prompt, typing dtsinstall /? gives an error rather than helpful info. Am i missing something?
View 7 Replies
Mar 18, 2008
Problem:
When migrating packages to production using the DTSInstall program, phantom validation warnings are occurring.
Background /Installation options
We use the DTSInstall program to migrate code to our DEV, QA, and Production servers. Our migration process includes saving the package to the SQL server (msdb) and validating the package after install. In our most recent production migration, the package being migrated encountered warnings when validating after the install ("The package path referenced an object that cannot be found...") This warning seems to mean that I have configuration that cannot find an object to configure in the package. This error did not occur in other environments with the same code and configuration.
Troubleshooting performed:
1. Validate that configuration in all environments matched (ie. PackagePath was identical in all environments).
2. Opened the package on production server in Visual Studio, and received same warning message.
3. Executed the package in production using the validate only option: no validation warnings found.
4. Executed the package in production; package ran successfully and as expected.
5. Migrated the package from QA using dtutil and executed the package in production using the validate only option; no validation warnings found.
At this point I think I may have a problem with the DTSInstall program or the Visual Studio environment on our production box? Does DTSInstall use any parts of Visual Studio when running? Anything I am missing?
View 1 Replies
View Related
Jan 18, 2007
Hi,
A bit of a long-shot posting this here, as this area doesn't seem to see too much action, but Google is failing me!
I've run through all the necessary steps to create a deployment utility (as per http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx), but am not getting the DTSInstall exe when I build the project. No errors or warnings are generated, and all the other files (including the SSISDeploymentManifest) are created as expected. Anyone have any good ideas?
Mark
View 3 Replies
View Related
May 22, 2007
I have used above the DTSInstall.exe to Install my DTS Package in SQL Server 2005.
An entry is created in the sysdtspackages90 table.
2 Questions:
1)Where in SQL Server 2005 should I be able to see the Package itself? If I look in Maintenace Plans I see nothing.
2) If I want to run it manually, when I double click on the dtsx file on the Database Server I get a message asking me what program I want to open it with? Why is this? Do I need to have SQL Management Studio Installed?
Any help apprecisated.
View 4 Replies
View Related
Aug 17, 2007
When I use the deployment utility in BIDS to create SSIS package installer the DTSInstall.exe does not get created in the bin/Deployment folder.
I have all the dtsx packages and a manifest file in the deployment folder.
I am able to launch the installation wizard with the manifest file but i want to know why the DTSInstall.exe is not being created.
View 6 Replies
View Related
