Problème avec lot dts

Voici la procédure stockée à utiliser :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
 
     BEGIN
          DECLARE @description varchar(255)
 
          -- create an instance of the DTS package
          exec @rc = sp_OACreate 'DTS.Package', @package output
 
          -- load the package
          exec @rc = sp_OAMethod @package,
                         'LoadFromSQLServer',
                         null,
                         @PackageName="RMSLoadImportFile",
                         @servername= @srv,
                         @ServerUserName=@DBusr,
                         @Flags=0
 
          IF @rc <> 0
          BEGIN
               EXEC sp_OAGetErrorInfo @package
               RETURN
          END
 
          -- Set global parameter values
          exec @rc = sp_OASetProperty @package, 'GlobalVariables ("file_name").Value', @file_name
          exec @rc = sp_OASetProperty @package, 'GlobalVariables ("run_id").Value', @run_id
 
          -- execute package
          exec sp_OAMethod @package, 'Execute'
          IF @rc <> 0
          BEGIN
               EXEC sp_OAGetErrorInfo @package, @description OUT
               insert into import_errors
                    (import_id, import_str)
               values
                    (@run_id, 'Error executing DTS package LoadImportFile;  Error description: ' + @description)
               RETURN
          END
 
          -- destroy the instance
          exec sp_OADestroy @package
 
     END