August 1, 2007 at 7:44 am
Hi All,
I wanted to know whether there is a way of Editing SSIS packages remotely and also deploying them remotely as well, so the user doesn’t have to remotely connect to the windows server in order to deploy SSIS packages.
The old SQL 2000 DTS would allow users to remotely create DTS packages and deploy it remotely.
August 1, 2007 at 7:49 am
So long as you can connect to the remove server via SQL, you can create it locally, and save it to MSDB on the remote server. To edit it, open it from the server and resave it to the server. Fiddly but doable.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 1, 2007 at 8:20 am
August 1, 2007 at 8:32 am
Yes it can. Open a solution in BIDS and add existing package. Choose SQL Server location. This will open the package from the server even though your client machine is sitting at the north pole.
You could probably put some security in SQL to stop any local accounts opening the package but off the top of My head, I don't know how.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply