Post reply

Error when running DTS as a Scheduled Job

  • September 22, 2008 at 4:48 am

    #123731

    I have a DTS set up which runs fine if I run it manually but as a scheduled job I get the following error:

    Executed as user: FFSQL1\SYSTEM. ...OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: ODBC--connection to 'FFREP' failed. Error source: Microsoft JET Database Engine Help file: Help context: 5003146 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -532678609 (E03FF82F) Error string: ODBC--connection to 'FFREP' failed. Error source: Microsoft JET Database Engine Help file: Help context: 5003146 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_3; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_3; 2000 Rows have been transformed or copied.; Percen... Process Exit Code 2. The step failed.

    Can someone please help?

    Thanks

    Nishid

  • September 22, 2008 at 5:18 am

    #874881

    Hi,

    It sounds like you don't have the ODBC connection set up on the server that hosts SQL. When you run a DTS pacakge from Enterprise Mangler on your machine it uses your local resources.

    Hth,


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • September 22, 2008 at 5:41 am

    #874893

    Sorry im relatively new to all of this, how would I do that?

  • September 22, 2008 at 5:46 am

    #874897

    You would need to (or get whoever set your ODBC connections up on your machine) get access to the SQL Server box and set up a new ODBC connection called FFREP pointing to the right place.

    Out of curiosity what type of datasource is FFREP pointing to, as I'm wondering if you actually need an ODBC connection?


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • September 22, 2008 at 6:38 am

    #874927

    FFREP is a DB on SQL Server it doesn't actually point anywhere but the data that is pumped into it comes from our data warehouse. thing is there are other scheduled DTS jobs that run fine.

    This DTS job gets data from an access DB and pumps it into a couple of tables in in FFREP.

    Hope this will help?

Viewing 5 posts - 1 through 4 (of 4 total)

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