Write code to extract record from multiple tables to Files.

[JITeam]

Hi,

I have to extract multiple tables record and write into the different CSV files.
Extraction is simple (Select * from table),In Server Edition do you have idea of writing code in DS where we will define the table name , Connection strings of DB and get extracted the record in CSV with Table Definition.

EX:

Table File
ABC ABC.CSV
BCA BCA.CSV
CBA CBA.CSV

Thanks

[chulett]

There really isn't the concept of "select *" in Server since everything is metadata driven. So the typical answer would be one job per table.

How many tables are "multiple"?

[ray.wurlod]

Provided that the record structure is identical, you could use one job with the table/file name a job parameter.

[JITeam]

Thanks guys, the tables have different metadata and approx 95 tables, if in EE we could have used RCP I guess.

So writing a job with 100 extrats or different jobs is the only option?

[ray.wurlod]

No, you don't need 100 extracts. For 95 tables each with different metadata, 95 jobs should do it.

[babaojo]

No, you don't need 100 extracts. For 95 tables each with different metadata, 95 jobs should do it. ...

I think the question JITeam's was trying to ask is similar to mine; and that is:
Is there a way to parameterize the table definition in a job? Or is it possible to specify the definition as an external (operating system) object or as a DS_METADATA object rather than explicitly listing each column in the job?

[ray.wurlod]

And the answer is, and remains, not in server jobs.

Parallel jobs give more flexibility, through the use of schema files, but things are always metadata driven.

Just don't expect any "T" in your "ETL".

[Sainath.Srinivasan]

Maybe you can concat them into a single column with comma sep. That way one job will do.