DSXchange

Yes, as that padding to full size is the nature of a CHAR field.

The option would be there in the 'native' stages, plus the DRS from what I recall, can you not use one of them?

People, don't add the tags that we can use here - bold, italics, code, etc - and then enable / check the Disable BBCode in this post option. Kind of defeats the whole purpose.

To the O/P, as I would say elsewhere: FTFY... fixed that for ya.

Are you getting any errors? How are you determining that it is 'not getting passed' rather than some other error in your usage of the parameter? Are you handling the Field Mark (@FM) that the Execute Command stage will have in its output? Details would help us help you.

Ray kind of... skims... sometimes.

So... is that your resolution or are you looking for another answer?

:!: Most people set up a cron script to prune that directory, i.e. delete files older than x days to keep a rolling x days in the phantom directory. It's important to note that CLEAR.FILE is like a truncate so if you take that route you should only do that when no jobs are running. And the solution ...

Yes, they are store in two sections and you need to properly 'export' / transfer the contents of both if you want this to work.

Access and Excel are two separate and completely different things. Regardless, use ODBC to source from either one.

Leverage the technique listed here.

I don't think is a 'filename' thing but rather the fact that the first record of the file contains the column headings. In my experience that's unusual in a file of this nature and I didn't see any mention of a mechanism to tell the CFF stage that you have that going on. Is there some other method i...

A continuation of this post for those following along in the home audience.

First define what you mean by "refreshing", generally rolling over a surrogate and starting to reuse them is not a good idea so I assume you mean something else. ps. That really should be the permanent solution as well, properly sized key values should never overflow... unless we're talkin...

I would look for a piece of software called fuser or "file user", it can be used to check if anyone has the file "in use" and you can sleep until it has been released. It's open source freeware from what I recall.

priyadarshikunal wrote:definately, its there in version 8.x, not quite sure about 7.x but if its not there (i think its not), one workaround can be converting it to julian date, before aggregator(or decimal as yyyymmdd/yyyymmddhh24miss ) to get the max and convert it back.

It's there. Somewhere.