How to create a Data Flow Task when using a variable to pass the connection string for that task.
I am storing my connection information for external locations in the local host where the SSIS resides. My first step is to access the local host to get connection information and create a connection string variable. I set the expression on the connection string to the variable. Now I am trying to create the data flow task source to extract data from the external location. I continuously get errors saying I am not connected. I tried setting the connection manager first but since the variable is blank at pre-runtime, the connection manager is not connected. I am thinking I should disable the variable until after I have specified my source and destination for the data flow task, but how do I test that my variable is actually working? Have I confused you yet? In a nutshell, I connect to DB1 to get the connection string for DB2, then extract data from DB2 to DB1. Help??? Thanks! Paws27284