SSIS, Excel, and 64-bit… getting them to play together.

Okay, I’ll admit that this post is a bit of a cop-out but if you landed here then you’re most likely having some troubles getting SSIS and Excel working correctly with some error regarding the usage of 64-bit drivers. Rather than going through each of the possible solutions, I’ll refer you to another blog that has links to several other blogs with several solutions. Each solution is different depending on your environment and your needs. In general, I try to avoid using Excel at all with SSIS and prefer to use CSV’s. Most business users can be convinced to save their data as CSV and it’s much more friendly for SSIS to process. It also removes all kinds of funky formatting that users love to throw in spreadsheets.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s