I'm having issues with connections on my objects. On the GUI there is no issues, everything works fine, I can see files, do lookups, map to destinations but as soon as I run the package I get this error:
[SSIS.Pipeline] Error: Cannot find the connection manager with ID "{7161BF4A-C0EC-42AC-BB83-52A0D0B498CF}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "Dest-Supplier.Connections[Devart MySql]" in the connection manager collection of "Dest-Supplier". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.
I've checked the XML and the connection is definitely there...
Code: Select all
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[Target]"
DTS:CreationName="DevartMySql"
DTS:DTSID="{7161BF4A-C0EC-42AC-BB83-52A0D0B498CF}"
DTS:ObjectName="Target">
<DTS:ObjectData>
<MySqlConnectionManager>
<ConnectionString>User Id=root;Host=WEB01;Database=AE_TEST_AP;Unicode=True;Persist Security Info=True;Default Command Timeout=6000;Connection Timeout=6000;Connection Lifetime=6000;HTTP Max Connection Age=6000;HTTP Keep Alive=6000</ConnectionString>
<Password
Sensitive="1"
Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAADoBXtlShi0WjQ2PBNLZTIgAAAAAIAAAARABUAFMAAAADZgAAwAAAABAAAAC+h7YkUSQsxGBaMcc0PP1LAAAAAASAAACgAAAAEAAAALvX9zNlyUCLU3M6MBiMclYgAAAAdDX0AWz0t8a2L1+CDq5KtIjlvjChbP/ccTU2DjwKzGQUAAAAhBxIlKUhQJ6An6LZVhMeWVSJBI0</Password>
</MySqlConnectionManager>
</DTS:ObjectData>
</DTS:ConnectionManager>