I am doing my first serious work in DTS. I have an Oracle db on server A and an SQL Server DB on server B. Here is my plan:
1) delete all of the records from several sql server tables.
2) Copy the contents of certain Oracle tables to their counterparts in SQL Server.
I have created two connections, one to Oracle (connection1) and one to sql server (connection2). I'm pretty sure that they both work. When I tested them, the test succeeded.
I have used the "execute sql task" icon (gold sphere with red arrow) to delete the record from each table. I have used precedence arrows (green & white arrow) to connect these steps. All of that works.
I have learned that you can use a black arrow (called "transform data task") to copy data from Oracle to SQL server. When I do that the step works.
My problem is aesthetic. I want a series of icons, each representing one step, and I want green arrows between them defining precedence. Then I want my connections out to the side, not connected to anything. That would make it easy to understand what is happening, when I return to this in one year, or when my colleague works on it. The black arrow attaches itself to my connection icons, and you can't point to it with a green arrow. Soon you have a crazy quilt of green arrows, black arrows, and connection icons.
I suspect that I need to use the "data driven query task" icon. But I can't quite get it to execute.
1) delete all of the records from several sql server tables.
2) Copy the contents of certain Oracle tables to their counterparts in SQL Server.
I have created two connections, one to Oracle (connection1) and one to sql server (connection2). I'm pretty sure that they both work. When I tested them, the test succeeded.
I have used the "execute sql task" icon (gold sphere with red arrow) to delete the record from each table. I have used precedence arrows (green & white arrow) to connect these steps. All of that works.
I have learned that you can use a black arrow (called "transform data task") to copy data from Oracle to SQL server. When I do that the step works.
My problem is aesthetic. I want a series of icons, each representing one step, and I want green arrows between them defining precedence. Then I want my connections out to the side, not connected to anything. That would make it easy to understand what is happening, when I return to this in one year, or when my colleague works on it. The black arrow attaches itself to my connection icons, and you can't point to it with a green arrow. Soon you have a crazy quilt of green arrows, black arrows, and connection icons.
I suspect that I need to use the "data driven query task" icon. But I can't quite get it to execute.