|
I have a situation where I need to make same changes or redesign 30 SSIS dtsx packages. Is there a way to do all 30 at one shot?
(comments are locked)
|
|
Well, depending on what you are attempting to change, I'd say yes. The packages themselves are just XML, so in theory, you could use a tool such as Notepad ++ or Powershell to locate what you want to change and then change it. However, I've never done this so I would strongly advise that you test the changes thoroughly to ensure that everything is working as expected. Hope this helps! You mean, I can open the dtsx packages through Notepad++ or Powershell and make the changes? Precisely, I am trying to change the design of the packages by putting a split in the Control flow by including sequence containers for each package.
Apr 12 '12 at 05:04 PM
zainssisJunkie
that might be a bit beyond the scope of an xml edit
Apr 12 '12 at 05:12 PM
KenJ
I would agree with @KenJ in that making that particular change is probably beyond the scope of what I suggested. Adding a split in the control flow is probably not something that I would try to script out. @Shawn Melton also had a good suggestion on some third party tools. I, however, don't have any real knowledge on either of them.
Apr 12 '12 at 05:19 PM
JohnM
As mentioned several time here. It's easy to edit the XML. I'ts ideal for adding common variables to multiple packages, adding/removing/altering configuraionts, logging options etc. This you easily achieve by any Text/XML Editor. (vent in BIDS when you open the source instead of designer). Othe othe other side, changes to the package structure especially affecting constraits is not so easy task for an editor. It would be possible tow rite a PowerShell script of a light .Net application which utilize SSIS assemblies for handlng the packages. Changes in the control flow are not so problematc and is should be realively easiy to add a sequence ad put control flow items into it. On the other side, altergin data flow transformations is much more complex :-). Anyway for 30 packages probably the uqickest way will be to open them and add the sequence container manually.
Apr 13 '12 at 05:30 AM
Pavel Pawlowski
(comments are locked)
|
|
With the changes you suggested in your comment it seems like changing the XML code on each file with a script is not really going to be an option. Trying to make that change in the XML code would be time consuming and probably not possible without screwing something up. Your safest bet is to just open each package up in BIDS and make your changes. You might consider looking at SSIS 3rd party software that can help with this and future projects. Pragmatic Works has BIxPress that can create a template to create new packages or alter current ones. Another software package that I have heard of is CozyRoc, but I don't know much about it.
(comments are locked)
|
|
I did have the same feeling. But, just wanted to check if there is any fast and safe available options. Since, I don't have enough time with me. I think I have to open each of them and make the changes. Thanks Guys!
(comments are locked)
|
