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

3 comments:

Anonymous said...

Hi Pedro, excellent post. I'd like to publish it in my blog (htttp://www.fp2.com.br/blog). Do you allow?

Best regards,

Fernando Prass

Pedro said...

Dear Fernando!
Thanks for your visit and comments!
Of course you can! Just let me know the link! :-)
Regards,
Pedro

Unknown said...

Good information...
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.
You deserve appreciations, first-class post.

ignite social media


LinkWithin

Related Posts Plugin for WordPress, Blogger...