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