Re: SQLCMD output variables
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 20 Jun 2007 22:04:26 +0000 (UTC)
Mike McK (MikeMcK@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I'm trying to execute potentially hundreds of stored procs in SSIS and
I'm trying to find an efficient way to do that with out coding the
execute sql task individiually...i'm hoping I can pass the proc name
into another proc which genereates the sqlcmd syntax and have it fire
off from there...problem is i may need to return parameters from the
procs...
OK, since I haven't used SSIS, I'm out. I would suggest that you
try microsoft.public.sqlserver.dts. I think there is an Integration
Services group as well, but these new groups seems to have poor distribution
and low traffic. In worst case, you will have to try the web forums on
forums.microsoft.com.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: SQLCMD output variables
- From: Erland Sommarskog
- Re: SQLCMD output variables
- From: Erland Sommarskog
- Re: SQLCMD output variables
- Prev by Date: Re: OLEDB, sql server, and unmanaged heap memory leak Options
- Next by Date: open table
- Previous by thread: Re: SQLCMD output variables
- Next by thread: open table
- Index(es):
Relevant Pages
|
|
