Text files in DB

kennyapril · Post by **kennyapril** » Mon Jun 24, 2013 8:24 am

Hello,

The source for a DS job is a SQL server which has text files on the database.

Which stage would be the best one to access the files on the database?

Thanks

chulett · Post by **chulett** » Mon Jun 24, 2013 9:18 am

You will need to clarify what exactly it is you mean by "text files on the database". Specific examples would be nice, as well.

kennyapril · Post by **kennyapril** » Mon Jun 24, 2013 9:48 am

We were told by the user that there are around 1000 text files which has header, detail and trailer in all the files.

These files are placed in SQL server DB, access will be provided to their box where these files are present.

They all are of same layout, I wanted to know how do I connect from DS to the SQL server DB when there are files as usually we connect through ODBC and SQL server stages.

Thank you.

ArndW · Post by **ArndW** » Mon Jun 24, 2013 9:59 am

You would connect the same way, since these files will be stored, somehow, in tables in the database.

chulett · Post by **chulett** » Mon Jun 24, 2013 10:08 am

Still curious if these are the actual files stored as CLOBs in the database or are they pointers to the phyical file? From what I've seen most databases support both concepts, hence the question.

kennyapril · Post by **kennyapril** » Mon Jun 24, 2013 10:15 am

Thanks very much!

Only information given was the files are in the DB, not sure how they are stored.

Will get back once I get the access today or tomorrow as that will give a clear idea.