Transfering data from OLE DB To Excel file using SSIS

  • Hi

    I am trying to transfer only one column to Excel sheet from table.

    Could anyone kindly help me with an example if possible.

    Thank you

  • Try using the import / export wizard.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Need to perform some data type conversion .

    Ex : http://www.mssqltips.com/tip.asp?tip=1393

  • That article refers to an import to SQL Server, not an export to Excel.

    Can you try explaining what's going on?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Hi

    Depending on what type of export you need to do, there are few things.. If its a simple export then use the wizard else please post your question in detail..

    but again depending on what is being done you need to use the data conversion tool...

    cheers

    Vani

Viewing 5 posts - 1 through 4 (of 4 total)

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