sql server dts: Connection Selected Databases can't be configured? -- sql server dts

Connection Selected Databases can't be configured?

David Norman
2/24/2006 6:00:27 PM

sql server dts:

The connection for a Check Database Integrity Task allows selection of
specific databases. However there appear to be no equivalent configuration
properties for these selected databases.

Is there a workaround for this? (Preferably not editing the dtsx files or
ensuring the names of the databases are the same in all environments)

Ta in advance

Re: Connection Selected Databases can't be configured?

Allan Mitchell
2/25/2006 11:59:17 AM

Hello David,

So is it that you want to change the databases in this list? I believe the
DBs are held as a string collection and you could therefore perhaps use this
method

http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/12/31/17731.aspx

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]