Post reply

SSIS errors and warnings, please help

  • December 4, 2006 at 7:05 pm

    #171491

    Hello All,

    I am very new to SSIS and SQL Server.

    I am trying to create a SSIS package.

    I have 2 Excel files.

    I am getting data from these 2 excel files  (each excel file has 2 worksheets) and merging the data after sorting.

    I am using left outer join.

    Initially there are 131000 rows in first data and I aggergate second data and get 40000 rows in second data

    after merge join, left outer join (131000 rows and 40000 rows) it says that it has only 65587 rows. I think it should say at least 131000

    Now I insert this data to a sql database table

    Also I want to insert data in one of the excel files.

    I use multicast to get 2 copies of the merged data one goes to SQL database and other for the excel file

    in databse data gets insert correctly (65587 rows), but for excel file it throws error

    like

    [Excel Destination 1 [11512]] Error: An OLE DB error has occurred. Error code: 0x80004005.

    [Excel Destination 1 [11512]] Error: The "input "Excel Destination Input" (11523)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Excel Destination Input" (11523)" specifies failure on error. An error occurred on the specified object of the specified component.

    [DTS.Pipeline] Error: The ProcessInput method on component "Excel Destination 1" (11512) failed with error code 0xC0209029. 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.

    Can Any body help me out.

    Also I receive lot of warning messages like

    [DTS.Pipeline] Warning: The output column "Area Code" (6305) on output "Merge Output 1" (6299) and component "Merge the two worksheets - the complete set of current data" (6264) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

    Thanks in advance

    Sunil

  • December 5, 2006 at 5:54 pm

    #676101

    Warning messages I am able to resolve.

    It was just not to select columns which are not going to be used in the process ahead.

    For errors, I suppose I was trying to write to excel worksheet which already has rows to the max capacity(65535).

     

    Thanks Guys,

    Sunil

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply