CODEWITHSUNDEEP
sql-serverexcelssissql-server-data-toolsssis-2012
user1810575
user1810575

Reputation: 831

SSIS Excel to CSV - 64 bit True

I'm trying to convert excel(xlsx) file to CSV file - SSIS without changing 64 bit option.

All other packages run on 64 bit - True except this.

I have created a script task which doesn't work unless I turn 64 bit to False.

Used Excel source to Flat file destination works with 64 bit false but flipping back to 64 bit = true, things doesn't work anymore.

Is there a way to work with Excel and 64 bit = True in SSIS.

Need advice, Thanks!!

Upvotes: 2

Views: 640

Answers (1)

Yahfoufi
Yahfoufi

Reputation: 2544

I think you have to download and install the AccessDatabaseEngine 64bit

When searching on this issue i found these articles

They contains the full story :)

Upvotes: 1

Related Questions