Hello
I have a package that transforms some data into a table
(test, will eventually do a number of these transfers)
It has a dynamic properties task along with a source and destination OLE DB Connection
There's a transform data task between the source and destination servers
I have created a package that runs this package and passes through the source and destination database/server
Problem is, it just does not work
It runs how it was originally created and ignores the parameters passed through
Does anybody know why as this has been puzzling me for some time now - it's getting a bit frustrating!!
I don't know if this is the issue - the destination table shows a fully qualified table name (including original
database)
I can't get this to change
Thanks for any help
I have a package that transforms some data into a table
(test, will eventually do a number of these transfers)
It has a dynamic properties task along with a source and destination OLE DB Connection
There's a transform data task between the source and destination servers
I have created a package that runs this package and passes through the source and destination database/server
Problem is, it just does not work
It runs how it was originally created and ignores the parameters passed through
Does anybody know why as this has been puzzling me for some time now - it's getting a bit frustrating!!
I don't know if this is the issue - the destination table shows a fully qualified table name (including original
database)
I can't get this to change
Thanks for any help