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
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:
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
Dear Fernando!
Thanks for your visit and comments!
Of course you can! Just let me know the link! :-)
Regards,
Pedro
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
Post a Comment