Multiple OLEDB Connections?

[#1]

Hi

I have a Config file where I set an OLEDB connection, data paths and other variables  for a data loader.

Looking for suggestions on the best way if its possible, to define multiple OLEDB connections in the Config file then swap between connections as needed in the loader script.

Thanks in advance.

JHS

[Anonymous]

Hi ,

You can create a text file will all OLEDB connection information one by one for ex: dev, test and prod.

Use Include clause to reference the txt file with OLEDB connecation. At a time keep one connection is Uncommented and rest commented.

Suppose if you are in test , keep the TEST OLEDB connection un commented.

Script code is as follows:

$(Include=..\..\_DBConnection\DCTserver_Connection.txt);

Hope ths helps .

BR,

Chinna