Dashboard with more than 3 OLEDB Connections

[dseelam]

Hello All,

I have dashboard with more than 2 OLEDB connections I am using $(Include=..\Connection.txt); to include one connection how can I include remaining 2 connections in same text file ??? or do I need to put them in different text files and include them ?

Thanks in advance

Dinesh

[Aurelien_Martinez]

Hi,

You can include all your OLEDB connections in the same file.

But you need to use variable like :

SET vConnection1 = OLEDB CONNECT TO ... ;

SET vConnection2 = OLEDB ...

And in your script you use

$(Include=..\Connection.txt);

to load variable and for use it

//data load from connection1

$(vConnection1);

Table:

Load

  *

;SQL select from tableName

;

//data load from connection1

$(vConnection2);

Table2:

Load

  *

;SQL select from TableName

;

[dseelam]

Hello Martinez,

this is giving syntax error

$(vConnection1);

$(vConnection2);

thanks

Dinesh

[Aurelien_Martinez]

Yes, but that works