Post reply

Deployment of SSIS packages

  • July 23, 2008 at 8:11 am

    #196009

    Hi, I have a couple of SSIS packages developed in my test server. I moved them to our production environment and scheduled them using windows scheduler. Everything going fine. But I did nt install them in the production server. just saved them in one of the drives. now my concern is why do we need to install the packges?? is it mandatory ?? can anyone please explain me about this?? bcoz I m tensed as i did nt install those and running them from drives

  • July 23, 2008 at 8:53 am

    #847102

    You do not need to store the packages in the MSDB database, you can store them on the file system as dtsx files and they will execute just fine.

    However, you will have to maintain backups of the files on the file system rather than just backing up the msdb database. They also become less accessible from other servers as you would have to create folder shares to get to them.

  • July 23, 2008 at 9:03 am

    #847116

    Thanks for the reply...just to be more specific, I did nt install those packages in the file system either...just saved in C: drive...thats it...so is it okay if we just have backup files for that?? and don't we have any use if we install those packages in filesystem or sqlserver??

  • July 24, 2008 at 8:24 pm

    #848172

    It is always better if we build and install using the deployment utility but even the way u did also works

    so not a problem.

    Regards
    Venkat
    http://sqlblogging.blogspot.com[/url]

  • July 24, 2008 at 8:27 pm

    #848173

    yep...Thanks a lot for the response...I m gonna leave the packages uninstalled....

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

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