build command for SSIS project -- sql server dts

yongli
4/30/2007 12:26:00 PM

Well, I got a hint from OLAP group that I could use devenv command line to
build the SSIS package and solution. However, I encountered the following
error when using devenv command:

Error: could not get a list of SSIS packages for the project.

I searched online to find a similar post of the error, which is due to
CreateDeploymentUtility being set to true.

I wonder if someone has a solution for this.

Thanks,

Yongli.

[quoted text, click to view]

yongli
4/30/2007 1:58:02 PM

Hi Allan,

This is part of systemization effort in my company to automate the build and
deployment of SSIS packages. I am not sure this is common practice or there
is an alternative than command line to do this.

Thanks,

[quoted text, click to view]

Allan Mitchell
4/30/2007 7:54:17 PM

Hello yongli,

I am interested as to why you need to build an SSIS project on the command
line.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Allan Mitchell
4/30/2007 10:09:06 PM

Hello yongli,

OK so the way it usually works in my expereince is this.

The developer builds a package/n packages.

You then have a number of ways to deploy the packages

DTUtil
Deployment Manifest
Copy and Paste
"Import Package" menu item in Integration Services Service in SSMS.

It sounds like you are most interested in DTUtil and the Deployment Manifest.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : build command for SSIS project