Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Agent Job error Expand / Collapse
Author
Message
Posted Tuesday, October 1, 2013 11:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 3, 2014 6:28 AM
Points: 7, Visits: 182
Hi,

I am experiencing the following error below. I have an update uncf processes job that has 35 steps. The job runs automatically until it gets to step 15 Create.CSV. I need to find out how to have the job run automatically through all 35 steps. Pls help! Thanks.


Update NCF Processes,Error,15,SQL04,Update NCF Processes,Create Update.csv,,Executed as user: NCF\sql_services. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:20:23 PM Error: 2013-10-01 12:20:53.63 Code: 0xC020200E Source: Create CSV Flat File Destination [2672] Description: Cannot open the datafile "J:\Projects\NS to SF\NS Contacts Update with Org\update.csv". End Error Error: 2013-10-01 12:20:53.63 Code: 0xC004701A Source: Create CSV SSIS.Pipeline Description: component "Flat File Destination" (2672) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:20:23 PM Finished: 12:20:53 PM Elapsed: 30.202 seconds. The package execution failed. The step failed.,00:00:30,0,0,,,,0
Post #1500506
Posted Tuesday, October 1, 2013 11:46 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:35 AM
Points: 4,482, Visits: 3,938
I must admit that I'm not even close to being an expert on SSIS, but database jobs run by executing one step after the other. If a step throws an error, the behavior is determined by the properties of the step.

The following line in the error is saying that it can't open a file on the J: drive:
Cannot open the datafile "J:\Projects\NS to SF\NS Contacts Update with Org\update.csv"

If this is a network drive, the drive must be accessible from the server when the job runs. If the drive isn't mapped, then a call to a drive letter will fail. Keep in mind that servers usually sit there without anyone logged in to them, so you might not have anything mapped.

You should be able to run the job in a test environment and have it run all the way through. If you can't, it'll tell you what step bombed and that's where you should focus your attention. If you fix the steps so they all run, the job should run through all 35 steps and succeed.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1500519
Posted Tuesday, October 1, 2013 12:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 3, 2014 6:28 AM
Points: 7, Visits: 182
Thanks for your response. The drive was mapped and it ran successfully until I had to go in skip a step in the job. It threw off the whole process unfortunately.
Post #1500545
Posted Tuesday, October 1, 2013 1:09 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 12:17 PM
Points: 737, Visits: 5,460
You also need to make sure that the user "NCF\sql_services" has access to the location you're trying to create the file in.

If it is a network drive, remember it won't be mapped if no one is logged into the server, so you'll either need to add a step to the job to map it (not sure how well this will work,) use the UNC path (which may require changing privileges for your SQL_Services user,) or create a proxy account (bit of a pain.)
Post #1500563
Posted Tuesday, October 1, 2013 2:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 3, 2014 6:28 AM
Points: 7, Visits: 182
ok, thank you!
Post #1500598
Posted Tuesday, October 1, 2013 7:41 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 7, 2014 2:00 PM
Points: 979, Visits: 3,364
You would be much better using a UNC path, instead of a mapped drive. Create a share on the other box, and use the UNC path.

Andrew SQLDBA
Post #1500638
Posted Wednesday, October 2, 2013 4:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 3, 2014 6:28 AM
Points: 7, Visits: 182
Great! Thanks.
Post #1500712
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse