Post reply

DTS to SSIS migration complete - package execution failed

  • January 29, 2007 at 6:47 pm

    #115430

    Hi,

    I migrated a DTS package from sql server 2000 onto SSIS in sql server 2005. I am calling this package from a job. The main purpose is to copy a few tables from oracle to sql server and the data must always be available even if the job fails. What I did is create a staging area to copy it over and run the ssis package. If the package fails, the old copy is restored back so that the user is transparent for job failure. I got the job fixed but when I run the SSIS package, it gives an error message "package execution failed". I did change ownership of job to domain member. Still

    no success yet. Pls advise. Thx, Murali

     

  • January 29, 2007 at 7:00 pm

    #686350

    An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step

    http://support.microsoft.com/kb/918760

     

    MohammedU
    Microsoft SQL Server MVP

  • January 30, 2007 at 9:44 am

    #686505

    Thanks Mohammed.

    I tried different resolutions. The first 2 resolutions failed citing "unable to write storage file".

    The third resolution of "Set the SSIS package protectionlevel property to "EncryptSensitiveWithPassword" enabled me to add the password at the DTS package.

    How do I add this in the command line? I need syntax help here.

    Thanks

    Murali

     

  • January 30, 2007 at 10:18 am

    #686519

    I researched and added the /De "<pwd>" onto the command line and got the error "command line syntax issue should be equal to variable=value". I am unable to edit the command line on the job now since the changed one does not seem to appear.

    Thx

    Murali

  • January 30, 2007 at 12:51 pm

    #686578

    I have restored the old version and playing around to fix this issue.

    Thanks

    Murali

     

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

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