How to Troubleshoot Data Flow Task Errors and Warnings in SSIS
- by Scott Whigham on October 15, 2009 6:17 AMSSIS has its quirks, no doubt, but one of the more frustrating things that I’ve seen newbies struggle with in class is how to troubleshoot the various validation and conversion errors and warnings in Data Flow Tasks. Do these look familiar?
Of course these look familiar – you see this all too often in SSIS. In particular, these errors are a Truncation warning and a data conversion error respectively. In the Designer (the name of the window in which we drag/drop our SSIS tasks and Data Flow components), we only get a weeeeeeee bit of information about the error. There are a few problems with troubleshooting based on this scant bit of info – let’s take a look at the data conversion error as an example.
The data conversion error’s text – the text that we can see in the Designer – says, “The column "EmployeeId" can't be inserted because the conversion between types DT_R8 and DT_I4 is no…”. Hmmmm – okay: from this tiny bit we can tell that there is a problem with the “EmployeeId” column and we can see that the source/destination data types are very different: the source is float (“DT_R8”) whereas the destination column is an integer (“DT_I4”). Makes sense – we don’t want to lose decimal places so, “Thanks for the error, SSIS!”
But is the EmployeeId column the only error or are other columns also experiencing type conversion errors? We can’t tell from the little error message we can see. Unfortunately there is no obvious way to see (a) the full error message (notice how the little ellipsis implies there is more but there is no obvious way to view the rest of the error), and (b) there is no way to determine if there are other columns experiencing similar errors.
The Fix
The error information can easily be seen with the Error List window:
When you view the Error List, you will see the full errors and in a “One error per entry” format – like this:
We can quickly see that there are two errors and four warnings:
If you click the tabs, you can isolate one or the other – you can just view the errors or just view the warnings.
I hope this makes it easier for you to troubleshoot SSIS errors!
P.S. – If you like this, you might also like my SSIS 2005 course over at http://www.learnitfirst.com/
In most cases I do not make a comment on blogs, but I want to say that this post really forced me to do so. Really nice post!
Akumal is one of the best place to snorkel at. The water is crystal clear and there is all kinds of wild life. From turtles to seaguls. Akumal beach is one of my favorite place in akumal to snorkel.
I have found an excellent outlet for shoe inserts and would really like to share it with your readers, I hope this is okay?
Nice one, there is actually some great facts on this blog some of my friends will maybe find this interesting, I must send them a link, many thanks.
In case you are experiencing problems with your Playstation 2 laser (or other part inside for that matter) and have to open it up, have a shot at the Console Toolkit. It is a universal opening tool for ALL videogame consoles on and off the market. A plastic card showing what tool to use for each unit is included. Check my link if you would like to find out additional details regarding this particular product.
Excellent website! Have checked out the NEW Playstation3 WiiJoystick ;-)? is kinda cool, I have added a movieclip on new blog. if you have a min check my profile link or go to move-motion-controller.com
Cool Blog! Have anyone checked out the NEW PS3 Motion Sention joypad? is kinda cool, I have added a clip on my new blog. if you like check my profile link or go to move-motion-controller.com
Excellent and clean site you have! I have created a new website, if you are interested in XBOX 360 Game Torrents you must love it! the address is games-iso.com
Intesting and clean blog you have! I have created a new website, if you are interested in Wii Game BitTorrents you must digg it! the address is w w w .Games-ISO. c o m
I couldn't agree more.
Shoe lifts often known as heel lifts. Shoe lifts originated from "elevator shoes". The first manufacturers of elevator shoes found it nearly impossible to manufacture as exstensive a range of styles as were available in normal footwear. Customers cried out for anything less obtrusive like an insert to place in normal footwear to make them seem taller.
An arch support is an appliance designed to offer underside support for the feet. the device is placed in the inner part of the footwear in order that it's molded form fits the arch of the foot and thus relieves strain on the muscular structure of the feet when walking or standing.
Wow, Awesome post - How to Troubleshoot Data Flow Task Errors and Warnings in SSIS | TechUrbia - A LearnItFirst Blog was a great read. I'm such a newbie when it comes to all this, Thanks for this!
I am happyto find so many beneficialinformation here in the post, we need increasemore strategies in this regard, thanks for sharing.
http://www.melrosejewelers.ca/
The Zune concentrates on being a Portable Media Player. Not a web browser. Not a game machine. Maybe in the future it'll do even better in those areas, but for now it's a fantastic way to organize and listen to your music and videos, and is without peer in that regard. The iPod's strengths are its web browsing and apps. If those sound more compelling, perhaps it is your best choice.
Between me and my husband we've owned more MP3 players over the years than I can count, including Sansas, iRivers, iPods (classic & touch), the Ibiza Rhapsody, etc. But, the last few years I've settled down to one line of players. Why? Because I was happy to discover how well-designed and fun to use the underappreciated (and widely mocked) Zunes are.
Bryce Junor
Jessie Hearson
This is a fantastic blog you have here. I visit here every week. I have already subscribed to your rss feed to help me stay update with your publication. Are you on twitter so that I can follow you?
I'm really loving the blog, and hope this, as well as the excellent article some other people have written, will help somebody
Nice read. Thanks for the work you put in to this site.
Hi!I really liked reading this post! We are searching for skilled writers like you! Come and get in touch us! good day Webmaster of http://www.footfetish-tube.com
Appearance to the other people models, I examine I pick this actual.
exeptional website! I enjoy my stay here every time. keep up the good work! Webmaster of footfetishTube.com
I just sent this post to a bunch of my friends as I agree with most of what you’re saying here and the way you’ve presented it is awesome.
Very Interesting Post! Thank You For Thi Post!
Hey...from my experience I didn't had a nice read from a extended time.Really happy i found it on yahoo.I was speaking with my friends two days ago about this issue and I have to state you clear out a lot of things.Thanks and good luck
For the women who are averse to wearing roman sandals because they find them a little masculine for their taste, or simply because they are scared the shoe type will make them look short, a good alternative is to purchase strapped thong sandals.
Marc Ecko Rhino Red Women's Angelique-Alanis - This type of sandal is very different to the shoes described above as it is a wedge, great for summer wear. It has a smooth jelly plastic upper in a cork wedge heeled thong sandal with Ecko logo detail and lightweight midsole.
You certainly deserve a round of applause for your post and more specifically, your blog in general. Very high quality material.
everyone should be involved.
Designer discount sandals are now up for grabs at many online stores and shopping malls. There are a wide variety of models from flat heeled open toe sandals to high heeled stilettos. Almost all the designer sandals are available with a discount and given their supreme quality any discount is a great plus for the customer.
I just sent this post to a bunch of my friends as I agree with most of what you’re saying here and the way you’ve presented it is awesome.
shares employ a fantastic web page decent Gives thanks for the effort to assist people
I just sent this post to a bunch of my friends as I agree with most of what you’re saying here and the way you’ve presented it is awesome.
Should I buy steel golf clubs or graphite ?
You certainly deserve a round of applause for your post and more specifically, your blog in general. Very high quality material.
Wedges are the absolute warm weather heel shoes for the high heel freaks, who go crazy wearing heels. And this article has brought you the most fabulous wedges in trend and that are having good sales in the market.
I’ve been visiting your blog for a while now and I always find a gem in your new posts. Thanks for sharing.
Over de voor- en nadelen van het afsluiten van een lening zonder BKR-toetsing.
Which Golf Clubs Are Better - Steel or Graphite ?
Which Golf Clubs Are Better - Steel or Graphite ?
Hi. I just want to say that it was a nice reading. I hope you come out with more interesting posts, because I bookmarked your website. All the best.
You certainly have some agreeable opinions and views. Your blog provides a fresh look at the subject.
Very Interesting Information! Thank You For Thi Blog!