I see many options to make the toolbox work, like 1) right clicking and clicking refresh (can't do that because there is no refresh option in the dropdown on the right click), 2) reset the toolbox, remove the .tdb's from the appdata... etc folder, go to the registry and clean out the toolbox cache keys from the HKCU... (that didn't work). I was thinking that maybe when SQL 2012 was released, all the old "fixes" vanished to be replaced by a new "fix". I'm curious as to what the fix is. I have WPF, COM, Silverlight, .Net Framework, Activities and Workflow, but at this point, I need a way to convert ntext to text to save data to a flat text file. VS_ISBROKEN. I made several attempts to take my concatenated field (two fields separated by a comma and used as a single field and delimited with a pipe) and import it as DT_TEXT but no matter how much I jump around and cuss, the file still thinks it is DT_NTEXT so I decided maybe I should just add a conversion. So I clicked the toolbox and (I think I remember it also did this when SQL 2008 SSIS came out - but can't remember how I fixed it back then) BINGO, Toolbox is empty. What sort of choices do I have here to make this work? R, J

If you have this problem, I found the solution and it is trivial. Right Click in the blank space of your Data Flow page (under the data flow tab) to see a drop down that says SSIS Toolbax which will get you Data Conversions, Merges, and the like. When you switch back to Control Flow Tab, the correct one will show there as well. When will Microsoft come out with Right Click Intellisense? It would sure help to have it. Nothing beats wasting days and nights looking for something that was once there and is no longer there. Ah, hope this diatribe of mine helps someone.R, J

Hi Crakdkorn, Thank you for sharing your solutions and experience here. It will be very beneficial for other community members who have similar questions. Thanks, Eilee TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.