Information générale
Forum:
Microsoft SQL Server
Titre:
DTS package in a job
I use SQL 7.0. I created a DTS package to transfer data from a SQL 6.5 to SQL 7.0.
I saved this package in Local Packages and run EXECUTE PACKAGE. It worked fine.
When I used SCHEDULE PACKAGE and created a schedule job. That schedule job didn't work.
I used DESIGN PACKAGE to open this and EXECUTE. It didn't work.
I used Microsoft ODBC Driver for SQL server to connect to SQL 6.5.
I got these from the Job history.
Please help for this.
Thanks
Jim
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Drop table [CPCA].[DELTEK].[PROJ] Step DTSRun OnFinish: Drop table [CPCA].[DELTEK].[PROJ] Step DTSRun OnStart: Create Table [CPCA].[DELTEK].[PROJ] Step DTSRun OnFinish: Create Table [CPCA].[DELTEK].[PROJ] Step DTSRun OnStart: Copy Data from PROJ to [CPCA].[DELTEK].[PROJ] Step DTSRun OnError: Copy Data from PROJ to [CPCA].[DELTEK].[PROJ] Step, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 53 (35) Error string: [Microsoft][ODBC SQL Server Driver][Nam. The step failed.
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement