February 23, 2011 at 3:13 am
Hi,, all
i was developing one Extraction Package, it will be executed successfully
in command prompt and also dev environment.
but when i am trying to execute the same package in sql agent job
i was setting all the settings correctly, and configure the configurable file also
correct way, there is no job issue.
it will showing the below error,
can u any body suggest me how to resolve ,
An OLE DB error has occurred. Error code: 0x80040E07. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E07 Description: "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.".
February 23, 2011 at 3:16 am
It certainly looks like a data issue - are you sure that you have tested the package successfully in BIDS with the same data?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
February 25, 2011 at 2:13 am
hi, Phil Parkin
i am sure successfully executed in dev environment.
it's only happens in sql job it self
February 25, 2011 at 2:30 am
You did not really answer my question. Did you test with the same data?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply