On Apr 11, 12:46 pm, andrew.c...@mater.org.au wrote:
> 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

> 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
>

On Apr 13, 4:59 am, Allan Mitchell <a...@no-spam.sqldts.com> wrote:
> Hello andrew.c...@mater.org.au,
>
> 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 Mitchellhttp://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- Hide quoted text -
>
> - Show quoted text -