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 |
|
kraman
Starting Member
1 Post |
 Posted - 2008-01-14 : 12:14:55
|
| Hello, At our company we are considering building an architecture for file imports and processing and considering both Biztalk and SSIS at this time. My understanding from reading the material out there regarding this subject that Biztalk is more suited for integrating applications and real time communication of information and SSIS is more suited for bulk loads into databases/data warehouses and data manipulation. Currently we are somewhat along the lines described above, but there is a desire to use one technology over the other for importing files and data manipulation, and I am not sure that is practical. Also there is a debate currently as to whether Biztalk does better at handling logic than SSIS. I have read through the article on microsoft site that outlines the above - http://www.microsoft.com/technet/prodtechnol/biztalk/2004/whitepapers... However, I would like to get some input from people who have actually used both these tools in the real world for ETL process and could provide some insight so as to help us make an informed decision. Thanks KR |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-14 : 12:23:31
|
| worth reading:-http://geekswithblogs.net/wmichel/archive/2007/04/11/111470.aspx |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2008-01-15 : 09:13:11
|
| Most likely, you will need both.From all practical matters, it often starts with the one that your staff members have most of experiencs with, or the noe that is free of charge. Then when it reaches its limits to meet the needs, the other one starts to kick in.Well, if you further break down your requirements/environments, some of us here may be able to share some thoughs on how each tasks is handled under biztalk vs. ssis. |
|
|
|
|
|
|
Biztalk vs SSIS as an ETL tool