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
Text files in DB
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
Text files in DB
Regards,
Kenny
Kenny
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 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.
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.
Regards,
Kenny
Kenny
You would connect the same way, since these files will be stored, somehow, in tables in the database.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am