Flat File Destination populated with bad characters/blank data fields

  • The Data Flow task is simple enough. It takes the results from a stored procedure, and pumps the data to a flat file using pipe's as delimeters for the data columns. For some reason, and only in select occurences, the file will get popoulated with bad/blank data.

    For example, the top portion of the file has the data set as;

    7916728||-2||TRS| |30000|TRU_B|4

    and this will continue throughout until it gets to something like this;

    |-|-||||||0

    When the stored proc is run from Query Analyzer there are no issues, and I have been unable to replicate the behavior when running the package with the same data set.

    Another piece of information which might be helpful, is that there are 2 of these packages that run as scheduled jobs, that pull similar data elements - not exactly the same - that are scheduled at the same time. If it was locking on the data wouldn't we expect to see this everytime since the schedule remains the same?

    I feel like it is in the writing to the file that is causing the issue and not the SQL itself since it runs fine without error outside of the packages.

    Any help would be greatly appreciated.

  • Try adding a Data Viewer to confirm that the dodgy data is not being returned by the SP.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • Thanks for the response. I will add the data viewer to the package and see if that captures the data in question ...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply