InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 06:48:51 GMT20http://www.sqlservercentral.com/Forums/Topic412290-146-1.aspxEnabling xp_cmdshell just to execute the SSIS package? You already have the Integration Services Package step type in the agent job configuration. If you decide to call it from CMD anyway then you have "CMDExec" step type availabe in the job configuration.Fri, 16 Mar 2012 07:13:21 GMTDivine Flamehttp://www.sqlservercentral.com/Forums/Topic412290-146-1.aspxYou could also call the SSIS package directly too if you wantedDECLARE @sqlCmd VARCHAR(1250) -- call to ssis package ,@returnCode INT -- returncode from package execution ,@ssisPath VARCHAR(1250) - location of ssis packageSET @ssisPath = '\\server\ssis\mySSISPackage.dtsx'SELECT @sqlCmd = 'DTEXEC /F "' + @ssisPath + '"' -- call ssis package and return resultEXEC @returnCode=Master..xp_cmdshell @sqlCmd SELECT @returnCode AS '@returnCode'Fri, 16 Mar 2012 06:56:32 GMTmark_copleyhttp://www.sqlservercentral.com/Forums/Topic412290-146-1.aspxadd a new job step. In the Type dropdown, select sql server integration services package. then you need to fill in the appropriate tabs. what you will fill in may vary greatly, so I can't really go into what you will need in there, but hopefully this gets you on your way.Thu, 18 Oct 2007 09:59:15 GMTAdam Angelinihttp://www.sqlservercentral.com/Forums/Topic412290-146-1.aspxI have a SQL job that kicks off to populate some tables with test data. I also have an SSIS package that copies the data to another development SQL server called ScrapAllData_RePopulate.Within the SQL Agent job I want the final step to kick off my SSIS package. Can someone give an an example of how to do that?ThanksThu, 18 Oct 2007 09:35:44 GMTWarren Peace