dbTalk Databases Forums  

Connection Selected Databases can't be configured?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Connection Selected Databases can't be configured? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Norman
 
Posts: n/a

Default Connection Selected Databases can't be configured? - 02-24-2006 , 08:00 PM






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
David

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Connection Selected Databases can't be configured? - 02-25-2006 , 01:59 PM






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/kni.../31/17731.aspx



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

Quote:
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
David



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.