I need to report some data to a supplier via ASCII files. those files have header record, details and end record.
How can I achieve this with Data Providers.
I tried to load the fields from the file but it only reads the first record which have a different layout than the details record and the end record.
Maybe it is better to do this with the Report Designer?
Please advise.
Jesus.
Best answer by Gabriel Michaud
View original
I create a Report Designer Report and achieve the multirecord part, but it only exports to Excel or PDF. Is there a way to export the report to a flat file?
Jesus
+10
Hi
This is not possible with the built-in data providers available with Integration Services and Export Scenarios. It *might* be possible to hack the ACH Provider to support something like this, but I think the mapping is undocumented.
Do you have a development team or a partner that can help you build a custom data provider? There are two threads in the forum that deal with this:
Regards,
We are in the need for the same reporting. ASCII file to report purchases and sales. In our file we need the header identification record, brand identification records, ship to identification records, purchase records, and a total record.
Would love a mapping tool that would allow us to create these files for two different vendors.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.