 | |
File in use.
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
File in use. -
09-03-2003
, 05:16 AM
#2
| |||
| |||
|
|
Hi All I am using simple bulk copy transfer. I have save that as a DTS. When I run it manually it runs fine. But when I tried to make run as as scheduler (JOB) I am getting this error Step 'Copy SQL Server Objects' failed Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:The process cannot access the file because it is being used by another process. (Microsoft Data Transformation Services (DTS) Package (80070020): The process cannot access the file because it is being used by another process. ) (Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on 'ERTEUWEBD20.U11K$CUUIP.DP1'. The process cannot access the file because it is being used by another process. ) Step Error code: 80070020 Step Error Help File:sqldts80.hlp Step Error Help Context ID:1100 |
#3
| |||
| |||
|
|
Make sure 1. The "Close Connection On Completion" property is set for the Datapump task 2. The SQL Server Agent account has access to that diectory and read permission on the file.(If the T File is the Source) -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Abhijeet Raje" <abhijeet2804 (AT) hotmail (DOT) com> wrote in message news:uJGEuQgcDHA.1880 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hi All I am using simple bulk copy transfer. I have save that as a DTS. When I run it manually it runs fine. But when I tried to make run as as scheduler (JOB) I am getting this error Step 'Copy SQL Server Objects' failed Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:The process cannot access the file because it is being used by another process. (Microsoft Data Transformation Services (DTS) Package (80070020): The process cannot access the file because it is being used by another process. ) (Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on 'ERTEUWEBD20.U11K$CUUIP.DP1'. The process cannot access the file because it is being used by another process. ) Step Error code: 80070020 Step Error Help File:sqldts80.hlp Step Error Help Context ID:1100 |
#4
| |||
| |||
|
|
I personally never use this task but 1. Is the directory mentioned where you told SQL Server to put the files for this task. 2. To get the data in SQL Server uses a bcp file and a fmt file so would need to read the file. 3. What exactly does it get stuck on. It should be visible in the progress bar. -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Abhijeet Raje" <abhijeet2804 (AT) hotmail (DOT) com> wrote in message news:OMPnx0pcDHA.2308 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Hi Mitchell, I m using Copy SQL server Object task for this not datapump. The file for which "in use" error is comming is in "C:\Program Files\Microsoft SQL Server\80\Tools" directory. regards Abhijeet "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:uuJ96vgcDHA.356 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Make sure 1. The "Close Connection On Completion" property is set for the Datapump task 2. The SQL Server Agent account has access to that diectory and read permission on the file.(If the T File is the Source) -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Abhijeet Raje" <abhijeet2804 (AT) hotmail (DOT) com> wrote in message news:uJGEuQgcDHA.1880 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hi All I am using simple bulk copy transfer. I have save that as a DTS. When I run it manually it runs fine. But when I tried to make run as as scheduler (JOB) I am getting this error Step 'Copy SQL Server Objects' failed Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:The process cannot access the file because it is being used by another process. (Microsoft Data Transformation Services (DTS) Package (80070020): The process cannot access the file because it is being used by another process. ) (Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on 'ERTEUWEBD20.U11K$CUUIP.DP1'. The process cannot access the file because it is being used by another process. ) Step Error code: 80070020 Step Error Help File:sqldts80.hlp Step Error Help Context ID:1100 |
#5
| |||
| |||
|
|
OK, You please suggest me the approach. I have to just copy production data to reporting database every 30 min. What should I use? Should I go for Datapump? If there are 30 tables then for each table Datapump will be created. Or should I write my own scripts "Insert into ... " after truncating destination tables? regards Abhijeet "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:OlF7m5qcDHA.2672 (AT) tk2msftngp13 (DOT) phx.gbl... I personally never use this task but 1. Is the directory mentioned where you told SQL Server to put the files for this task. 2. To get the data in SQL Server uses a bcp file and a fmt file so would need to read the file. 3. What exactly does it get stuck on. It should be visible in the progress bar. -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Abhijeet Raje" <abhijeet2804 (AT) hotmail (DOT) com> wrote in message news:OMPnx0pcDHA.2308 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Hi Mitchell, I m using Copy SQL server Object task for this not datapump. The file for which "in use" error is comming is in "C:\Program Files\Microsoft SQL Server\80\Tools" directory. regards Abhijeet "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:uuJ96vgcDHA.356 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Make sure 1. The "Close Connection On Completion" property is set for the Datapump task 2. The SQL Server Agent account has access to that diectory and read permission on the file.(If the T File is the Source) -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Abhijeet Raje" <abhijeet2804 (AT) hotmail (DOT) com> wrote in message news:uJGEuQgcDHA.1880 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hi All I am using simple bulk copy transfer. I have save that as a DTS. When I run it manually it runs fine. But when I tried to make run as as scheduler (JOB) I am getting this error Step 'Copy SQL Server Objects' failed Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:The process cannot access the file because it is being used by another process. (Microsoft Data Transformation Services (DTS) Package (80070020): The process cannot access the file because it is being used by another process. ) (Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on 'ERTEUWEBD20.U11K$CUUIP.DP1'. The process cannot access the file because it is being used by another process. ) Step Error code: 80070020 Step Error Help File:sqldts80.hlp Step Error Help Context ID:1100 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.