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