DTS To SSIS Migration - Integration Services (SSIS) and DTS - LearnSqlServer.com's SQL Server Forums

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » DTS To SSIS Migration

DTS To SSIS Migration

Options

Previous Topic · Next Topic

syed_yp@yahoo.com

Posted: Monday, April 14, 2008 9:53:17 AM

Rank: Newbie

Joined: 4/14/2008
Posts: 3
Points: 9
Location: Dallas, TX

Hello Folks,

I have a situation here, i need to migrate a DTS to SSIS in which we are extracting data from Oracle. We are updating some data in Oracle, checking for some rows in SQL side and vice versa, like updating data in SQL side by looking some rows in Oracle.

I'm stuck, any help will be greatly appreciated.

Thanks,
Syed

Scott Whigham

Posted: Monday, April 14, 2008 10:59:37 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Hi Syed -

First question: do the DTS packages work already? I'm not 100% sure on your question (whether you want to know how to migrate from DTS to SSIS or from Oracle to SQL).

syed_yp@yahoo.com

Posted: Monday, April 14, 2008 3:15:48 PM

Rank: Newbie

Joined: 4/14/2008
Posts: 3
Points: 9
Location: Dallas, TX

Scott,

I have watched ur videos and know how to do some migrations from DTS to SSIS, but my question is, in there(working DTS packages presently) i have some TASKS which are pulling the data from ORACLE and updating in SQLServer and vice versa, my boss says i can't use LinkServer like they are presenlty using in DTS, instead he asked me to use regular OLE DB connection to conect to Oracle and redesign the packages.

Thanks,
Syed

Scott Whigham

Posted: Wednesday, April 16, 2008 9:25:15 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Okay - so no linked servers? No problem. You'll first need to add a Data Flow Task to the designer surface. Next you'll need to create an OLE-DB connection to Oracle and enter the correct info. That's really it - once you do that, you just need to define your ETL process with your choice(s) of transformation tasks. Have you been able to get the OLE-DB connection to Oracle to work?

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.