Package deployment with dtsconfig file

Hi,

I've created a deployment manifest to install my package and associated config file. It installs fine (as a file system package), however each time I launch the execute package wizard, I have to browse the file system to select the configuration I want to use. Is there any way of installing a package so that the config file is used by default? My work around is to use the package execution wizard to create figure out what the dtexec parameters are - then use dtexec to actually run it.

Also I tried installing in MSDB, the error message implied that SSIS requires a default instance of SQL 2005 in order to use MSDB as a package store - is this true?

Dave

[689 byte] By [DaveWaterworth] at [2007-12-25]

SQL Server

Site Classified