I figured it out, my table had varchar length less than some of the values so there was truncation and therefore the proc didnt load the data. Weird there was...

Yes, I was able to successfuly implement Jack's version, however, I really wanted to add the script to the toolbox, for ease of developement.

So, this version will only work...

I have registered the component successfully to add to the BIDS Toolbox, however, I do not see the custom component listed. I am using Visual Studio 2005 with SQL Server...