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.

http://www.amosfivesix.com/sql/34-64-bit-sql-server-ssis-packages-with-excel-and-access-data

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s