Brian Goodyear 3 Posted June 26, 2019 Share Posted June 26, 2019 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 Link to comment Share on other sites More sharing options...
Audrey Buettner Posted July 2, 2019 Share Posted July 2, 2019 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now