I am in a situation where we are redesigning our Datawarehouse. Currently we have our Datawarehouse in SQL 2000 and we are rebuilding from scratch in SQL 2005. This means that even though we will get the same tables but we are planning to rename each & every attribute to make it more meaningful.
The question is like this:
We can migrate the current DTS packages to SSIS but since all the ODBC connections , field names(attributes) will change is it worth it to leverages the DTS packages ?
Also we convert the julian date to gregorian date in our DTS packages but since SSIS has a feature to convert julian date it would be redundant to migrate the packages and my feeling is to create new packages in SSIS and start on a clean slate.
Is there anybody who was in such situation ?
Please advise.
Adarsh Mathur
Personally I would start with a clean slate. I think this will mean you are less likely to use DTS patterns and practices, which are often no longer the most appropriate (assuming they still work), when working in the brave new world of SSIS. Plan your ETL process, define the source to target mappings, and work from that rather using the DTS packages as the template.
No comments:
Post a Comment