| Author |
DTS transformation dynamic automatic matching columns
|
|
|
|
Hi,
I am copying about 100 tables from Base A to Base B and more exactly pat of
tables from Base A to Base B
example
copy 50 first line from A.dbo.table1 to B.dbo.table1
I use a loop that launches utility dtsrun with global variables
that take the source name and the destination name of the table
The problem is that it doesn't match automatically the columns and I have
an error!
How can do so that the column be matched automaticvaly as the source table
and the destination table are always the same?
Thanks a lot for your help. It's urgent!
mehdi
have created a package with a transform Data task and I would
--
mehdi
| |
| Allan Mitchell 2005-09-14, 8:24 pm |
| The problem you have is that just because you change the source and the
destination onjects DTS will not then do the automap for you if you are
doing this programmatically at runtime.
You will need to handle that yourself.
I have a package that does something crudely similar. You may be able
to match it to your situation. Ping me offline for the package.
Allan
"mehdi" <mehdi.achour@free.fr(donotspam)> wrote in message
news:455F534E-A05B-4092-A8F3- A15EF4EE7534@microso
ft.com:
> Hi,
> I am copying about 100 tables from Base A to Base B and more exactly pat
> of
> tables from Base A to Base B
> example
> copy 50 first line from A.dbo.table1 to B.dbo.table1
>
> I use a loop that launches utility dtsrun with global variables
> that take the source name and the destination name of the table
>
> The problem is that it doesn't match automatically the columns and I
> have
> an error!
> How can do so that the column be matched automaticvaly as the source
> table
> and the destination table are always the same?
>
> Thanks a lot for your help. It's urgent!
>
> mehdi
>
>
> have created a package with a transform Data task and I would
> --
> mehdi
| |
|
| Thanks for your help
Mehdi
--
mehdi
"Allan Mitchell" wrote:
> The problem you have is that just because you change the source and the
> destination onjects DTS will not then do the automap for you if you are
> doing this programmatically at runtime.
>
> You will need to handle that yourself.
>
> I have a package that does something crudely similar. You may be able
> to match it to your situation. Ping me offline for the package.
>
> Allan
>
>
>
> "mehdi" <mehdi.achour@free.fr(donotspam)> wrote in message
> news:455F534E-A05B-4092-A8F3- A15EF4EE7534@microso
ft.com:
>
>
>
|
|
|
|