wrote 0 rows

  • 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?

  • 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

  • Thank you Darth, good to know. I had the same experience yesterday using the export wizard in Managment Studio.

  • 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