Dynamic connection in the package control flow

I am using SSIS 2016

. I created Package Part Control Flow

, as you can see in this image:

enter image description here

The subject of this Package Part Control Flow

is to have a loop for all files in one folder and move all files to another folder.

I have Foreach Loop Container

and File System Task

.

enter image description here

I created this variable

enter image description here

Then I created two Flat File Connection Manager

:

enter image description here

Now I need to configure expressions

for Connection String

for each Flat File Connection Manager

.

enter image description here

But as you can see, I have no access to my variables.

enter image description here

I need to set up the connection managers internally Package Parts Control Flow

and then in the package where I use this one Package Parts Control Flow

, I will pass the variable values.

enter image description here

The way I would like to send the value for the variables Package Parts Control Flow

.

enter image description here

Can I have an expression in the ConnectionString

Flat File Connection Manager

inside Package Parts Control Flow

using a variable?

+3


source to share


1 answer


After reading several articles and user reviews.

Unfortunately, you cannot use dynamic joins with parts of a package.

Control Flow The batch parts have some limitations that make it useless in many cases.



Links

+1


source







All Articles