Error when starting the job in schedule mode

Last post 07-03-2009 2:40 AM by catherine germain. 2 replies.
Page 1 of 1 (3 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 07-01-2009 5:05 AM

    Error when starting the job in schedule mode

     Hi

     

     got the following error when starting a dst package in schedule mode, it work fine manually started

     

    he job delete the content of a table then import the data from an informix table in sql. The ODBC drivers are intalled on the machine


    tI /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Tableau Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

    Exécuté en tant qu'utilisateur : SRVARCH01\SYSTEM. ...Supprimer de la table [ADOS].[dbo].[aa_arch04] Étape   DTSRun en voie d'achèvement :  Supprimer de la table [ADOS].[dbo].[aa_arch04] Étape   DTSRun OnStart:  Copy Data from aa_arch04 to [ADOS].[dbo].[aa_arch04] Étape   DTSRun OnError : Copy Data from aa_arch04 to [ADOS].[dbo].[aa_arch04] Étape. Erreur = -2147467259 (80004005)      Chaîne de l'erreur :  [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified      Source de l'erreur :  Microsoft OLE DB Provider for ODBC Drivers      Fichier d'aide :       Contexte d'aide :  0      Enregistrements des détails de l'erreur :      Erreur :  -2147467259 (80004005) ; Erreur de fournisseur : 0 (0)      Chaîne de l'erreur :  [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified      Source de l'erreur :  Microsoft OLE DB Provider for ODBC Drivers      Fichier d'aide :       Contexte d'aid...  Code de sortie du processus 1.  L'étape a échoué.

  • 07-01-2009 7:52 PM In reply to

    Re: Error when starting the job in schedule mode

     Welcome to the forums!.

     

    Please, what OS and SQL service pack do you have?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    When the power of love overcomes the love of the power, the world will know peace.

    J. Hendrix


    All postings are provided “AS IS” with no warranties for accuracy.
  • 07-03-2009 2:40 AM In reply to

    Re: Error when starting the job in schedule mode

     On the server Window 2003 sp2 on the pc xm sp4

    I start on the pc

Page 1 of 1 (3 items)
Active Topics   My Discussions    Unanswered Posts


© 2010 Jude O'Kelly All Rights Reserved.