Re: Configuring Destination Database in Transform Task

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello andrew.cann@xxxxxxxxxxxx,

OK that is because the DestinationObjectName is still pointing to <dbname>.<owner>.<object>

You can either set this property to be the name (unqualified of the destination object) or you can use Disconnected Edit to make the Property owner + Name only.



--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

Hi

Is is possible to configure the destination database in a
transformation task? I have seen a few posts on this subject, but I
havnt seen any solutions. I am currently using a dynamic properties
task to assign the catelog (database) value, but the transformation
task continues to use the database name that was orginally selected
when setting up the transformation task, instead of the database that
is assigned at run time via the dymanic properties task.

Thanks



.

Relevant Pages