Calling a dts package from within

#1

Hello,
Is it possible to execute a dts package from within a
stored procedure?
How do you do it?
Are there any issues around doing it?
What sort of return value should I expect?

Thanks
Jamie

#2

You can have a look at this

Execute a package from T-SQL
(http://www.sqldts.com/default.aspx?210)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Jamie Thomson" <jamie.thomson (AT) int21 (DOT) com> wrote

Quote:

Hello,
Is it possible to execute a dts package from within a
stored procedure?
How do you do it?
Are there any issues around doing it?
What sort of return value should I expect?

Thanks
Jamie

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Calling a dts package from within

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Calling a dts package from within - 09-15-2003 , 06:19 AM

Re: Calling a dts package from within - 09-15-2003 , 06:22 AM