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

SSIS Deployment Expand / Collapse
Author
Message
Posted Monday, September 10, 2012 11:20 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 6:01 AM
Points: 17, Visits: 148
Hi All,

I need a suggestion for ssis package deployment. In my solution 100 ssis packages are there, these are already deployed in production server.out of 100 packages 10 packages got failed in server.

In which way I can deploy only 10 packages using manifest file?
I don’t want to deploy all 100 files.

Please suggest me.Thanks in advance


Cheer's
Rajesh
Post #1357139
Posted Tuesday, September 11, 2012 3:18 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 6, 2014 11:47 PM
Points: 86, Visits: 214
If Packages are Deployed based on MSDB, Take up the 10 packages and Right Click on MSDB and import the Packages.

Else if you are using File System, go to the Physical File system and Replace the packages.
Post #1357224
Posted Tuesday, September 11, 2012 4:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 6:01 AM
Points: 17, Visits: 148
Thank's sudhir.
so manifest file is not need for every deployment?


Cheer's
Rajesh
Post #1357277
Posted Tuesday, September 11, 2012 4:28 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 6, 2014 11:47 PM
Points: 86, Visits: 214
yes...!
Post #1357283
Posted Tuesday, September 11, 2012 4:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 6:01 AM
Points: 17, Visits: 148
Thank's Sudhir.


Cheer's
Rajesh
Post #1357303
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse