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

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 (AT) free (DOT) fr(donotspam)> wrote