Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Flat File Destination populated with bad characters/blank data fields Expand / Collapse
Author
Message
Posted Tuesday, April 28, 2009 11:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 3, 2010 8:28 AM
Points: 2, Visits: 57
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.

Post #706092
Posted Tuesday, April 28, 2009 7:37 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:15 AM
Points: 5,317, Visits: 12,354
Try adding a Data Viewer to confirm that the dodgy data is not being returned by the SP.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #706426
Posted Wednesday, April 29, 2009 6:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 3, 2010 8:28 AM
Points: 2, Visits: 57
Thanks for the response. I will add the data viewer to the package and see if that captures the data in question ...
Post #706704
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse