Improve company productivity with a Business Account.Sign Up

x
?
Solved

I need help with SSIS in SQL Server 2012

Posted on 2014-02-24
1
Medium Priority
?
347 Views
Last Modified: 2016-02-10
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

Open in new window


Thanks in advance,
mrotor
0
Comment
Question by:mainrotor
1 Comment
 
LVL 5

Accepted Solution

by:
Bob Bender earned 2000 total points
ID: 39884430
maybe this link will help you in executing the dtsx file from a stored procedure

http://www.codeproject.com/Articles/27156/How-to-Call-SSIS-Package-from-the-Stored-Procedure
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question