Dynamic excel file creation
-
Hello All,
I created a package that will create folder inside folder ,,... and is working fine for DFT with sql source and flatfile dest, but when I am trying with excel its giving me
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [Excel Destination [497]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.
Error at Data Flow Task [Excel Destination [497]]: Opening a rowset for "Excel_Destination$" failed. Check that the object exists in the database.
Error at Data Flow Task [SSIS.Pipeline]: "component "Excel Destination" (497)" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
Can anyone help me ??
Thanks
-
Does the Excel file already exist? I think it needs to. Stick with CSV if you can and save yourself a few headaches
-
Thanks Parkin for your reply.
I need my output must be in Excel, I found one of the articles where he is using a execute sql task to write in an excel sheet and he wants to give this as output to excel destination file, But i couldn't see the excel table creation in my destination excel file.
http://geekepisodes.com/sqlbi/2011/creating-excel-files-xls-dynamically-from-ssis/
CREATE TABLE `Pivot_Values` ( `ID` NVARCHAR(10)
, `column1` int
, `column2` nvarchar(10)
, `column3` money
, `column4` money
, `column5` money
)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply