Post reply

Finding my SSIS Package on Microsoft SQL Server 2005

  • December 12, 2007 at 8:27 am

    #69224

    I am just getting started with SQL 2005. I am trying to get familiar with the SSIS options in SQL 2005. I have created my package using the wizard to upload a flat file to the server....Where do my SAVED SSIS packages go when I save them???? Driving me nuts!!!

  • December 12, 2007 at 8:35 am

    #759429

    You may be looking in the database engine rather that the integration services engine.

    In object explorer click connect and go down to Integration Services then connect to Integration Services, then go -> stored packages -> msdb.

    This fooled me when I first migrated a package, maybe its the same on saved packages.

    Allen

  • December 12, 2007 at 8:45 am

    #759437

    Thanks Allan. I have since run into "Access is denied" problem again but that it being looked after. Our orginization is getting away from the as/400 and moving to Microsoft SQL so this package is new to everybody here....trial and error for the next few years I guess.

    Thanks again.

  • January 22, 2008 at 11:33 am

    #770582

    hi. you could have saved as dtsx package , when u set a schedule task there list of all dtsx will come.so u can choose from there.

    thx

    jith

    MCAD

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

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