SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Agent Job error


SQL Agent Job error

Author
Message
dave.alexander1
dave.alexander1
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 290
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
Ed Wagner
Ed Wagner
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47435 Visits: 10844
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
dave.alexander1
dave.alexander1
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 290
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.
jasona.work
jasona.work
SSCrazy Eights
SSCrazy Eights (10K reputation)SSCrazy Eights (10K reputation)SSCrazy Eights (10K reputation)SSCrazy Eights (10K reputation)SSCrazy Eights (10K reputation)SSCrazy Eights (10K reputation)SSCrazy Eights (10K reputation)SSCrazy Eights (10K reputation)

Group: General Forum Members
Points: 9962 Visits: 12526
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.)
dave.alexander1
dave.alexander1
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 290
ok, thank you!
AndrewSQLDBA
AndrewSQLDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4346 Visits: 3427
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
dave.alexander1
dave.alexander1
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 290
Great! Thanks.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search