August 19, 2020 at 4:54 pm
I kind of have this working, but for my test row, it did not output to the file. It is at least creating the files.
So employeenumber is nvarchar(15)
example data is
what gets inserted is the first 15
I have this set for the table:
I do have a couple of
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
August 19, 2020 at 5:06 pm
What is your question?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 19, 2020 at 5:35 pm
Instead of truncating and inserting as truncated, I want it to redirect row to the error output file.
It's not clear why it's truncating.
Thanks.
August 19, 2020 at 5:54 pm
The truncation is possibly happening earlier in the data flow process (so it does not throw an error when you expect it to).
You can check this using Data Viewers to verify exactly at what stage the truncation happens.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 19, 2020 at 7:22 pm
Data view helped, I never tried to get it going before. It's actually occuring on the data source. The file definition had char(15) for it and was set to ignore failure.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply