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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Need help with Jobs!

Author  Topic  juampa Starting Member 2 Posts Posted - 2001-08-14 : 10:45:57 Hello guys... I made a DTS package using designer in SQL Server 97. What i do is basically copy some rows using a customized sql query from a database, andy copy the results to another database. Both databases reside in the same server. I use both OLE-DB for source and destination databases using the same IP address of the server. The DTS package Tasks execute OK and it works just fine. Later i customize this by scheduling the package. I setup it to execute at each 5 minutes, from 12PM to 3PM. NOW, im getting the following error each time the job executes: "DTSRun: Loading... Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Error no especificado Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713 Error: -2147467259 (80004005); Provider Error: 11 (B) Error string: [DBMSSOCN]Error de red general. Consulte la documentación de la red. Error source: Proveedor de Microsoft OLE DB para SQL Server Help file: Help context: 0. Procesar el código de salida 1. " Id like to know whats wrong with this, since ive tested this in my SQL 2000 Server test machine and it worked just fine. Besides the DTS package works! Thank in advance!!! - JP