Dynamically setting the connection string expression

[dwango121]

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

[Shalex]

Yes, you can use the ConnectionManager class (http://msdn.microsoft.com/en-us/library ... nager.aspx). Please specify the errors you have encountered and the steps we should follow to reproduce the problem.