• SQL_Surfer (1/20/2014)


    For new packages and old packages; package will reside in MSDB. I am trying to avoid RDP access to users to logon to server and deploy that way. I haven't tried package configuration yet. Old packages are not deployed using package configurations. To edit and deploy, is there any alternatives for developers without logging onto server?

    Packages should be developed locally using Visual Studio.

    When they are ready to be deployed to the server, you can use dtutil to deploy them.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP