DSXchange

yup, that's what I suspected. Thanks for confirming.

I have a routine that generates custom SQL. This is called in my sequence and subsequently passed to a job. By way of illustrating let's say MakeSQL routine returns the following SQL: SELECT <ARG_1> as SK, <ARG_2> as SURVIVORSHIP_KEY. Now, the routine is always passed ARG_1, but I want ARG_2 to be o...

Played around with settings.

Used:
Final delimiter = none (or just delete this option)
Record Delimiter = UNIX newline
Delimiter = comma
Quote = double

Also set APT_IMPORT_PATTERN_USES_FILESET=TRUE to get the filenames out.

-Dave

I have a requirement to read a number of files that much the following format: TYPE, DESCRIPTION, col1, col2, col3, ... col n note: each record in the sequential file is terminated by a Unix newline. I am trying to create a job that will read all the files at once (using file pattern), but only read...

Long time reader, first time poster I need to check if a dataset in order to elect whether to run a database load job. If the dataset is empty (i.e. 0 rows) we skip the job, otherwise we run it*. From the sequence i'd run an Execute Command invoking the 'dsrecords' command and branch based on the ou...

Hi all, I have a requirement to combine multiple columns into a single column. While this can be done in a Column Export stage, I need to do this for multiple sets of columns. I would ideally like to do this all in one stage rather than having to string together a number of Column Export stages. i.e...