Write the select query first and see if it returns the info you desire. If not, post it and we'll take a look. Paul and Andy provide a great solution.

Steve...

Great suggestion. I'll take it up with the founders and see. you can get a short one here:

http://www.sqlservercentral.com/other/AboutUs.asp

Steve Jones

steve@dkranch.net

Thanks for the followup.

Steve Jones

steve@dkranch.net

create table MyTable( MyID int identity( 1,1 ))

Steve Jones

steve@dkranch.net

You could let one package call another conditionally based on a global variable. The dynamic properties task can handle this and change the name of hte package to execute based...

I suppose you could, but why not have 2 linked servers?

Steve Jones

steve@dkranch.net

Nice choices. Glad we could help.

Steve Jones

steve@dkranch.net

You're welcome. It should have been an SP2 thing and I should have mentioned it.

Steve Jones

steve@dkranch.net

What are you working on? any chance of your company moving to .NET. Is there an investment in COM / VB6 technologies?

Personally I'd just go to .NET, but there isn't...

It specifies the specific columns. follow the format listed exactly. On the verson line it is the first column.

Steve Jones

steve@dkranch.net

resave with a password and then try to open it.

Steve Jones

steve@dkranch.net

no script I know of. Should be able to build a serise of commands using system views.

select 'alter table ' + table_name + ' add column xxx'

from information_schema.tables

Steve Jones

steve@dkranch.net

I'd choose DTS.

Steve Jones

steve@dkranch.net

Pls don't cross post. We check all forums. See the other post.

Steve Jones

steve@dkranch.net

Thanks. Glad someone liked it.

Steve Jones

steve@dkranch.net