Informatica to SSIS ETL conversion
-
Thursday, March 17, 2011 10:08 PM
Hello, If I replace my backend (oracle to SQL SR 2008) and ETL(Informatica to SSIS) for the datawarehouse, how easy to convert the current ETL to SSIS's ?
Also is there is any tutorials available for SSIS?
All Replies
-
Wednesday, April 13, 2011 7:38 PM
Hi,
SSIS tutorial; - http://msdn.microsoft.com/en-us/library/bb522499(v=SQL.100).aspx
As always I recommend the following book; - MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits) chapter 1 to 4 for further tutorials which cover a good introduction to the basics. I am also interested to find out if anyone knows of the best way of converting Informatica to SSIS since I have noticed a number of contracts advertised where the client is trying to do this very thing.
Kind Regards,
Kieran.
If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood- Marked As Answer by Mr. WhartyMicrosoft Community Contributor, Moderator Thursday, May 03, 2012 1:54 AM
-
Saturday, April 07, 2012 7:58 AM
I don't know and don't think there is an easy approach to convert ETL to SSIS. The only approach is we need to apply same business logic over there.
msdn it self is a good tutorial for SSIS. I can suggest below links they will give answers for your approach.
http://www.packtpub.com/article/term-extraction-tasks-in-sql-server-integration-services
http://msdn.microsoft.com/en-us/library/ms141134.aspx
Thanku,
If it is helpfull to you please vote them as helpful. If you have any questions please shoot them on to me.
Santhosh Gunnala
- Marked As Answer by Mr. WhartyMicrosoft Community Contributor, Moderator Thursday, May 03, 2012 1:54 AM
.png)
