Connection path to SQL Server

[Anonymous]

Hi guys,

i want to use generic load statement but the data is on the server and i made connection to the data but how can i write the connection path

swuehl‌

stalwar1‌

[Anonymous]

i am writing like this but it is not working :

FROM 'DEV1-PC-MSSQLSERVER2014 (desktop-dpummb2_yaman.dbo.ComplexType');

[sunny_talwar]

Once you have created a connection, you can pull data using one of the two buttons here

[Anonymous]

yes i did so and this is generated :

LIB CONNECT TO 'DEV1-PC-MSSQLSERVER2014 (desktop-dpummb2_yaman)';

but when i write generic load statement after From keyword which path i should write  .

[sunny_talwar]

What do you mean..?? It should look like this

Generic LOAD ....

...

...;

SQL SELECT ...

...

...

FROM ....;

[Anonymous]

i did as you said

now no error happens

but also i did not get the generic load

i got just the original table.

so can i solve it.

[sunny_talwar]

‌Can you paste the exact script you used?

[Anonymous]

[sunny_talwar · Accepted solution]

‌It seems that Generic load need 3 fields... you have way more

The Generic Load

[antoniotiman]

May be without Preceding LOAD

Generic

SQL Select * From ComplexTable;

However, are You sure You need Generic Prefix ?

You will get a complex model with a lot of tables.

Regards,

Antonio