DSXchange

Hello,

We have build a DS Job using the Transformer. The only thing which is done is retrieving data from a database on a MSS SQL Server drop columns and rows and write the result in another database on a MSS SQL Server.

My question is whether there is a more efficient DS-Stage than the transformer as there is no transformation done.

Thanks in advance.

Jan

Sure, just write a SQL script and have DS execute it.

Why are you selecting those columns if you're only going to drop them? Don't select them in the first place!

The question was not complete. I needed the dropped columns (date valid from and to) to determine wether I could drop rows.

Thanks all,

Jan

Just put a parameterized WHERE clause in your extraction stage, on the Selection tab.

WHERE eff_date BETWEEN '#DateFrom#' AND '#DateTo#'