but is it possible to update a value in a sys table?!

Yes,it's true.

But before to transfer the data I have to truncate the destination table.

And if the stored procedure doesn't return the data I don't want to do the truncate.

What is...

Thank you, this functions properly.

I found the solution at this link too:

http://geekswithblogs.net/stun/archive/2009/03/05/mapping-stored-procedure-parameters-in-ssis-ole-db-source-editor.aspx

But is it some way to test how many records return the stored procedure?I need to transfer...

I think this could function properly....select * from #t1 where 1 = (case when ididivision=100 and idcompany=1 or iddivision=240 and data between @beginLastYear and @endLastYear then 1

when...

Thank you Phil, very useful!

thank you very much

I wanted to avoid 'insert into #table select * from table'... and only use 'select * into #table from table' simply because is too fast...

But I think that I'll...

My stored procedure is not so simple.I have a lot of values for that parameter and I have to do different things for every case.I can not use the same...

thanks, it was so simple....

For me is very important to have the right order in the table.

For the first record I must to have the value of the first field of my original table,...

thank you very much.

Thank you very much, I didn't have any idea how to do it.....

But if I insert another record in the table

insert into ##prova values ('$',2000)

Is it a way to have...

Thank you very much

You're right.

Unfortunately when I wrote the first post I didn't know the customer still uses 2005.

Do you know how can I do the same in sql server 2005?

This functions properly only in sql server 2008 and 2012.