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 - 2006-10-16 : 07:19:48
|
| Purna Chandra Rao writes "Hi,I have a DTS package in production environment. This DTS package copies text file on application server to production server and writes to SQL Server. The problem here is when the file is copied from application server, the thread opened by SQL Server on application server is not closed when the file is copied. And it is causing the DTS package to fail next time saying that the file is use by another process and cannot access the file.I am resolving this issue by manually closing the connection on application server. I am closing the connection at Computer Management-->open filesI didnot find any errors in SQL logs, application logs, system logs. There are no orphaned connections on SQL Server.Both Application server and Production server are windows 2000 and Production server is having sql server 2000 with service pack3 (security patch, version 8.00.818)Can anyone let me know why this is happening, is this issue related to SQL Server or windows? Kindly let me know asap, as this is an urgent issue. TIA" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-16 : 07:42:29
|
| How are you doing the copy?Maybe try copying the file on the application server first?Why are you trying to copy the file multiple times? If the file is locked then it can't have been changed so you already have the file on the server.I always use a os copy command to do copies and have never had this problem.==========================================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. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-17 : 01:49:54
|
| why is the transaction/thread still open? if you run the dts package, does it succeed? if it completed then the file would have been releasedHTH--------------------keeping it simple... |
|
|
|
|
|
|
The process cannot access the file because it is being used