Post reply

Scheduling a SSIS package

  • December 19, 2006 at 7:35 am

    #170784

    Can anyone please help me out with this problem. Like in sql 2000 if we have a DTS package we can schedule it as a sql job. IS there anything similar on sql 2005? I created a DTS package using SSIS and am now trying to scehdule it as a sql job but not sure where to start from.

    Any help will be greatly appreciated.

    TIA

  • December 19, 2006 at 8:36 am

    #678931

    Do you mean you created an SSIS package?

    http://msdn2.microsoft.com/en-us/library/ms141701.aspx

    http://p2p.wrox.com/topic.asp?TOPIC_ID=39302

  • December 19, 2006 at 10:28 am

    #678956

    Thanks for the response. I am able to set up a job to run the DTS package. I tried all 3 cases of selecting the DTs, FileSystem, SQL Server, Package Store but unfortunately it isnt loading the package. The log doesnt say anything in detail except "The package could not be loaded." or "Package execution failed" . Is it possibel to log message to know what excatly is failing or any other solution to this problem. Any help will be greatly appreciated.

    TIA

  • December 19, 2006 at 3:15 pm

    #679004

    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

  • December 20, 2006 at 7:06 am

    #679109

    I've found that, if I save the package in BIDS as a "copy of a ..." package, and then save it to package location "SQL Server", identify the server, and name the package path (I just put in the name of the package), then I can pull it up in a job step.

     

     

  • December 20, 2006 at 1:19 pm

    #679211

    I use metod1 from article http://support.microsoft.com/kb/918760 and it works just fine.  Good luck.

    P.S. My ssis packages are stored on the server

     

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

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