Transformation Data Task

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

I'm using Transformation Data Task to copy data from one server to another
database server. I need source and destination connection parameter to set
dynamically for every execution. I used global variables to set connection
parameter dynamically but no luck and after a bit of searching I found that
DestinationObjectName was carrying table name of the one from design time.
Then I applied ActiveX script that changes DestinationObjectName attribute
and did not get any error message. It shows successful transformation of
data with number of rows transformed. But when I checked in destination
database tables were still blank and no row has been transformed. Now I'm
wondering how could this be possible showing no error and numbers of
successul transformation but still no rows at destination tables?

Shrwan


.

Relevant Pages

  • Re: DTS Transformation Error
    ... script that the transformation should also copy the Source Table structure ... ' Copy each source column to the destination column ... programming though I'm reasonably familiar with the DTS UI. ... ActiveX Script Task Properties: AssignGlobalVariables ...
    (microsoft.public.sqlserver.dts)
  • Re: Sql 2005: SSIS - How to convert "N/Y" CHAR(1) to byte type column
    ... | Once I added the column transformation the whole sequence worked great ... | flat file source to the oledb destination. ... |> | I'm attaching example files of the flat file source, OleDb Destination ...
    (microsoft.public.sqlserver.dts)
  • Re: Transformation Data Task
    ... Make sure that DTS is Running in Transaction mode. ... make sure Commit on Successful package completion is True. ... > I'm using Transformation Data Task to copy data from one server to another ... I need source and destination connection parameter to set ...
    (microsoft.public.sqlserver.dts)
  • Re: Sql 2005: SSIS - How to convert "N/Y" CHAR(1) to byte type column
    ... There was an additional Y-N column in the flat file that needed ... Once I added the column transformation the whole sequence worked great ... flat file source to the oledb destination. ... > | I'm attaching example files of the flat file source, OleDb Destination ...
    (microsoft.public.sqlserver.dts)
  • Re: Transformation Data Task
    ... Make sure that DTS is Running in Transaction mode. ... make sure Commit on Successful package completion is True. ... > I'm using Transformation Data Task to copy data from one server to another ... I need source and destination connection parameter to set ...
    (microsoft.public.sqlserver.dts)