May 16, 2012 at 1:41 am
Hello ,i'm newbie here ,i want to ask some help about data transformation system (DTS) .Here is the problem currently i'm using dts sql server 2000 to migration data from oracle to another database,file (xls,etc) and now i want to use sql server 2008 but i'm still don't know about DTS.How to use it ,how to program it ,the compatible of the program ,and the way to execute the package .
Can i still use DTS 2000 package in sql server 2008? and how to use it ?
where can i find the reference about this module ?
how bout the version of oracle that sql server 2008 support to run well??
Please really need your help >>>>
Thank you so much before and after
Best Regards
Jeff-Students
May 16, 2012 at 2:35 am
Yeah you can still use DTS in 2008, but I would recommend against it and re-write your DTS into SSIS as DTS has been depreciated since the release of SQL2005 and if I remember correctly is no longer available in SQL2012, so you will need to do this conversion at some point if you wish to upgrade to SQL2012.
What I would say is read through the SSIS stairway here[/url] to start to understand SSIS and refactor your DTS packages into SSIS packages.
Google will also provide you with some good resources on the topic of SSIS.
The basics of getting DTS to work in SQL 2008 can be found by reading this MSDN article here
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply