What about saving the package out as a structured storage file and doing it
that way?
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Ana Guillén" <Ana Guilln (AT) discussions (DOT) microsoft.com> wrote
Quote:
Hi,
I need to invoke a DTS from a VB exe, but the public role in my SQL server
has blocked the sp_getdtspacakage, and for security I don't let it execute
that. But the invoker user has permission to execute this sp. Please,
Make
me suggestions about that. Help me please. |