Using SSIS 2008. My SSIS package would move the order data to the relevant client DB. How do I pass in the order number while executing the package? Thanks.

In DTEXec you can pass some variables in like dtexec /f mypackage.dtsx /set \package.variables[myvariable].Value;myvalue Arthur My Blog

Do you have Order Number set up as a Variable? If so, you could use the /SET command switch when calling the package via DTExec command line. Read BOL for use of this tool and switch to SET the value of a variable (or other property) at run-time.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.