What is the preferred way to configure final builder to run SSIS packages in different enviornments?
we us SQL Command
###########################################################
DTexec /sql MYAPPLICATION\LoadPolicyMappingTables /SERVER %SSISJobServerName% /CONFIGFILE "\\%SSISJobServerName%\D$\SQL2005\DTSConfig\LoadMappingTables.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V
###########################################################
But it does not seem to pick up the config file and use it. Any sugessions or help document i can look at to run SSIS packages on SQL 2005 server.
thanks in advance,
-TD