SSIS process fails as a job but not when manually executed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » SSIS process fails as a job but not when...

SSIS process fails as a job but not when manually executed

Rate Topic

Display Mode

Topic Options

Author

Message

private.2010.skipp

Posted Friday, November 23, 2012 12:34 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, December 02, 2012 10:21 AM
Points: 2, Visits: 11

Hi

I have a SSIS process that is failing on a data pump step when it is executed as a job. The error is due to a conversion from date/time to a string. However, when I run the same process manually on my PC it does not fail. I also had a look at the actual date columns to see if there were any invalid dates, but could not find any.

Does anyone perhaps know as to why the process fails when executed as a job and not when it's manually executed?

Post #1388235

Phil Parkin

Posted Sunday, November 25, 2012 4:51 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:13 AM
Points: 4,227, Visits: 9,460

Could it be that the server's default date format is dd/mm/yyyy and your PC it is mm/dd/yyyy (or vice versa)?

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1388383

private.2010.skipp

Posted Monday, November 26, 2012 11:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, December 02, 2012 10:21 AM
Points: 2, Visits: 11

No, the date format of the server has not changed as other processes that uses a date would also have failed. So I'm not sure why this is specific process is always failing.

Post #1388749

Bruce W Cassidy

Posted Monday, November 26, 2012 1:05 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, March 22, 2013 11:49 AM
Points: 945, Visits: 998

private.2010.skipp (11/26/2012)

No, the date format of the server has not changed as other processes that uses a date would also have failed.

Check the default language for the SQL Server login that the job is running under. That can be different to the default language for the server entire.

Hmm, if you're reading from a text file, the chances are the date format at issue may actually be associated with the Windows login that the job is running under. Checking that would be a good idea as well.

Post #1388803

« Prev Topic | Next Topic »

Permissions