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 |
|
sbrazier
Starting Member
19 Posts |
 Posted - 2009-12-01 : 20:06:28
|
| Here is the error message I'm getting:DTSRun: Loading... Error: -2147217900 (80040E14); Provider Error: 14262 (37B6) Error string: The specified DTS Package ('Name = 'DSO_ProcessDeptImports'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.I'm calling a stored procedures that creates the SQL job to execute the DTS package. declare @jid uniqueidentifier --Initialize command declare @cmd varchar(4000) set @cmd = '"C:\Program Files\Microsoft SQL Server\80\Tools\BINN\dtsrun.exe" /S(local) /N ' + @dts + ' /W 0 /E ' -- Specifiy variables values to be passed to DTS through DTS Run set @cmd = @cmd + '/A claim_year:3=' + rtrim(cast(@claim_yr as char(20))) + ' ' set @cmd = @cmd + '/A user:8=' + @user + ' ' set @cmd = @cmd + '/A user_email:8=' + @user_email + ' ' set @cmd = @cmd + '/A dept_code:8=' + @dept_code + ' ' -- Create a unique job name declare @jname varchar(128) set @jname = rtrim(@dts) + 'DTS' -- Create job exec msdb.dbo. sp_add_job @job_name = @jname, @enabled = 1, @category_name = 'DSO', @delete_level = 1, @job_id = @jid OUTPUT exec msdb.dbo.sp_add_jobserver @job_id = @jid, @server_name = '(local)' exec msdb.dbo.sp_add_jobstep @job_id = @jid, @step_name = 'Execute DTS', @subsystem = 'CMDEXEC', @command = @cmd -- Start job exec msdb.dbo.sp_start_job @job_id = @jidThis is my step within my job:"C:\Program Files\Microsoft SQL Server\80\Tools\BINN\dtsrun.exe" /S(local) /N DSO_ProcessDeptImports /W 0 /E /A claim_year:3=2010 /A user:8=sbrazier /A user_email:8=sbrazier@hampton.gov /A dept_code:8=FIN |
|
|
|
|
|
Problem executing DTS Package