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.