turns out i only have a 2000 default instance 🙁

Is there a way to upgrade the 2000 instance without reverting back to the install CD?

any help welcome,

EamonOD

Giff,

that's worked.

I did get an error message with regarding a connection to the server and decided to reboot the server which did the trick 🙂

Thanks alot to you and all...

Hi,

It's just a single .mdf file, no bakup.

Thanks,

Eamon

found this out myself...

right click in the space within the data flow task and add the variable name to the expessions section of the properties.

was easy enough in the end.

E

Hi,

after playing with this I have learned that the substr function is ok and the problem is with the date(curdate()) part of the clause.

so, the original question should be.....has anyone...

Hi,

it runs fine for me but the SQLStatement associated with the blocking session is NULL. The SQLStatement text for the session being blocked is ok.

When i run DBCC inputbuffer(spid) against...

Perfect !!

THANKS 😀

Thanks alot Gail,

just as I thought !

Thanks,

Eamon:cool:

Thanks everyone,

the data has already been imported to TableSource which is a staging table and TableDest is the business reporting table. All I'm doing here is seeing if there is...

Thanks Guys for all the suggestions.

I have went for the following and under the circumstances this works fine.

The table gets locked long enough for my update to take place and...

' managed to get this fixed ok and here's what I did.

1.  I took the database OFFLINE.

2.  In windows explorer copied the files to a different drive.

3.  Deleted the OFFLINE...

Erik,

that works for me

Thank you,

Eamon

Hi,

the destination table gets truncated before the INSERT happens and yes it does have a clustered index and several non-clustered indexs. It took almost one hour to run.

I can't copy...

Cheers Greg,

thanks for that, luckily I was able to figure it out at with the logs and by counting through the steps.

thanks for this.

Eamon

that's VERY VERY useful and puts my problem in total context.

Thanks Todd