Get the Error Column Name in SSIS

Question

Post reply

Get the Error Column Name in SSIS

k.karthik0889

SSC Journeyman

Points: 99
More actions
October 28, 2018 at 3:50 pm

#367478

Comments posted to this topic are about the item Get the Error Column Name in SSIS

Viewing 7 posts - 1 through 6 (of 6 total)

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

RonKyle SSC-Dedicated Points: 31557 More actions · Answer 1

Thank you for bringing this to our attention. This doesn't make it easy, but it is certainly easier.

k.karthik0889 SSC Journeyman Points: 99 More actions · Answer 2

k.karthik0889

SSC Journeyman

Points: 99

October 29, 2018 at 8:40 am

#2011531

Thank you Ronkyle

k.karthik0889 SSC Journeyman Points: 99 More actions · Answer 3

RonKyle - Monday, October 29, 2018 7:20 AM
Thank you for bringing this to our attention. This doesn't make it easy, but it is certainly easier.

Thank you Ronkyle

sqlfriend SSC Guru Points: 52781 More actions · Answer 4

Thank you, this is very useful script!
Hope Microsoft can make the column Name available more easily in SSIS development tools.

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 5

Hey great find! I think this unfortunately highlights how ridiculous things in SSIS are, and how many hoops you have to go through to get what should be the most basic information about the execution of your package.

ebragas Grasshopper Points: 22 More actions · Answer 6

I was able to get the error column in at least one previous version of SSIS. It wasn't very difficult, either, though I don't recall exactly how it was done.