question

paws27284 avatar image
paws27284 asked

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
ssisconnection-string
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
can you give your variable a default value? when you set it up in the variables screen, you should be able to enter a connection string that can be used at design time.
0 Likes 0 ·
paws27284 avatar image paws27284 commented ·
I'm afraid the way we are setup, there is only 1 value that can be used to connect. That's the value I need to store in the database.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.