CODEWITHSUNDEEP
sql-serverssisetlssis-2016
Ardalan Shahgholi
Ardalan Shahgholi

Reputation: 12575

Dynamic connection in Package Part Control Flow

I use SSIS 2016. I have created a Package Part Control Flow as you can see in this image :

enter image description here

The perpose of this Package Part Control Flow is to have a loop on the all files in one folder and transfer all files to another folder.

I have a Foreach Loop Container and a File System Task.

enter image description here

I have created these variable

enter image description here

Then I have created two Flat File Connection Manager:

enter image description here

Now I need to configure expressions for Connection String of each Flat File Connection Manager.

enter image description here

But as you can see I don't have access to my variables.

enter image description here

I need to be able to configure my connection managers inside the Package Parts Control Flow and then in package where I use this Package Parts Control Flow I will pass the values of variables.

enter image description here

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

enter image description here

Can I have an expression on ConnectionString of Flat File Connection Manager inside the Package Parts Control Flow by using the variable?

Upvotes: 4

Views: 1120

Answers (1)

Hadi
Hadi

Reputation: 37348

After reading multiple articles and users feedbacks.

Unfortunately, you cannot use dynamic connections with package parts.

Control flow Package parts has some limitations, which make it useless in many cases.

References

Upvotes: 3

Related Questions