EDIS Online User Guide – SQL Command
The SQL Command stored procedure allows you to issue SQL commands to external servers via a server ID listed in table SSISDB.EDIS.lkup_server_id. This stored procedure is great for dropping/creating tables on other servers, indexing and aggregating data, and preparing data sets on other servers for a data transfer. Below are a couple examples:
|@srvr_nm||Server ID to issue the command against||None; Required|
|@sql_cmd||SQL Command to execute against the server ID||None; Required|
1. SQL Commands can allow multiple commands in a single transaction. Separate each command with a semi-colon. All commands will be ran in the order that they are listed.
Example 1: Creating a Table on a Teradata Server
Example 2: Dropping a Table on Another SQL Server if it Exists