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 12»»

How do I clean old data connections out of an SSIS package? Expand / Collapse
Author
Message
Posted Wednesday, March 26, 2014 5:40 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 8:54 AM
Points: 67, Visits: 135
Evidently deleting them from within the interface is not a reliable way of doing it.

I've got code referencing a data connection GUID that is not one of the showing data connections.

I'd like to NOT go deleting stuff from the XML text, just in case I get something wrong.

Is there a "CLEAN" function?



Post #1555227
Posted Thursday, March 27, 2014 2:09 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:21 PM
Points: 1,795, Visits: 4,681
No "clean" function that I know of, manual labour I am afraid.
To speed the process, use the property (F4) window, lists connections etc. of data flow and control flow components selected.
Post #1555300
Posted Thursday, March 27, 2014 8:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 8:54 AM
Points: 67, Visits: 135
What is the proper procedure when deleting stuff? What do I check for to make sure I don't take out too much or too little?

And, is there some better way of deleting through the interface to avoid this?

BTW, I think I'm on 2008, not 2005. That 2005 designator was not very evident when I originally posted.
Post #1555456
Posted Thursday, March 27, 2014 8:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:51 PM
Points: 13,639, Visits: 10,534
nonghead-webspam (3/27/2014)
What is the proper procedure when deleting stuff? What do I check for to make sure I don't take out too much or too little?

And, is there some better way of deleting through the interface to avoid this?

BTW, I think I'm on 2008, not 2005. That 2005 designator was not very evident when I originally posted.


Deleting through the interface is the only option available.
There is no warning if you are going to delete something that is referenced by another object.
So you just have to be careful and know your own packages




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 #1555462
Posted Thursday, March 27, 2014 8:55 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:21 PM
Points: 1,795, Visits: 4,681
You can query the xml package file to list all connections, look at this thread for more info;

http://www.sqlservercentral.com/Forums/Topic1380488-21-1.aspx

Post #1555473
Posted Thursday, March 27, 2014 9:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 8:54 AM
Points: 67, Visits: 135

So you just have to be careful and know your own packages


Unfortunately I'm "newer" to SSIS, and dealing with other people's packages (in part), but also my own.

I guess the overriding factor is "newby-er".

Good old Microsoft.
Post #1555499
Posted Thursday, March 27, 2014 9:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 8:54 AM
Points: 67, Visits: 135
If I wanted to remove all existing connections and rebuild them, is there a process for doing this so I don't end up with orphans again?
Post #1555517
Posted Thursday, March 27, 2014 11:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:51 PM
Points: 13,639, Visits: 10,534
Delete all connection manager, create your new ones. Open up each task and component and reassign to the correct connection manager.
Run the package. If there's an error, repeat the previous steps until there is no error.




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 #1555586
Posted Thursday, March 27, 2014 12:29 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 8:54 AM
Points: 67, Visits: 135
Koen Verbeeck (3/27/2014)
Delete all connection manager, create your new ones. Open up each task and component and reassign to the correct connection manager.
Run the package. If there's an error, repeat the previous steps until there is no error.


Actually, that's sort of how I got in the mess I'm in now.
Post #1555603
Posted Thursday, March 27, 2014 1:08 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:51 PM
Points: 13,639, Visits: 10,534
nonghead-webspam (3/27/2014)
Koen Verbeeck (3/27/2014)
Delete all connection manager, create your new ones. Open up each task and component and reassign to the correct connection manager.
Run the package. If there's an error, repeat the previous steps until there is no error.


Actually, that's sort of how I got in the mess I'm in now.


Well, you don't have to blindly hit the delete button.
Make sure the connection manager is not used when you delete it. Documentation can help in that regard.




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 #1555620
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse