Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ag_dwh
Starting Member
1 Post |
 Posted - 2007-03-08 : 01:01:37
|
| I worked mainly on informatica , butmy company want me develop a datwarehouse using SQL Server.Presently they have SQL Server 2000. They want the first phase to be on 2000 using DTS and then subsequent phases in 2005 SSIS.Can someone help in answering my queries.1. Will I be able to run 2000 DTS in SSIS.2. Which one is easier DTS or SSIS. I have come to know that SSIS is like informatica and no need to right big big stored procedure as we do in DTS for ETL.3.If I make a part of Datawarehouse in DTS and the other in SSIS, will everything work.4.If suppose i have shared dimension "X".in the first phase it is populated by DTS and in the 2nd phase can i also polulate by SSIS simultaneously.5. Can I define hierarchies in DTS and SSIS. |
|
|
Antonio
Posting Yak Master
168 Posts |
Posted - 2007-03-09 : 06:50:41
|
quote:
1. Will I be able to run 2000 DTS in SSIS.
Yes you can. There is a "Execute DTS package Task" component available in SSIS.quote:
2. Which one is easier DTS or SSIS. I have come to know that SSIS is like informatica and no need to right big big stored procedure as we do in DTS for ETL.
SSIS once you get use to it. Separating the control flow from the data flow helps a lot. Variable scope is so much better. Logging info, error handling etc.. Once you get use to it ( I recommend you get yourself a book and use the MS online help) you won't want to go back to DTS again.quote:
3.If I make a part of Datawarehouse in DTS and the other in SSIS, will everything work.
Don't see why not but why aren't you using SSIS for the entire ETL project?!quote:
4.If suppose i have shared dimension "X".in the first phase it is populated by DTS and in the 2nd phase can i also polulate by SSIS simultaneously.
No idea...quote:
5. Can I define hierarchies in DTS and SSIS.
What hierarchies?_________________________________________________________________________________________________________________________Inability is a disaster; patience is bravery; abstinence is a treasure, self-restraint is a shield; and the best companion is submission to Divine Will. |
 |
|
|
ekb18c
Starting Member
18 Posts |
Posted - 2007-03-11 : 22:03:00
|
| My personal opinion on this is to either do all in DTS or all in SSIS. Yes, there is a task in SSIS to run DTS packages but there are features in DTS that won't work in SSIS. One prime example is dynamic properties in DTS. They won't work in SSIS. Also there little bugs/issues when using the task 'Execute DTS package Task' within SSIS. If your company wants to go ahead and use DTS first and then migrate over to SSIS, there will be packages that you may need to completely redo in SSIS. I'm in the process of writing some of my older DTS packages into SSIS because some of the functionality that used to work in DTS no longer works in SSIS. 1. Will I be able to run 2000 DTS in SSIS.Yes2. Which one is easier DTS or SSIS. I have come to know that SSIS is like informatica and no need to right big big stored procedure as we do in DTS for ETL.Of course I am going to say DTS is easier but that's just because I know DTS better than SSIS. 3.If I make a part of Datawarehouse in DTS and the other in SSIS, will everything work.Not necessarily.4.If suppose i have shared dimension "X".in the first phase it is populated by DTS and in the 2nd phase can i also polulate by SSIS simultaneously.Depends on what tasks you used in your DTS packages. |
|
|
|
|
|
|
DTS or SSIS