Post reply

Export data into Excel 2007 from Sql server 2008

  • April 8, 2011 at 12:02 pm

    #145073

    Hi Below , what i did so far

    1) OLEDB source to get the data from the view

    2) data conversion task to convert the data

    3) Excel destination

    I had the Excel file created with the column name(Suppose 25 column).

    When I am mapping the data into the Excel Destination it show me less column than it suppose to be.

    I am my Excel file is in Excel 2007.

    I am using SSIS 2008.

    In my Excel file there are Extra column then source(Oledb Output) with Formula.

    I don't know but its not working.

    Is there any issue with Excel file or some thing ?

  • April 9, 2011 at 4:17 am

    #1309529

    You can try using the SSIS import export wizard. That should definitely get all the data exported. You can then use this to compare the package you created. 🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply