Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Find newest files in a series of folders and output them to a file
I have a series of folders that are backed up every night using xcopy. I want to be able to run a script to report the newest filename and DateLastModified of the files in each of a number of folders. I have found an example of a script that shows me the newest file and its date/timestamp but I... -
Conver char to date
Hi, I am importing (using DTS) dates from an ODBC data source which come across as char (6) in the format A21125 for 25th November, 2002. What is the best way to get convert this data type into a meaningful date in SQL Server 2000? I tried doing a string operation as follows: select...- budmor
- Thread
- Replies: 12
- Forum: Microsoft SQL Server: Programming
-
Importing data from ODBC source using DTS
Hi, I'm importing data from ODBC compliant datasource to SQL Server 2000 using DTS Wizard. Works fine except I don't know how to get it to update changes only to the DB. I would like to schedule a package to run nightly to extract the updates from the legacy database without bringing the whole...- budmor
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
ASP 0115 error
Hi, I'm getting the error below intermittently. The trouble is this script works fine for a period of time but then crashes out. I'm using my W2K Professional as the IIS 5.0 server. If I reboot it will work again for a while. I have a number of other Form/Response scripts that yield the same...- budmor
- Thread
- Replies: 4
- Forum: Microsoft: ASP (Active Server Pages)
-
ODBC Configuration
Hi, Is it possible to use VBScript to automatically configure ODBC to add User/File DSN's. Should one fire up the application like this:<br><br>Set shell = CreateObject("Wscript.Shell")<br>shell.run "odbcad32.exe"<br><br>and then somehow Add new User/File DSN's or am I on the...
