December 28, 2003 at 7:41 pm
I have created a simple DTS package to import data via ODBC Provider (Fairchild DB by c-tree) into SQL from a Linux server. The package runs fine as a DTS package but fails when the copy process starts when executed as a scheduled job. (This is operating under Small Busines Server which sometimes makes a difference in the way things are handled in the registry.) Dropping the tables would be a SQL process. However I would think that recreating them would be after the ODBC connection has been made. So can permissions be a problem here?
How can I get this to work? I been through MS KB 269074 Info on How to RUn a DTS Package as a Scheduled Job and still can't get it to work. What am I missing?
Error message received:
DTSRun: Executing... DTSRun OnStart: Drop table [QRSImport].[dbo].[alg] Step DTSRun OnStart: Drop table [QRSImport].[dbo].[apc] Step DTSRun OnStart: Drop table [QRSImport].[dbo].[app] Step DTSRun OnStart: Drop table [QRSImport].[dbo].[ars] Step DTSRun OnFinish: Drop table [QRSImport].[dbo].[apc] Step DTSRun OnStart: Create Table [QRSImport].[dbo].[apc] Step DTSRun OnFinish: Drop table [QRSImport].[dbo].[alg] Step DTSRun OnStart: Create Table [QRSImport].[dbo].[alg] Step DTSRun OnFinish: Drop table [QRSImport].[dbo].[ars] Step DTSRun OnStart: Create Table [QRSImport].[dbo].[ars] Step DTSRun OnFinish: Drop table [QRSImport].[dbo].[app] Step DTSRun OnStart: Create Table [QRSImport].[dbo].[app] Step DTSRun OnFinish: Create Table [QRSImport].[dbo].[apc] Step DTSRun OnStart: Copy Data from apc to [QRSImport].[dbo].[apc] Step DTSRun OnFinish: Create Table [QRSImport].[dbo].[alg] Step DTSRun OnFinish: Create Table [QRS... Process Exit Code 50. The step failed.
December 31, 2003 at 8:00 am
This was removed by the editor as SPAM
December 31, 2003 at 8:50 am
I find it helpful to break the error message up into statements to find the problem error.
DTSRun: Executing... DTSRun OnStart: Drop table [QRSImport].[dbo].[alg]
Step DTSRun OnStart: Drop table [QRSImport].[dbo].[apc]
Step DTSRun OnStart: Drop table [QRSImport].[dbo].[app]
Step DTSRun OnStart: Drop table [QRSImport].[dbo].[ars]
Step DTSRun OnFinish: Drop table [QRSImport].[dbo].[apc]
Step DTSRun OnStart: Create Table [QRSImport].[dbo].[apc]
Step DTSRun OnFinish: Drop table [QRSImport].[dbo].[alg]
Step DTSRun OnStart: Create Table [QRSImport].[dbo].[alg]
Step DTSRun OnFinish: Drop table [QRSImport].[dbo].[ars]
Step DTSRun OnStart: Create Table [QRSImport].[dbo].[ars]
Step DTSRun OnFinish: Drop table [QRSImport].[dbo].[app]
Step DTSRun OnStart: Create Table [QRSImport].[dbo].[app]
Step DTSRun OnFinish: Create Table [QRSImport].[dbo].[apc]
Step DTSRun OnStart: Copy Data from apc to [QRSImport].[dbo].[apc]
Step DTSRun OnFinish: Create Table [QRSImport].[dbo].[alg]
Step DTSRun OnFinish: Create Table [QRS... Process Exit Code 50. The step failed.
Look at the step after the create alg table. You are good to that point. Also, why drop and create tables that just adds time to the task. Why not create a table and truncate the data? This is quicker and does not use as much overhead. In fact a group of tables could be handled in one step using the "Execute SQL" task. Additionally, I try to keep like functions together. Makes for easier readability. Just a little quirk of mine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply