Creating a ssis package using sql server data tools

Question

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

SqlKindaGuy · Accepted Answer · 2017-09-14 10:39:39Z

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.

answered Sep 14, 2017 at 10:39

SqlKindaGuy

3,6172 gold badges17 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating a ssis package using sql server data tools

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related