Code to create table from variable in execute sql task

• robin712

  SSC Enthusiast

  Points: 107

  More actions

  June 11, 2008 at 7:54 pm

  #122600

  I did defined variable properly, what am i doing wrong on following code. I am trying to change file name dynamically

  'Create Table' + @[User::newfile] (

  [First] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [Middle] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [last] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [number] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [street] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

  ) ON [PRIMARY]

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  June 11, 2008 at 8:49 pm

  #827623

  The second part is not in quotes.

  'Create Table' + @[User::newfile] + '(

  [First] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [Middle] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [last] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [number] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [street] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

  ) ON [PRIMARY]'

• robin712

  SSC Enthusiast

  Points: 107

  More actions

  June 12, 2008 at 5:58 am

  #827769

  when i tried to parse. Is still says incorrect sysntax near 'create table'

• ravikumar_pasumarthi

  SSC Veteran

  Points: 283

  More actions

  June 12, 2008 at 7:31 am

  #827842

  Hi, replace the singe quote with double quote. The code in the expression box should be like this ....

  " "Create Table" + @[User::newfile] + "(

  [First] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [Middle] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [last] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [number] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [street] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

  ) ON [PRIMARY]" "

  This should work.