12ka4 Posted June 7, 2012 Author Report Posted June 7, 2012 Thank you all for your reply. I found the solution and it's working fine when my output file is a flat file. But when I am trying the same with excel output, I am getting errors .I need my output in excel. Can anyone help me with dynamic excel connection strings? Thanks,
12ka4 Posted June 7, 2012 Author Report Posted June 7, 2012 These are the errors I am getting. [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]Error at Data Flow Task [Excel Destination [497]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.[/background][/size][/font][/color] [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]Error at Data Flow Task [Excel Destination [497]]: Opening a rowset for "Excel_Destination$" failed. Check that the object exists in the database.[/background][/size][/font][/color] [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]Error at Data Flow Task [SSIS.Pipeline]: "component "Excel Destination" (497)" failed validation and returned validation status "VS_ISBROKEN".[/background][/size][/font][/color]
Ranga_The_Donga Posted June 7, 2012 Report Posted June 7, 2012 [quote name='12ka4' timestamp='1339089663' post='1301928717'] These are the errors I am getting. [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]Error at Data Flow Task [Excel Destination [497]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.[/background][/size][/font][/color] [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]Error at Data Flow Task [Excel Destination [497]]: Opening a rowset for "Excel_Destination$" failed. Check that the object exists in the database.[/background][/size][/font][/color] [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]Error at Data Flow Task [SSIS.Pipeline]: "component "Excel Destination" (497)" failed validation and returned validation status "VS_ISBROKEN".[/background][/size][/font][/color] [/quote] can u make running on 64Bit false....
Darling999 Posted June 7, 2012 Report Posted June 7, 2012 [quote name='Jeedeelu' timestamp='1339091160' post='1301928902'] can u make running on 64Bit false.... [/quote] Thats a Different Case, Idi Objects Missing antundi..
Ranga_The_Donga Posted June 7, 2012 Report Posted June 7, 2012 similar to ur prob.... [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]Since You are exporting to Excel, the "Opening a rowset for "Results" failed" [/background][/size][/font][/color] [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]indicates the receiving Excel File does not exist or does not have a worksheet with name "Results".[/background][/size][/font][/color] [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]Verify the Excel exists or is created during package run. [/background][/size][/font][/color] [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)](Excel Connection Manager controls the creation of Excel file).[/background][/size][/font][/color] [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]If "Results" worksheet does not exist, [/background][/size][/font][/color] [color=#444444][font=Arial, sans-serif][size=3][background=rgb(244, 248, 251)]you can add a create an "Execute Sql Task" to create the worksheet.[/background][/size][/font][/color]
12ka4 Posted June 7, 2012 Author Report Posted June 7, 2012 I am running with 64 bit false only. I used execute sql task to create a work sheet but it is not showing at the output excel sheet selection. I don't know how to get that excute sql task work sheet to get at the output excel sheet selection?
12ka4 Posted June 7, 2012 Author Report Posted June 7, 2012 ee link chusi try chesa,., [url="http://geekepisodes.com/sqlbi/2011/creating-excel-files-xls-dynamically-from-ssis/#comment-10277"]http://geekepisodes.com/sqlbi/2011/creating-excel-files-xls-dynamically-from-ssis/#comment-10277[/url]
Recommended Posts