2

I am new to ssis.I have a task where i need to import data from table to excel and table contains nearly 500K records.My problem is when opt for excel file destination and create a connection manager and use excel 2007 then i cannot see tables under name of excel sheet.when i tried to install access database engine i struck with error saying you cannot install 32 bit because you have installed 64 bit of Microsoft products.Please suggest

M.Ali
  • 67,945
  • 13
  • 101
  • 127
mamatha
  • 55
  • 7

1 Answers1

2

Here is a link to your access database engine driver. You can choose 32bit and 64bit. Remember to reboot.

Microsoft Excel ACE Driver

You could also choose a flatfile destination as CSV instead, and then load that in Excel. That is easier imo.

SqlKindaGuy
  • 3,501
  • 2
  • 12
  • 29