msdb - SSIS question

  • Can any one say me what is the difference in uploading a package to file system and msdb. I understand that when u upload a package to file systme the package has to be locally and if u upload in msdb you can run the package from anywhere. Uploading the package to msdb will it increase the size of msdb?..Thanks in advacnce?

  • Can't speak to the first part of your post, as we load our SSIS packages to msdb. Yes, it will increase the size of your msdb database. The benefit is that your packages are backed up with the msdb database should you need to recover them in the event of a database failure. If saving the file to the file system, you need to be sure that it is also being backed up in case of a disk failure

  • thanks..

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

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