Hi, I need help on SSIS Package Script Component as source. The requirement is we have 3 input text files (fixed width format), which need to write allthese three files into different worksheets of the same spreadsheet(one excel file). Tried with Source Script Component with two outputs initially and Excel Destination for each file. Package is behaving unpredictable, sometime executing successfully and sometime giving errors as below. [Excel Destination 1 [96]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. [Excel Destination 1 [96]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Excel Destination Input" (107)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Excel Destination Input" (107)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Excel Destination 1" (96) failed with error code 0xC0209029 while processing input "Excel Destination Input" (107). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.  Please help I have some urgent deliverable. Thanks, Areef

if you get errors sometimes; then this should be related to data stream. as SSIS 2008 has no support for break points in script component, you can try use try catch and use StreamWriter to log error and corresponding data row(s) into a text file and run the package, after running the package you can check the text file for troubleshootinghttp://www.rad.pasfu.com

1) How can two excel destination access one single file at a time ?. ( Same locking as in Tables ) 2) Use some sort of delayed insertion for each work sheet. Cheers , Varun

Hi Varun, Thanks for your reply, Can I set order in Script Component output to excel destinations? As I have 3 outputs in script component. Where I have to add this delay? Please let me know Thanks, Areef

Hi All, Let me explain my requirement again, I have 3 input files(Fixed length fields) File 1: it has header like "Header 229" and footer "Footer 112" except this two rows remaining middle data I have to take. File 2: There is no header and footer, whole data I have to take. File 3: There is no header and footer, whole data I have to take. layout of each file is different like File1 first column name is "State" Postion 0-1, County Postion 1-3 etc. Now I have to loop throuhg each file, and create 3 excel worksheets with same file name and its columns. Then I have to publish data into each sheet of Excel file from the input files. For this, I am using Script componet source as input where I am building 3 ouput buffers finally sending data into 3 sheets of same file. Please let me know if my approach is wrong, suggest me the best approach to solve this problem. Thanks for all your help, Areef

Hi All, There is no much help on google on this script component as source with multiple ouput buffers... Please post any sample so that it will help anyone in future.. I solve this ploblem in different way as I have deliverable... but not happy I wasn't use script component.... Thanks, Areef