Hi All,
I want to use SQL Pass through and I'm using the below syntax .but I get the errors.can anyone help me in this regard.

-SET &SERVER =Server Name;
SQL SQLMSS SET SERVER &SERVER
SQL SQLMSS
SELECT
...
...
From Table Name..;
TABLE FILE SQLOUT
PRINT
..
..
END
-EXIT

What sort of errors? I usually just do
TABLEF FILE SQLOUT
PRINT *
ON TABLE HOLD AS xxxx FORMAT ALPHA
END

Then you can treat the hold file xxxx just like any other.

The syntax is something like this:

SET SQLENGINE = SQLMSS
SQL SET SERVER MSCRM
-RUN

SQL
SELECT
MSCRM.dbo.Contact.OwnerIdName,
MSCRM.dbo.Contact.CreatedOn,
FROM
MSCRM.dbo.Contact
WHERE
(MSCRM.dbo.Contact.DeletionStateCode = 0)
;
TABLE
ON TABLE HOLD AS H001 FORMAT ALPHA
END
-RUN

I get the following error.Do I need to specify the Connection Name anywhere..?

(FOC1671) SET SERVER IRF_STAGING COMMAND FOR SQLMSS INTERFACE OUT OF SEQUENCE

where can i specify the Connection name.Is it compulsory to specify the database name and Server Name for the pass through.

Regards,
MSAM

quote:

(FOC1671) SET SERVER %1 COMMAND FOR %2 INTERFACE OUT OF SEQUENCE
Before using a SET SERVER command the corresponding server with it's logon attributes (e.g. user and password) must be declared by SET USER command

The User ID and Password is included in the data adaptor connection setting when the security setting is "Explicit" in edasprof.prf:

ENGINE SQLMSS SET CONNECTION_ATTRIBUTES MSCRM banu1/admin,mypassword

The same command can be included in the FEX.