October 19, 2006 at 1:42 pm
2) Target OLAP DB design is derived from source OLTP.
3) Most master & transaction tables are as is but some target tables are a result of merging source tables.
4) We need to do SSIS packages based migration using column mapping & queries using Business Intelligence Development Studio (BIDS). There are no transformations required.
5) Some transaction tables columns data needs to be encrypted before migrating.
6) Can you please give me step by step procedure for carrying out this work. I have a short deadline and I am very new to this.
October 23, 2006 at 8:00 am
This was removed by the editor as SPAM
October 25, 2006 at 10:48 am
Step by step for this would be kind of hard as we don't really know your system details, but in a generic sense it would be something like:
Define Source Connection (your SQL 2000 server/database)
Define Target Connection (your SQL 2005 server/database)
Create whatever tables you may need to stage data if you can't massage it in-line (from your experience level, this may be the best bet.
Map data into the target staging tables - you can do this from multiple sources in the data-flow task using joins and similar.
You can run Execute SQL or Command tasks to encrypt data if it can be done through SQL or you'll need to figure out something in the Scripting transforms if you need to pull in a DLL to encrypt data.
Once you've scrubbed the data, export to its final destination.
There are some great books out there that could really help you in this. Professional SSIS, the new MS Press SSIS book, and I think there's even one on data warehousing and SSIS. If you search on a major booksite for "Integration Services" you'll come up with some good hits. You may also want to check out http://blogs.conchango.com/jamiethomson/archive/category/71.aspx or http://www.sqlis.com for some more information. They would be good starting points for some in-depth SSIS topics.
Hope that helps some.
-Peter Schott
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply