Reading Connection string from Flat file Connection manager using Script task

In the script the task we can read the flat file connection string.

Let’s see how to read the Flat file connection string.

Creating a flat file connection manager. 

Now we are taking the script task and writing the below code to read the connection string.

public void Main()                                 {             string myFlatFileConnection =                             Dts.Connections["FF_Conn_Mgr"].AcquireConnection(Dts.Transaction)    as string;             MessageBox.Show(myFlatFileConnection, "Flat File Connection");                                                           Dts.TaskResult = (int)ScriptResults.Success;                                 }

 Running this task. 

Using this connection string we can perform the operation in the file.