Data export to Excel 2007 from ssis package

• Lucky9

  Default port

  Points: 1470

  More actions

  October 12, 2010 at 8:56 am

  #225015

  I am trying to export data from sql server 2005 which has

  more then 100,000 records into Excel 2007.

  to able to solve the task i was following steps

  New ole db Connection Manager

  Provider : Microsoft Office 12.0 Access Database Engine OLE DB provider

  Server or File Name : C:\Test

  All tab Extended Properties Excel 12.0

  SSIS package runs correctly but i do not see the data in the C:\Test file...

  Could someone please help me with the above task...

  i been working on this from past 5 hours...

  I have done this task before and i was able to load the data

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  October 13, 2010 at 12:14 pm

  #1236413

  Hi,

  Can you try first a shorter export, like 10 rows. Does it work ?

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/