InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 18:15:54 GMT20http://www.sqlservercentral.com/Forums/Topic725376-148-1.aspxFor a start, try using single quotes around your literals ...--edit: You may first want to create an sp to help. Something like:[code]Create procedure [dbo].[s_ExecutePackage]@FilePath varchar(1000) ,@Filename varchar(128)asDeclare @cmd varchar(1000) select @cmd = 'dtexec /F "' + @FilePath + @Filename + '"' exec master..xp_cmdshell @cmdgo[/code]This will help you execute the package from within your sp, once you have enabled use of xp_cmdshell, of course.Thu, 28 May 2009 19:50:21 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic725376-148-1.aspxI am trying to execute a SSIS package that is stored in a SQL Server 2005 database - want to execute from a stored procedure in same database. What commands/operations are necessary.I tried: dtexec /SQL "\PKG_Name" /Server_Name "." /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E /De "Password"Msg 102, Level 15, State 1, Line 1Incorrect syntax near '/'.Thu, 28 May 2009 13:14:22 GMTnewbie123