XML Task using Foreach Loop Container FileName

Bobby P 221 Reputation points
2021-07-06T19:51:50.663+00:00

We have a Control Flow XML Task which utilizes a XSLT Style Sheet to transform an aggregate list of .xml files. The aggregate list of .xml files is presented and coordinated by a Foreach Loop Container storing the collection into Variable Mapping User::FileName

We are wondering how then the array of values User::FileName from the Foreach Loop Container is presented within the XML Task? Through Input/SourceType = Variable and Source = User::FileName?

Do you have any examples of this you can show? YouTube? Maybe some insight as to how to build the Style Sheet.

This is all new to me...just trying to figure this out

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,449 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 32,411 Reputation points
    2021-07-07T05:37:20.33+00:00

    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

    0 comments No comments