I am trying to follow this and am getting an error regarding my connection string. I have set the environment variable and set the package configuration to use it but I get:
'The connection string format is not valid'
It is the same connection string that is in the properties of my connection manager so I am not sure why it doesnt like it.
Anyone else get this?
Thanks in advance...