redirect row on truncation

Question

Post reply

redirect row on truncation

Sailor

SSCertifiable

Points: 5246
More actions
August 19, 2020 at 4:54 pm

#3781698

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
123456@mysub.ourdomain.us
what gets inserted is the first 15
123456@mysub.ou
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.

Attachments:
You must be logged in to view attached files.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247158 More actions · Answer 1

Phil Parkin

SSC Guru

Points: 247158

August 19, 2020 at 5:06 pm

#3781712

What is your question?

Sailor SSCertifiable Points: 5246 More actions · Answer 2

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.

Phil Parkin SSC Guru Points: 247158 More actions · Answer 3

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.

Sailor SSCertifiable Points: 5246 More actions · Answer 4

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.

redirect row on truncation

Attachments:

Cookies on SQLServerCentral