I need help with SSIS in SQL Server 2012

Hi Experts,
I created an SSIS package (.dtsx file) in my SQL Server 2012 server.  The SSIS package imports a file from a directory in our network and dumps it into a table in my database.  When I try to execute the .dtsx from a stored proc, nothing gets imported into my database.  See my stored proc code below.  Is the syntax correct?  What do I need to check?

BEGIN
DECLARE @params nvarchar(400)

SET @params = 'dtexec /file "C:\Trans\TransFEB_2014.dtsx"'

EXEC @returncode = xp_cmdshell @params, no_output

SELECT @returncode
END

Select allOpen in new window

Thanks in advance,
mrotor