declare @oPKG int,
@hr int
EXEC @hr = sp_OACreate 'DTS.Package', @oPKG OUT
IF @hr <> 0
BEGIN
PRINT '*** Create Package object failed'
RETURN
END
EXEC @hr = sp_OAMethod @oPKG OUT, 'LoadFromSqlServer', NULL,
@ServerName='DevServer', @PackageName='ExportToFlatFile', @Flags=256
IF @hr <> 0
BEGIN
PRINT '*** Load Package failed'
RETURN
END
EXEC @hr = sp_OAMethod @oPKG, 'Execute'
IF @hr <> 0
PRINT '*** Execute failed'
|