Agile BI Community

Community site for agile business intelligence developers
Welcome to Agile BI Community Sign in | Join | Help
Search
Home Blogs Downloads

Browse Folders

SSIS
Utilities (1)

SSIS Configuration Editor

File Details
Downloads: 2030 File Size: 410kB
Posted By: jwelch Views: 4008
Date Added: Sun, Apr 22 2007

This tool can be used to edit database or XML based SSIS Configurations.

 What it does:

  • Allows you to add, edit, and delete configuration items in existing XML configuration files.
  • Allows you to add, edit, and delete configuration items in existing configuration database tables.

What it doesn't do:

  • Create new XML configuration files from scratch. You have to start with an existing file.
  • Same thing applies for database tables.
  • It doesn't handle environment variable based configurations.
  • It doesn't validate what you enter. It's up to you to make sure the path is valid, and that the value can be cast to the correct data type.

 This is tool is under development, and has had limited testing, so use at your own risk. All the standard disclaimers apply.

 

Creative Commons License
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 United States License.

Comments
 

Maverick said:

Great tool !
Fri, Oct 26 2007 10:01 AM
 

Neel said:

Really usefull.. May I request a change in this tool. :) I need this tool to show existing configuration from some another tool. Can you provide a command line parameter which will accept the dtsConfig file name and It will open the supplied file whie opening the editor.
Mon, Aug 31 2009 5:17 PM
 

Logesh said:

Thanks for this post. I was able to add the properties using this tool, but when I try to open my package, I get package corrupted error.
Mon, Sep 14 2009 1:02 PM
 

Wolfgang Gottschalk said:

Nice Tool, thank you! for me, there is a little problem: In my package I switch the 'initial katalog' for a existing connection. So I have the same 'PackagePath' (In different 'Filter'). Filter ConfiguredValue PackagePath f1 tempdb .Properties[InitialCatalog] f2 mydb .Properties[InitialCatalog] The tool can't read this (Error Message: duplicate Key). But this is false. The (unique)Key is not 'PackagePath'. It's a combinated key (Filter, PackagePath).
Thu, Oct 15 2009 10:45 AM
 

Luis said:

Hi, I have to do a program like yours in c# but I don't know "how to fill a datagrid with a xml file" and after save the changes. Would you help me with this.
Thu, Oct 22 2009 4:37 PM
 

john david said:

thanx
Wed, Mar 03 2010 5:31 AM
 

Mattresses said:

I too was able to add the properties using this tool. But having some problem. Regarding the things not same and showing the corrupted error same again and again.
Wed, May 05 2010 12:01 PM

Add Comment

Name (required)
Web Site (optional)
Comment (required)
Add
Powered by Community Server (Personal Edition), by Telligent Systems