|
|
Posted by gelangov on 08/23/07 14:12
On Aug 22, 5:40 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (gelan...@hotmail.com) writes:
> > I think I did not write it clearly...May be I should have written it
> > like this:
> > Truncate table table1
> > Insert into table1
> > Exec (' select [' + ?+ '] from '+ ?)
>
> > The "?" are where the variables are. It works fine in the query
> > analyzer (of course, after changing the question mark to variable
> > names).
>
> > My question is:
> > Are there any settings I need to change in order for "Exec" to work in
> > SSIS?
>
> I can't answer any questions about SSIS per se, since I don't know SSIS. But
> I believe that SSIS is essentially just another client application as far as
> the engine, and since I know the engine and some client programming, I
> might be able to provide some guessworks if you post the SSIS code
> where you invoke the batch above.
>
> Of course, asking the friendly people in microsoft.public.sqlserver.dts
> may also be a good idea - they are likely to produce more than guessworks.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Erland,
It is in xml...and so it looks quite ugly. Do you still want to see
it? Thank you for your help. I will also post it at microsoft site.
Geetha.
Navigation:
[Reply to this message]
|