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 |
|
sstephen
Starting Member
2 Posts |
 Posted - 2004-03-19 : 16:26:51
|
| I'm trying to export to an Access2000 database, and once it's complete I'm going to compact it, zip it, and then FTP it. The problem is after it exports the tables, the connection is staying alive(I can see the .ldb file in the directory). Next when it tries to compact the DB, it says the file is already open. After the error, SQL closes the connection to the Access DB. If I run each step separately, everything is ok. It's only when I run the package as a whole. How to I kill the connection after the export? I looked in all the workflow/data task properties and can't find anything. I also tried skipping the compact and just zipping it, but WinZip also gives an error about the file is open.It just seems like it keeps the connection open until either the package is complete, or there is an error.Thanks for any help, Scott |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-03-24 : 17:35:03
|
| Can you just delete the ldb if you know that no one else is using the Access db. Not ideal I know but if it works...steveSteve no function beer well without |
 |
|
|
jsiedliski
Yak Posting Veteran
61 Posts |
Posted - 2004-03-25 : 19:38:16
|
| Not sure how DTS handles connections with MS Access, but try breaking your process into seperate DTS packages:DTS Package 1: create the Access DBDTS Package 2: compact the db, zip the file and FTP (seperating into 2 distinct packages will tell you if DTS is the culpret in keeping the db open (the .ldb file existis).Hope that helps,Jack:) |
|
|
|
jsiedliski
Yak Posting Veteran
61 Posts |
Posted - 2004-03-25 : 19:46:20
|
| I should have tried it before my previous post.Anyway, the .ldb file does close once the DTS package exports data from SQL to Access. (if running manually from within Enterprise Manager, you will have to click on the "OK" and "Done" buttons (in the 2 different windows) before the .ldb goes away.So, creating 2 DTS packages, where the 1st one does the data transfer should work.Jack:) |
|
|
|
sstephen
Starting Member
2 Posts |
Posted - 2004-03-27 : 09:43:53
|
| Thanks Guys, I'll try those suggestions on Monday |
|
|
|
|
|
|
|
|
Exporting to Access...Help!!!