DB to Excel

• Subu

  Say Hey Kid

  Points: 680

  More actions

  November 14, 2007 at 2:55 am

  #122439

  Hi All

  i am trying to do converting data from MSQL server 2005 to excel

  i have given all the detail oledbsource

  excel destination

  in the execution it will giving error like thisTITLE: Package Validation Error

  ------------------------------

  Package Validation Error

  ------------------------------

  ADDITIONAL INFORMATION:

  Error at Data Flow Task [Excel Destination [43]]: Column "Empname" cannot convert between unicode and non-unicode string data types.

  Error at Data Flow Task [DTS.Pipeline]: "component "Excel Destination" (43)" failed validation and returned validation status "VS_ISBROKEN".

  Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.

  Error at Data Flow Task: There were errors during task validation.

  (Microsoft.DataTransformationServices.VsIntegration)

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

  any body plz help me

• pjesrani

  Say Hey Kid

  Points: 695

  More actions

  November 14, 2007 at 10:31 am

  #751173

  Hi

  I am facing the same problem somebody please help

• Dr. John Tunnicliffe

  Right there with Babe

  Points: 782

  More actions

  November 14, 2007 at 5:03 pm

  #751305

  Easy, use Aspose.Cells to generate native Excel files directly from your Script Task or Script Component in SSIS. I recently posted a blog entry on how to get data from Excel using Aspose.Cells. Keep an eye on my blog and I will write another on how to generate Excel files from SSIS.