Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Unanswered: SSIS using SQL Command for Data Access Mode to export data to text file

    Not sure why but sql queries for ole db source editor Data Access Mode is not passing rows to the text file destination.
    The preview in the oledbsource editor shows there are rows being returned but when I look at the preview for the flat file destination there are no rows in the preview.... any suggestions... on what I'm missing...

    thanks
    Jonathan

  2. #2
    Join Date
    Nov 2004
    Location
    Canada
    Posts
    58
    Check the data type is compatible with the output file. Ie: DT_STR, Check advanced options on your editor to see what the output column datatype is. See if it is compatible with your output file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •