SQL Server - drop table not supported

Asked By John Grandy on 14-Mar-07 01:03 PM
I create an Execute SQL Task and add a connection and the sql

DROP TABLE Table1

Parse Query succeeds. But Build Query gives the error "The DROP TABLE SQL
construt or statement is not supported."

Baffling ...




Amarnat replied on 15-Mar-07 02:04 AM
John,
I think you are asking about SSIS related queries, and this group is for
Reporting Services.

Amarnath, MCTS