January 18, 2014 at 10:12 am
Is there a way to deploy package without logging on server? From local machine or developer machine?
January 20, 2014 at 8:01 am
Anybody?
January 20, 2014 at 8:14 am
Not enough information. File system or SQL Server deployment? And what precisely do you want avoid doing - visiting the server physically, using an RDP session, mapping a drive to the server? Is it a single package or a whole project? Does it use Package Configuration and if so where are the configuration settings held?
John
January 20, 2014 at 8:22 am
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?
January 20, 2014 at 8:26 am
I don't use packages in msdb, so I'm not entirely sure. Are you using a deployment manifest? If so, you sholuld be able to just specify the location of the package, in this case msdb on a certain server. If not, you should just be able to save the package to SQL Server. Try it on a test server.
John
January 20, 2014 at 3:01 pm
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply