I created a stored procedure with the command below. I want this stored procedure to execute a dtsx package using xp_cmdshell. The procedure was successfully created but when i try to run it the query just runs, never finishes. The dtsx package works, i've used it many times using xp_cmdshell, so i figured it would work through a SP so that i can call it from an application. Here is how i'm calling it
I have never used SPs before so please be clear when offering suggestions or questions.
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
-- This block of comments will not be included in
-- the definition of the procedure.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
-- Author: Yaniv Schiff
-- Create date: 3/16/2011
-- Description: Import SP WorkTick Data
alter PROCEDURE uspWorkTick
-- Add the parameters for the stored procedure here
@Path nvarchar(50) = 'c:\ImportWorkTickDB.dtsx'
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
exec Forensicon_Max105..xp_cmdshell @Path