Generating Package Configuration File for all SSIS packages

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Lanre Famuyide » Generating Package Configuration File for all...

Generating Package Configuration File for all SSIS packages

Rate Topic

Display Mode

Topic Options

Author

Message

Prashanth L.V.

Posted Friday, September 25, 2009 2:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:37 AM
Points: 2, Visits: 62

Hi Experts,

In my scenario, SSIS package gets created by a third party application and they dont use any configuration file. So, I am having trouble in change server, file location entries when I move these SSIS to new server.

So, I want to know, is there a way to generate configuration file for each SSIS package and store it in DB. When I move to new server, I will update configdb with new server name and file location and then is there a way to apply these change configuration from configdb to newly moved SSIS packages?

Post #793715

« Prev Topic | Next Topic »

Permissions