Dynamically setting the connection string expression
Posted: Mon 26 Oct 2009 14:23
Hi,
Can anyone confirm that I can dynamically set the connection string expression in a Connection Manager using the dotconnect driver to a variable that holds the full path to a sqlite database.
I have successfully done this for a flat file Connection Manager for text files but when I try the above it just errors. I will post the exact errors later.
Thanks in advance for any help!!
Al
Can anyone confirm that I can dynamically set the connection string expression in a Connection Manager using the dotconnect driver to a variable that holds the full path to a sqlite database.
I have successfully done this for a flat file Connection Manager for text files but when I try the above it just errors. I will post the exact errors later.
Thanks in advance for any help!!
Al