May 14, 2012 at 9:17 am
Hello all,
I have setup a SSIS task for importing a csv flat file into an OLE DB destination. There are about 64,000 rows in the csv file. After about 51,800, my task is failing. In my data viewer, I'd like to see the record that failed (ideally) or if that's not possible, the one before the one that failed. Unfortunately, when I click the 'play' button in the data viewer, only 100 rows at a time are displayed. It would take 518 presses of the play button to get to the row where the task is faililng.
Without pressing 'play' 518 times, is there a way I can get the data viewer to display the rows as they are processed, and then stop when the task fails so that I can see the most recently processed row? Any suggestions would be much appreciated.
May 14, 2012 at 9:34 am
Not that I know of.
But there are a couple of things you can do.
1) Find a decent text viewer that will open big files quickly and allow you to navigate directly to the failing row. I use the (free) 'Large Text File Viewer' - pretty innovative name huh? Does the job.
2) Change the error output of the OLEDB destination so that it redirects errors to another table.
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
May 14, 2012 at 9:52 am
Thanks Phil, yes I was using textpad to do that, but was hoping to 'see what SSIS sees' aswell in the data viewer.
I just found out that you can click 'detach' in the data viewer and then 'attach' again right before the problem row, then click play to run on to the section where the problem is. Now I can see my data where the problem is, just have to figure out what it is!
Thanks again,
C
May 14, 2012 at 9:54 am
Really? Did not know that - thanks for sharing.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply