Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSIS Export job works randomly

Posted on 2010-09-09
7
Medium Priority
?
204 Views
Last Modified: 2012-09-09
I have an SSIS export package used as a step in a job.  The job is called up through a stored procedure.  The job completes the first step (gather required data) and then fails 75% or more of the time on the export step.  In the app log the failure is listed as event 12291.  Package "xxx" failed.   The failure email notifications state that the export step was the last step to run.  

I would better understand the problem if it failed all the time.. but it just fails most of the time.  I'd like it to export the data 100% of the time as this is part of a complex setup I've established so that users can obtain these results.
0
Comment
Question by:rgolenor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 33640981
check your SSIS design:
see if it is your case:
" UNC versus mapped drives!
The manual process uses your credentials, which has a mapped drive reference.  The job uses the SQL Server Agent account, which does not"
more
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/b203daa3-cafc-4df9-9712-a8724b8aa910 
 
0
 

Author Comment

by:rgolenor
ID: 33641920
I am using a direct path ( E:\data\results ) so I not sure that the above applies.
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 33643030
where is the" E:\data\results" on your PC or on sql server?
can you try UNC path like \\yourserver\ShareWithSqlServerServiceAccountOrSqlAgentProxiAccountAccessPermissions?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:rgolenor
ID: 33647952
The  (E:\data\results) is on the sql server ... I tried the \\server\data\results  and it fails 100% of the time.
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 33649808
does sql service (sql agent ) account has Share\NTFS permissions on the \\server\data\results? Read\write?
--
if you login on the box as sql server service NT account - can you run the SSIS? What errors did you get?the same one?
0
 

Accepted Solution

by:
rgolenor earned 0 total points
ID: 33725637
I'm still not sure what to make of this... I've resolved it (sort of) by setting the retry on the step to 5 and the export fails (exports a blank file) typically and then will export the file with results on one of the retries.  Very odd.  Btw, all the share/security settings allow for access to the export folder.  
0
 

Author Closing Comment

by:rgolenor
ID: 38380557
It worked
0

Featured Post

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.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

705 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