other thing to mention is setting memory on the sql server box. our servers are dedicated to sql server and we set to use 90% of available memory for sql...

There are no PK;s since begining but they do have clustered index I dont think if that serves as PK , Actualy we do not have a unique key on...

when you say calculated column is it a derived column in ssis where i need to add conversion.

I do have a derived column in between the flat file and destination...

can i just script out all of the table scripts from the main database and run them in the rest of the dataabases so that all of the database's have...

I chcked that already but its not that option is only for look up componenet but i have problem with other regular componenets.

but still i get error at GO, if that ios removed error is at SP_RENAMEDB

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'go'.

Msg 102, Level 15, State 1,...

i get this error

Msg 102, Level 15, State 1, Line 19

Incorrect syntax near '0'.

yes both are smalldatetime.

when extract data using ssis pkg i am not getting the 3 additional decimals bu when do a regular insert i am getting them.

I do not have any PK on my tables except that we have clustered index.

It is shown as MS SQL Server Mgmt Studio in the activity monitor.

I understand, un less we have any problems it should be OK but how should i explain...

every single column except some getdate fields as anyways they would differ.

NO

under Latin1_General what is the option i have to select to get

Latin1_General_CI_AS

Option are

Binary

CAse-sensitive

Accent - sensitive

Binary- code point

Kana-sensitive

Width-sensitive

do i need to update statistics after attaching databases and anything else to be done?

but it gives a collation conflict error still if you are assuming they both are same