Connection String Appearing with each and every table load

[Anonymous]

Hello Everyone,

I am connecting QS with Access DB and created a connection and inserted a string.

Now, If I am loading 5 tables then every time connection string is coming again and again...like

Tab1:

Lib to ...Connection String....

Load * from Customer;

Select * from Customer;

Tab2:

Lib to ...Connection String....

Load * from Product;

Select * from Product;

and so on...

Am I missing something? Please suggest

[Vasiliy_Beshentsev]

Hi, check out your script code. One connection string for one source of data is enought.

Lib to ...Connection String....

Tab1:

Load * from Customer;

Select * from Customer;

Tab2:

Load * from Product;

Select * from Product;

[Anonymous]

Yeah, I know...But when I insert a new table, Connection String automatically appearing again with every table load.

Why this is happening?

Is this the default behaviour of QS?

[Vasiliy_Beshentsev]

Provide screenshot of your code and load window, if you can.

[Anonymous]

PFA..

Check this

as every time Connection String statement is coming before load statement.

[Vasiliy_Beshentsev]

No need to do this every time. Check it.

[Anonymous]

I am not doing it...

Every time I load a new table, Connection string comes every time, why it is coming?

Am I clear?

[Vasiliy_Beshentsev]

Aahhh, yes. It is Sense paste this string by himself. It is standart operation when you using master wizard of data load.

You can ignore it and leave only 1 row in begin. Try out.