November 14, 2007 at 2:55 am
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
November 14, 2007 at 10:31 am
Hi
I am facing the same problem somebody please help
November 14, 2007 at 5:03 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply