Se poate evita utilizarea unui "DTS package" salvat intr-un fisier prin incarcarea directa a unui "local package":

DECLARE @object int
DECLARE @hr int

--create a package object
EXEC @hr = sp_OACreate 'DTS.Package', @object OUTPUT
IF @hr <> 0
BEGIN
    PRINT 'error create DTS.Package'
    RETURN
END

EXEC @hr = sp_OAMethod @object, 'LoadFromSQLServer', NULL, 'server\instanta','','','256','','','','nume local package'

IF @hr <> 0
BEGIN
    PRINT 'error LoadFromSQLServer'
    RETURN
END

EXEC @hr = sp_OAMethod @object, 'Execute'
IF @hr <> 0
BEGIN
    PRINT 'Execute failed'
    RETURN
END