Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs going wrong

Jobs going wrong

Jobs going wrong

Hey All,

I created a DTS local packages that makes 1 big table from 5 other tables.
When i run the package from the local packages (execute package) IT pops up and runs perfect.  The data in the table is also correct so no problem there.

Problem starts when i right click the local package and shedule it and run it from the sql server agent / jobs
it crashes there and gives me the following error in the job history


Executed as user: FORCOM-NET\sr-sql. ...art:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_2   DTSRun OnError:  DTSStep_DTSExecuteSQLTask_2, Error = -2147217913 (80040E07)      Error string:  The statement has been terminated.      Error source:  Microsoft OLE DB Provider for SQL Server      Help file:        Help context:  0      Error Detail Records:      Error:  -2147217913 (80040E07); Provider Error:  3621 (E25)      Error string:  The statement has been terminated.      Error source:  Microsoft OLE DB Provider for SQL Server      Help file:        Help context:  0         Error:  -2147217913 (80040E07); Provider Error:  242 (F2)      Error string:  The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.      Error source:  Microsoft OLE DB Provider for SQL Server      Help file:        Help context:  0      DTSRun OnFinish:  DTSStep_DTSEx...  Process Exit Code 10.  The step failed.

From what i read he is having problems with conversion of char to date (witch i don't do ) but i have no clue how to advance from this point so any help is appriciated



RE: Jobs going wrong

I know your getting that strange error, but does it have anything to do with the service account?  When you execute SSIS via an agent job, it is running under the service account.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close