Thanks Jeff...

I agree.. and I have IDENTITY as clustered index on the staging table which I am inserting into.

The problem is .. based certain business logic I am updating...

Thanks Jeff...

I agree.. and I have IDENTITY as clustered index on the staging table which I am inserting into.

The problem is .. based certain business logic I am updating...

I am loading data from different db... I am loading into staging table from staging table it will be loaded to different tables.

I have created index on the staging table...

Sorry.. I am not importing data from a flat file.. I am just importing from other table. So I am just using insert into .. select * from .....

I am...

I am doing the same thing.. I am dropping the index before insert... i am creating index after bulk insert. Then I am doing some bulk updates to the same...

I would suggest you to use sql instead of ssis...

in sql create a linked server and build the script insert into with select dynamically for all the tables.. that...

I will put table definition you will get clear picture..

I have a table : test with column A, B and C with datatype int

test(A int, B int, C int)...........

I know 1 will not be equal to 2,

according to that it should not execute the statement under if condition, still u will get error.

You can use this script...

Thanks naveed.

Really it is helpful.

Hey .. I got an idea...

Try using

WAITFOR

{

DELAY 'time_to_pass'

| TIME 'time_to_execute'

| [ ( receive_statement ) | ( get_conversation_group_statement )...

The above query is good, but it will give the accurate count all the time. Since it takes the count using the index.

It depends on the index how you created.

If...

There is no time bound triggers as for my knowledge. But what is your requirement, can you explain more.

I am not sure of this.. but check if they have released any hotfix for this.

There may be a bug in sp3 .. due towhich they might release a hotfix....

The above query is good, but it will give the accurate count all the time. Since it takes...

If it is not having...