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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: spaghettiGurl
- Order by date
-
Delete/Rename .mdb file after successful transfer to SQL Server
I tried something just slightly different...I had 3 packages. 1 - Import Data, 2 - Rename file, 3 - Points to package 1 on success points to package 2. Sorted! Thank you So much!- spaghettiGurl
- Post #5
- Forum: Microsoft SQL Server: Data Transformation Services
-
Delete/Rename .mdb file after successful transfer to SQL Server
I've already been to this site and used this code (as such...) but it fails on the oFSO.MoveFile sSourceFile, sDestinationFile line. I can copy but not move or delete because the Access Database is still locked until the DTS process has finished. How do I get the DTS process to release the...- spaghettiGurl
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
Delete/Rename .mdb file after successful transfer to SQL Server
Hi, I've been pulling out my hair trying to solve this problem. I have a .mdb (access database) that I want to import to SQL Server using DTS. This in itself works. The tricky bit is coming. I want to test that the file is there (this works), import the data (this works) and then rename the...- spaghettiGurl
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Data Transformation Services
