March 7, 2007 at 11:03 pm
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.
March 8, 2007 at 2:36 pm
Hi,
1. You are able to run DTS 2000 in SSIS, but I would recommend using SSIS from the start if they are going to be moving to it in the future.
2. I'm not familiar with informatica, but SSIS is a much better GUI than DTS 2000. however, it is very new and many people are still adapting. You'll probably find more information about DTS but with SSIS growing so much, it might get harder to find that information.
3. I would recommend doing everything in one or the other and not mixing.
4. Again, I would do one or the other.
5. I'm not sure what you mean by hierarchies.
March 8, 2007 at 7:14 pm
Thanks Stephen,
But the main issue is the client is horrible, doesn' understand.
He will get 2005 after 2 months.Now he want to begin with 2000 and then combine the next with SSIS.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply