Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Can't Run my SSIS Package on SQL Server Agent

Posted on 2011-10-21
6
Medium Priority
?
247 Views
Last Modified: 2012-08-13
Hi,

I am trying to run a SSIS Package I created using the import/export wizard.  I put the package on the SQL Server Agent and trying to execute it there.

Job Step Code:  dtexec /f "c:\pkgOne.dtsx"

It fails.

Regards,

Kelly

0
Comment
Question by:Kellylee22
  • 4
  • 2
6 Comments
 
LVL 8

Expert Comment

by:venk_r
ID: 37006917
Is the package saved to your local amchine?
0
 

Author Comment

by:Kellylee22
ID: 37007125
Hi Venk,

Yes, the package is saved to the local machine.  The package source connection is an Oracle query and the destination is a table on the local sql server machine.  I am now going to try it storing the package on the sql server and see if that makes a difference.
0
 

Accepted Solution

by:
Kellylee22 earned 0 total points
ID: 37007525
I was able to get the ssis package to run when I saved it to the sql server and then set it up on the agent.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 8

Expert Comment

by:venk_r
ID: 37007548
Good . That what I was about to address initially
0
 

Author Closing Comment

by:Kellylee22
ID: 37166467
Thankfully, I was able to resolve my own question.
0
 

Author Comment

by:Kellylee22
ID: 37153107
Closed.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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.
Suggested Courses

804 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