none
Passing parameters to DDL statement?

    Question

  • Hi all of you,

     

    I'd like to know how could I add parameters to CREATE TABLE from a Execute Sql Task.

     

    Is it possible?

     

    TIA

    Thursday, July 12, 2007 12:16 PM

Answers

  • I don't know if you can add parameters (I suspect not, but I haven't tested it). Instead, why not use an expression-based variable to build your CREATE TABLE, then use the variable as the source for your Execute SQL.
    Thursday, July 12, 2007 8:34 PM
    Moderator

All replies

  • I don't know if you can add parameters (I suspect not, but I haven't tested it). Instead, why not use an expression-based variable to build your CREATE TABLE, then use the variable as the source for your Execute SQL.
    Thursday, July 12, 2007 8:34 PM
    Moderator
  • jwelch,

    Yeah, that's true. Thanks anyway.

     

     

    Friday, July 13, 2007 6:15 AM