Fixed Width File Destination
I found the information on utilizing an ini file with an odbc source connection to do this, but that is not an option as a destination. I've tried a few different attempts, but haven't found a way to accomplish this.
Thanks for any guidance you can provide.
If one of the other options doesn't work you could use a script in the map to build the fixed width file, but you would have to code it all through one of our scripting tasks which would create the file and write the lines to it.
We have a KB article with some smaple scripts in it if you serach the knowledge base and one script is how to create a file through a script but it just covers csv creation so it would need to be modified for fixed width.
Thanks Chris. That sounds like a viable option.
I'm having trouble finding the KB article with the sample scripts you spoke of. I found this one (http://www.eonesolutions.com.au/Support/Knowledge-Base/Knowledge-Base-Article.aspx?articleid=32) which describes what each of the sample scripts does but doesn't actually provide the scripts.
Can you provide a link to that KB article?
We just switched websites, so the link is currently broken. I will send the file directly to your email address.
If you would like to submit an answer or comment, please sign in to the eOne portal.