Hi,
I am creating one dts which access tables on my test db server. Now after
test i want to copy that dts on to my prod server. In that case tables will
be accesssed from prod server. Now problem is in transformation task i need
to change all the table names as they come with db.tablename format. Is
there any easy way of renaming all table name used in dts, or any other way
of doing this ?

Hello Vikram,

Yep.

If you refer to the datapump task then the destination does tend to have
DB.OWNER.TABLE. To eradicate this then use disconnected edit to edit the
pump properties.

Here is somewhere else this technique is useful

Make the Execute Package Task name dependent only
(http://www.sqldts.com/default.aspx?216)


Allan