February 6, 2013 at 11:23 pm
Hi,
I have a ssis package in production. It is been deployed longtime back. Now we have got an requirement to add some columns to it. So we have the package ready.
In production, we do not have access to msdb folder . or i do not have access to target server where sql server in installed. I am doing remote connection from my virtual machine.
so can you guys please tell me how i shoud proceed? .
as per my understanding , I have to import and export packages from msdb folder. But when i try to import my updated package in virtual machine to msdb folder , Package path : dialog box shows me some folder 'ssis packages' etc., where my local vm directories didnt come up.
so how i should import my package.
As this is my first project in SSIS , i got struct at this point.
February 7, 2013 at 1:40 am
I'd say that your first task would be to get the package transferred to a location which is local to the server.
If you are using an RDP connection, that should be easy enough - just configure it to allow access to your local drive in the 'local resources' tab and then you'll be able to copy it.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
February 7, 2013 at 2:41 am
You can use dtutil to deploy your updated package to the server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 11, 2013 at 2:52 pm
we do not have access to msdb folder
Do you mean the folder in SSMS when you connect to Integration Services on your server, or some windows folder ?
----------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply