1. Change the DTS path and package name below in blue.
2. Change the Feed name below in purple.
3. Copy and paste modified text below to command window and execute.
DTEXEC /F "D:\BPMConnect\BPMC_IFramework\DTS\BPMC_ETL_Engine_v1.1.6.dtsx" /SET \Package.Variables[BPMC::I_Process_Name].Properties[Value];"CategoryList" /SET \Package.Variables[BPMC::I_Host_Connection].Properties[Value];\""Provider=SQLNCLI10;Server=NYCDBPC1;Database=BPMConnect;Uid=ETL;Pwd=0utbreak;\""
Wednesday, June 9, 2010
How to execute feed in SSIS mode via command line
Subscribe to:
Post Comments (Atom)
Good one, this is VERY handy
ReplyDelete