On 8 15 , 1 47 , "Uri Dimant" <u...@iscar.co.il> wrote:
> If I understood you try using the following
> ( I assumed you are on SQL Server 2005)
>
> create table test ( i int identity not null primary key, j int not null
> unique )
> create table #log ( i int not null, j int not null)
>
> insert into test (j)
> output inserted.i, inserted.j into #log
> select o.object_id from sys.objects as o
>
> select * from #log
> drop table #log, test;
> go
>
> <Jor...@gmail.com> wrote in message
>
> news:1187156242.461630.249440@q4g2000prc.googlegroups.com...

<Jorvin@gmail.com> wrote in message
news:1187158704.022867.200330@i38g2000prf.googlegroups.com...
> On 8 15 , 1 47 , "Uri Dimant" <u...@iscar.co.il> wrote:
>> If I understood you try using the following
>> ( I assumed you are on SQL Server 2005)
>>
>> create table test ( i int identity not null primary key, j int not null
>> unique )
>> create table #log ( i int not null, j int not null)
>>
>> insert into test (j)
>> output inserted.i, inserted.j into #log
>> select o.object_id from sys.objects as o
>>
>> select * from #log
>> drop table #log, test;
>> go
>>
>> <Jor...@gmail.com> wrote in message
>>
>> news:1187156242.461630.249440@q4g2000prc.googlegroups.com...
>
> Thanks a lot first.
> I am afraid that you misunderstood what I meant.
> I am on SSIS.When the package executing, I want to get a property
> value of a sql task component in the package.I tried to do it in a
> script task ,but I don't know how to refrence the component by name .
> What can I do?
>

<Jorvin@gmail.com> wrote in message
news:1187156242.461630.249440@q4g2000prc.googlegroups.com...
> For example,I want to get the run-time value of SqlStatementSource
> property,and record it into a log table.
> Can I do it in the script task component?
>