figured it out.. just have to look at sys.foreign_key_columns catalog view.

currently i am building the recordset in OLE Source using T-SQL. I want to know if there is a way to do it in ssis itself. I am testing aggregate...

select col1, col2, col3 from

group by col1, col2, col3

Thanks gail..

select objectproperty(object_id(N),'TableHasIdentity')

This is what I came up with..

if (select max(cast(is_identity as int)) from sys.columns where object_id = object_id(@tname))=1

then identity column exists

else identity column dont exists..

is there a better way?

i figured it out.. simple update will work

declare @timeline table(

[month] varchar(8),

[enddate] varchar(8),

flag char(1)

)

update t1 set...

my login does not have permission to run those commands on the server. I am not a member of the sysadmin role. thanks for the help. in the future, i will...

i dont have permission to execute dropcleanbuffers or freeproccache

both fields have the same number.

even after updating statistics the numbers are not matching. The table has 75 columns and row size is 842 bytes. there are around 1,000,000 rows in the table. I have...