in Set Values tab,I set

I set Properties Path to:

\Package001.Variables[User::ConnectionString001].Properties[Value]

and Vaule is the actual connection string.

but still got the same error.

I changed Properties Path to:

\Package001.Variables[User::ConnectionString001].Properties[Value]

and Vaule is the actual connection string.

but still got the same error.

I highlight the connection in Data source tab, but don't see the expression and … that I can click to

You mean in Set Values tab?

I...

I have a SSIS package run fine in BID, but when run as a sql agent job, it failed at the error:

Argument "Server1" for option "connection" is not valid. ...

how can I use "XML file from variable" as I have a list of xml files? I use Foreach Loop container and able to get full path of xml file,...