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 |
|
moisesfernando
Starting Member
11 Posts |
 Posted - 2004-06-07 : 10:36:04
|
| Hello,I'm trying to execute a DTS package from one to another table, using a query to specify a condition. When I execute it, the package starts the copy of data and after a good time copying the data (the origin table is very large), I have a fail message on DTS as bellow:"Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed."For more information, the specific query command used on DTS is bellow:select * from [TBL_Origin]where [TBL_Origin].[My field]>='2002/01/01' AND[TBL_Origin].[My field]<'2003/01/01'order by [TBL_Origin].[My field].Thanks for help,Moisés |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-07 : 13:19:32
|
| Does the query run fine in Query Analyzer? Are you just trying to move data from one table to another? If so, just use INSERT INTO SELECT * FROM.Tara |
 |
|
|
moisesfernando
Starting Member
11 Posts |
Posted - 2004-06-07 : 13:26:18
|
| Tara, I'm not tried this option yet. I made a DTS package with a query above.Moises |
|
|
|
cs_bhimavarapu
Starting Member
23 Posts |
Posted - 2004-06-07 : 14:48:53
|
| Have you verified taking out the order by from your query...Thanks |
|
|
|
|
|
|
|
|
DTS on SQL 7