Adding attributes to loaded files in-script

[#1]

Hello,

I was wondering if it was possible to insert extra attributes into records when they are being loaded. The equivalent in a SQL pull would be like adding:

"TEXT" as record_type

to a select clause.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Use the LOAD sentence to do that:

Customer:
LOAD CustID,
     CustName,
     'Customer' AS Type; // this is not in the SQL server
SQL SELECT CustID, CustName
FROM dbo.Customers;

Is that what you mean?

Miguel

[#3]

Single quotes! Of course. Thank you Miguel.