Changing connection table on existing step

[Brian Goodyear 3]

I have an existing DTS with a step that updates a SQL table. I need to edit that step to point to another table in the same SQL db (same connection). The new table has the exact same stucture of the existing of the table that is currently being updated. Is this possible

 

Existing Step

Connection: SQL DB

Data Object: TABLE1

 

What I'm trying to do and maintain links:

Connection: SQL DB

Data Object: TABLE2

[Audrey Buettner]

You can try DTSEdit.exe and change it inTarget Tables...Not sure how supported this is, so of course use a Copy first to test...

 

Some misc info on how to use the tool:

https://community.dynamics.com/crm/b/crmpowerobjects/posts/copying-scribe-target-steps-using-dtsedit