Search
Active

12
Sign in to vote
0
Sign in to vote
Sign in
to vote
Type: Bug
ID: 484122
Opened: 8/20/2009 7:34:51 AM
Access Restriction: Public
0
Workaround(s)
1
User(s) can reproduce this bug
SSIS objects that use connection managers do so by the connection manager object GUID and not the name of the connection manager.
As a result when BIDS Helper's Reset GUIDs (or any other means of changing the connection manager's GUID value) is used object references are "specifically" coded to reference that package's connection manager.
For development productivity, if you subsequently copy and paste any SSIS object from one package to another after having previously setup connection managers using uniform names, all the pasted objects that contain references to these connection managers will produce an error "Connection manger {your GUID} does not exist. When opening an object with the error "Connection manger {your GUID} does not exist you will note that the Connection property value has a GUID rather than a named connection manager value.

Additionally, should you use SSIS variable's with property expressions to store your SQL, you will note that the varaible with the same name has no problem being referenced after performing the reset GUID.

The expected behavior in the scenario outlined would be that of all other SSIS objects, that is match based on object name not based on GUID.
Details (expand)
Product Language
English

Version

SQL Server 2008 - Developer Edition

Category

Integration Services (DTS)

Operating System

Not Applicable
Operating System Language
Not Applicable
Steps to Reproduce
1. Create a package containing a connection manager and execute sql task that uses the connection manager.
2. Create a second package containing a connection manager with the very same name as the first package (alternatively copy and paste the first connection manager to the second package).
3. Perform a reset GUID on the first package
4. Copy the execute sql task from the first package to the second package
5. Note error: Connection manager "{your GUID here}" does not exist.
6. Open second packages new execute sql task (copied from first package)
7. Note Connection property value: a GUID rather than a named connection manager
Actual Results
Pasted objects that contain references to these connection managers will produce an error "Connection manger {your GUID} does not exist. When opening an object with the error "Connection manger {your GUID} does not exist you will note that the Connection property value has a GUID rather than a named connection manager value.
Expected Results
Like all other SSIS objects the referenced in the package in which the SSIS object is being pasted, if made using the object type and object name, should resolve automatically.
Platform
32
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 8/27/2009 at 9:37 AM
Thank you for your submission. We will be reviewing your information and providing you feedback on our findings and progress. Thanks for your interest and support of SSIS.