Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to update SSIS package on sql server Expand / Collapse
Author
Message
Posted Wednesday, February 06, 2013 11:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 6:55 AM
Points: 5, Visits: 12
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.
Post #1416814
Posted Thursday, February 07, 2013 1:40 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:02 AM
Points: 4,828, Visits: 11,182
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.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1416870
Posted Thursday, February 07, 2013 2:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 12,206, Visits: 9,169
You can use dtutil to deploy your updated package to the server.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1416907
Posted Monday, February 11, 2013 2:52 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:20 PM
Points: 220, Visits: 695
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 ?
Post #1418643
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse