July 16, 2015 at 9:39 am
Hi, I have one SSIS package and one of it's data flow task does the following:
executes a procedure from ole db source
Derived column: one of the column has transformation with replace function.
Flat file destination: creates file and send it to shared location
There are three parallel iterations of the above three steps inside the data flow task. The package was working fine until yesterday and today it failed with some errors starting with following one:
Error: 2015-07-16 10:15:40.53
Code: 0xC0047070
Source: Generate Sales Data File
Description:
End Error
Error: 2015-07-16 10:15:41.01
Code: 0x80004005
Source: Generate Sales Data File
Description:
End Error
Any idea
July 16, 2015 at 10:20 am
Can you get a more comprehensive set of errors from the 'All Executions' report in SSISDB?
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
July 16, 2015 at 11:11 am
Apart from the above got the two following errors as well
Error: 2015-07-16 10:15:40.57
Code: 0x80004005
Source: Generate Sales Data File
Description:
End Error
Error: 2015-07-16 10:15:41.42
Code: 0xC0208265
Source: Generate Sales Data File OLE DB Source 1 [387]
Description: Failed to retrieve long data for column "SalesDetail".
End Error
July 16, 2015 at 11:34 am
sqlnaive (7/16/2015)
Apart from the above got the two following errors as well
Error: 2015-07-16 10:15:40.57Code: 0x80004005
Source: Generate Sales Data File
Description:
End Error
Error: 2015-07-16 10:15:41.42
Code: 0xC0208265
Source: Generate Sales Data File OLE DB Source 1 [387]
Description: Failed to retrieve long data for column "SalesDetail".
End Error
Presumably you've checked OLEDB Source 1 and there are no issues?
Is this package deployed to SSISDB? Are you unable to get full log information?
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