Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-13 : 08:02:43
|
| Ahmad writes "Hi I built a simple DTS program, which import text file into a database. But now I am trying to make DTS program which does the following.1.logs the details (file name,no of records,directoryname) in database everytime dts run .2.Checks before importing a text file , if the file exists, and if does select another file from the directory , this loop must go on till all the files in specified directory gets imported.text files which i am i import into db are timestamped , for e.g (11102005.txt) mm/dd/yyI would really apprecite your help in this matter.I have read so many forumn, links, but I guess they all are too advanced for me. If you could provide simple program , few tip/tricks how to do these tasks in sql server DTS , would be very much helpful to me." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-10-17 : 07:44:50
|
| Why use dts? It's not very good for this sort of thing.seehttp://www.mindsdoor.net/SQLTsql/ImportTextFiles.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
species2175
Starting Member
1 Post |
|
|
|
|
|
DTS for Importing Text files