> Hi,
>
> I want to copy the data in tables from server A to files on the AS400.
> The
> table structure on the server is the same as the file on the
> AS400(same
> column names). In other words, the source and destination columns
> are always the same.
> I created a DTS that has the following tasks: dynamic properties task,
> SQL
> server connection, transform data task and a other connection(ODBC
> data
> source).
> I'm using global variables to dynamically set the source and
> destination
> tables names on the transform data task. The problem is the columns
> are not
> being automatically mapped and I'm getting an error message.
> Need help urgently!!! Thank you very much.
>

Cismail via SQLMonster.com wrote:
> Hi,
>
> I want to copy the data in tables from server A to files on the AS400. The
> table structure on the server is the same as the file on the AS400(same
> column names). In other words, the source and destination columns
> are always the same.
> I created a DTS that has the following tasks: dynamic properties task, SQL
> server connection, transform data task and a other connection(ODBC data
> source).
> I'm using global variables to dynamically set the source and destination
> tables names on the transform data task. The problem is the columns are not
> being automatically mapped and I'm getting an error message.
>
> Need help urgently!!!
> Thank you very much.
>
> --
> Message posted via http://www.sqlmonster.com