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
i am writing like this but it is not working :
FROM 'DEV1-PC-MSSQLSERVER2014 (desktop-dpummb2_yaman.dbo.ComplexType');
Once you have created a connection, you can pull data using one of the two buttons here
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 .
What do you mean..?? It should look like this
Generic LOAD ....
SQL SELECT ...
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.
Can you paste the exact script you used?
It seems that Generic load need 3 fields... you have way more
The Generic Load
May be without Preceding LOAD
SQL Select * From ComplexTable;
However, are You sure You need Generic Prefix ?
You will get a complex model with a lot of tables.
yes i need for some processing.
Now it is working
but i have one table shown in the following image called Syn 1 Table
i need to drop this table but when i want to drop it it doesn't appear when i go throw tables using NoOfTables() function !!!
No every thing is good.
the problem was with number of field i write after generic statement as Mr Sunny said.
Retrieving data ...