February 18, 2009 at 4:22 am
aaagh
i have an OLE db source componenet in a data flow task
it shows rows in the preview
then i run it and it says "wrote 0 rows" in the progress with no errors
i don't understand....any ideas?
February 18, 2009 at 10:13 am
solved it...
i had a variable to SQL thing going on and if i removed the "use databasename" line from the start it worked
strange...but hey ho
March 31, 2009 at 10:45 am
Thank you Darth, good to know. I had the same experience yesterday using the export wizard in Managment Studio.
August 7, 2010 at 10:42 am
Thanks darth, wish I'd have found this yesterday!;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply