Sunday, February 17, 2013

BI Events - Oporto BizTalk Innovation Day











BizTalk Innovation Day is a one-day event focused purely on Microsoft BizTalk Server related topics that has been conducted in several major European cities since Feb 2011: Amsterdam (Netherland), Milan (Italy), and Stavanger (Norway). The last event took place in London and it was a huge success! It was fully sold out with 130 attendees from 16 different countries.
During this event participants will have an opportunity to hear about the new upcoming features in the BizTalk Server 2013 platform, integration strategies, private and public Cloud, and many more.

Join this five MVPs (Microsoft Most Valuable Professionals) and most active community members for a remarkable community event.

Read more here!

Saturday, February 9, 2013

BI Paper - SSIS Extract Data Multiple Worksheets

Some time ago in 2009, I wrote several papers from a community that I created in that year. But after the community website broke, I received dozens of requests to provide the papers for those who didn’t downloaded it at that time. For that reason I have attached to this post the paper again for everyone.

Scenario
Every month a company receive customers data from an excel file to extract and load data into an enterprise data warehouse. In brief, is required to extract data from a single excel file with multiple worksheets with same schema into a single destination table in SQL server.

I hope this paper could be useful

LinkWithin

Related Posts Plugin for WordPress, Blogger...