The Msbiinfo provides maximum information about ssis,ssrs,sql server technologies and provides interview questions and videos and real time scenarios.
DTEXEC cmd is used to execute the SSIS package.see more details on below link:http://msdn.microsoft.com/en-us/library/ms162810.aspx
DTEXECDTExec /ISSERVER "\SSISDB\folderB\Integration Services Project17\Package.dtsx" /SERVER "." /Envreference 2 /Par "$Project::ProjectParameter(Int32)";1 /Par "Parameter(Int32)";21 /Par "CM.sqlcldb2.SSIS_repro.InitialCatalog";ssisdb /Par "$ServerOption::SYNCHRONIZED(Boolean)";Truehttp://msdn.microsoft.com/en-us/library/hh231187.aspx
DTEXEC cmd is used to execute the SSIS package.
ReplyDeletesee more details on below link:
http://msdn.microsoft.com/en-us/library/ms162810.aspx
DTEXEC
ReplyDeleteDTExec /ISSERVER "\SSISDB\folderB\Integration Services Project17\Package.dtsx" /SERVER "." /Envreference 2 /Par "$Project::ProjectParameter(Int32)";1 /Par "Parameter(Int32)";21 /Par "CM.sqlcldb2.SSIS_repro.InitialCatalog";ssisdb /Par "$ServerOption::SYNCHRONIZED(Boolean)";True
http://msdn.microsoft.com/en-us/library/hh231187.aspx