I have a very simple dtsx package where I created a package parameter called pSourceFilePath and I set its connection string to a path on a local disk. I "parameterized" the connection string for the flat file connection manager and set it to point to the parameter (pSourceFilePath). Everything works great when I run it in Visual Studio.

But when I run it from a c# Winforms app (after I deploy the SSIS package to SQL Server), I set a package parameter with the path of the flat file I want the package to use as the data input for processing. The problem is: the package ALWAYS uses the value defined at design time in the flat file connection manager and not the pSourceFilePath parameter value that I set dynamically in my C# program and passed in.

How can I get the package to use the parameter value?

This is using SQL Server 2017 and Visual Studio 2017 (Winforms application).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.