Post reply

SSIS

  • July 11, 2009 at 12:54 am

    #208096

    How do I manage my package configurations when my dev and prod happen to be the same server?

  • July 11, 2009 at 4:42 am

    #1023473

    I would use a config file and pass it when I call the packages.

  • July 11, 2009 at 10:34 am

    #1023533

    Hello,

    I do understand i have to have config files but do I need to create 2 different files one for dev package and the other for prod?

    Thanks

  • July 11, 2009 at 2:11 pm

    #1023552

    Yes, thats the way I would do it.

  • July 12, 2009 at 1:06 am

    #1023576

    hello,

    do i need to save them in 2 different folders one each for dev and prod server?

    thanks

  • July 13, 2009 at 8:16 am

    #1023903

    You need to have separate config files for dev and prod. How you store them is up to you, but one suggestion would be to use _dev and _prod suffixes on the filenames.

    You could deploy the package configured to use the dev file, and when setting up a job to run for production include a command-line switch to use the prod file.

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

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