Post reply

Error when exporting to a text file

  • October 2, 2009 at 8:33 am

    #156282

    I have a job that consists of 60+ packages. All of these packages exports data from one table to a flat file. The only difference between these packages is the select statement that is run for the source, and the destination file name.

    One of these packages is failing with the following error:

    Executed as user: xxxxxxx. Description: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was

    cancelled. End Error Error: 2009-10-02 02:49:03.96 Code:0xC0047021 Source: Copy data from SQL to Shared directory

    Description: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

    End Error DTExec: The package execution returned DTSER_FAILURE (1).

    Started: 2:49:01 AM Finished: 2:49:03 AM Elapsed: 2.25 seconds. The package execution failed. The step failed.

    The table structure of the table being copied is:

    CREATE TABLE [dbo].[MyTable](

    [Col1] [char](6) NOT NULL,

    [Col2] [char](4) NOT NULL,

    [col3] [varchar](14) NOT NULL,

    [Col4] [decimal](7, 2) NOT NULL,

    [Col5] [decimal](7, 2) NOT NULL,

    [Col6] [decimal](6, 2) NULL,

    [Col7] [uniqueidentifier] ROWGUIDCOL NOT NULL, CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED ([Col1] ASC,[Col2] ASC,[Col3] ASC)

    ) ON [PRIMARY]

    The select statement for the data being exported is:

    select Col1, Col2, Col3, Col4, Col5, Col6 from dbo.MyTable

    Most (but not all) of the data in col6 is null.

    I've been searching via google about this error: everything I've seen so far deals either with importing data from a progress database, or importing data from a text file. Most of the text file problems deal with character fields > 50 characters. None of my fields are that large, and I'm exporting data to a file, not importing it.

    Any ideas of what I need to do to make this work?

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • October 4, 2009 at 6:50 am

    #1061455

    Can you post the complete error log? The log you have posted is incomplete.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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