SSIS Recordset to Nacha Flat File
Hello, I am thinking my way through what seems to be a pretty straight forward process except I can't quite figure one step out. Creating the SSIS package to get the data of transactions that needs to be sent to the bank for processing is pretty simple. Dumping that recordset to a flat file is also pretty simple using Flat File Destination Manager. What I am wondering is how to "transform" it to the fixed field format of a NACHA file. The NACHA format is pretty simple as well so I was wondering if there was a way to apply sort of an xslt to the recordset before it was dumped to the flat file. The idea of course being as flexible as possible so when we change banks, or we start using another of the NACHA format for some other processing type etc. I don't have to go through the whole dev process on an SSIS pkg. Simply update the XSLT and done. I am pretty sure this can be done and I'm just not educated on how. TIA JB
November 23rd, 2010 8:18am

Hello, I am thinking my way through what seems to be a pretty straight forward process except I can't quite figure one step out. Creating the SSIS package to get the data of transactions that needs to be sent to the bank for processing is pretty simple. Dumping that recordset to a flat file is also pretty simple using Flat File Destination Manager. What I am wondering is how to "transform" it to the fixed field format of a NACHA file. The NACHA format is pretty simple as well so I was wondering if there was a way to apply sort of an xslt to the recordset before it was dumped to the flat file. The idea of course being as flexible as possible so when we change banks, or we start using another of the NACHA format for some other processing type etc. I don't have to go through the whole dev process on an SSIS pkg. Simply update the XSLT and done. I am pretty sure this can be done and I'm just not educated on how. TIA JB If you can use third-party components, check the commercial CozyRoc Template Task . You can define your result text file layout in a template and then connect this template to a file connection, variable or multiple SSIS data flows. You can maintain this template outside your package, essentially accomplishing the functionality you have described above.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2010 12:35am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics