Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

syntax error /SET "\Package.Variables[user::p1].Properties[Value]";+"FilePath" Expand / Collapse
Author
Message
Posted Wednesday, December 26, 2007 8:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 7, 2008 9:30 PM
Points: 3, Visits: 34

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 ?
Post #436346
Posted Wednesday, December 26, 2007 9:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 4, 2012 1:34 PM
Points: 130, Visits: 322
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/



Post #436368
Posted Wednesday, December 26, 2007 4:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 7, 2008 9:30 PM
Points: 3, Visits: 34
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.....
Post #436518
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse