Hi @Bobby P ,
Setting source type=variable means the XML task expects your variable to contain literal XML, not a file name. I think you'll want to keep the source type = file connection, but use a property expression on your Connection Manager to set it's connection string to @[User::XMLLoadFile].
As said here.
Details you may also refer this for the steps.
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October