syntax error /SET "\Package.Variables[user::p1].Properties[Value]";+"FilePath"

• smvakumar

  SSC Enthusiast

  Points: 111

  More actions

  December 26, 2007 at 8:18 am

  #154033

  Hi Iam not able pass parameter to dts package frorm Stored Procedure....

  select @Cmd ='dtexec /server' simsqlwds01 /sql "\SIMSQLWDS01\DTS Packages\DTS Packages\FCE_Costing_Load1\CSV_to_Spell_STG"

  /SET "\Package.Variables[user::p1].Properties[Value]";+"FilePath"

  Iam getting following error .....

  *****

  Msg 102, Level 15, State 1, Procedure SpSpellSTGLoadFromCSV, Line 2

  Incorrect syntax near 'FilePath'.

  Msg 102, Level 15, State 1, Procedure SpSpellSTGLoadFromCSV, Line 6

  Incorrect syntax near 'simsqlwds01'.

  **********

  Can you help me out whts the syntax error at FilePath ?

• Norman Kelm

  SSCommitted

  Points: 1922

  More actions

  December 26, 2007 at 9:17 am

  #762700

  Does this work?

  select @cmd = 'dtexec /server simsqlwds01 /sql "\SIMSQLWDS01\DTS Packages\DTS Packages\FCE_Costing_Load1\CSV_to_Spell_STG"

  /SET "\Package.Variables[user::p1].Properties[Value]";'+"FilePath"

  I am assuming that FilePath is a column in a table?

  Norman

  DTS Package Search

  http://www.dtspackagesearch.com/

• smvakumar

  SSC Enthusiast

  Points: 111

  More actions

  December 26, 2007 at 4:27 pm

  #762820

  No It's runtime flat file connection.....

  ex : Filepath = 'c:\sachin\cvsfile.xls'

  Anyway thanx for u r reply.....Already i got that....

  Corrrect synatax is : ' + filepath +' '

  Syantactical error.....