Re: Changing connection

#1

How is the name for the tables in the transform data task specified?

I am willing to bet they look like this

DatabaseName.OwnerName.TableName

You need to make sure the SourceObjectName property is set to the name
of the table only.

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

#2

In article <27ADE84D-4E5D-4A8C-81A9-367AD69F03CB (AT) microsoft (DOT) com>, Tony Joselin wrote:

Quote:

You are absolutly right, they are!

The question is now, how can I change it so they aren't? The transform data task just gives me a dropdown of available tables on that connection. Should I write an activex script task to go through each transform data task? If so, how do I change the destination table name through code?

Thanks

Tony Joselin

"Allan Mitchell" wrote:

How is the name for the tables in the transform data task specified?

I am willing to bet they look like this

DatabaseName.OwnerName.TableName

You need to make sure the SourceObjectName property is set to the name
of the table only.

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

The destination is

DestinationObjectName

You can, if using 2000, use the Disco Edit feature and do it through that instead.

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Changing connection

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

Re: Changing connection - 07-08-2004 , 11:51 AM

Re: Changing connection - 07-09-2004 , 09:21 AM