Dynamic connection in Package Part Control Flow

Question

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

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.

I have created these variable

Then I have created two Flat File Connection Manager:

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

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

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.

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

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

I think you need to work with project parameters https://learn.microsoft.com/en-us/sql/integration-services/integration-services-ssis-package-and-project-parameters — Yahfoufi, Jun 06 '17 at 11:57
@Hadi : I tag you here because i think may be you know how can we have a dynamic connection manager in Package Part — Ardalan Shahgholi, Jun 06 '17 at 15:19

score 3 · Accepted Answer · answered Jun 07 '17 at 16:50

3

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

answered Jun 07 '17 at 16:50

Hadi

36,233
13
65
124

1

Thanks @Hadi. What do you think about new feature of SSIS 2016 name Template? – Ardalan Shahgholi Jun 07 '17 at 18:18
I didn't checked all ssis 2016 features. Are you talking about package templates? – Hadi Jun 07 '17 at 18:30
1

There is a new sub folder the same as Package Part in Solution Explorer. – Ardalan Shahgholi Jun 07 '17 at 19:24
@ArdalanShahgholi concerning package parts take a look at the articles i provided. They will give you a great overview. And they are talking about limitations and benefits – Hadi Jun 07 '17 at 19:36
1

I had seen the two last and I saw the first three. Thanks. I hop Microsoft in next version improve the Package Part. It can be very usefull – Ardalan Shahgholi Jun 07 '17 at 19:41
I agree with that – Hadi Jun 07 '17 at 19:43

Dynamic connection in Package Part Control Flow

1 Answers1