Not to worry. I found this

BULK

INSERT dbo.[DIM_ACCOUNT_MASTER_UTS_STG]

FROM 'E:\FTP\test.txt'

WITH

Thanks a stack Diego, it is working now. I ran the uninstall utility and there were a few SQL 2005 components that it picked up, I removed them and cooking...

Not sure what you mean. The cd says x86 software SQL Server 2005 developer Edition. I have the Itanium and 64 bits cds aswell.

it says

"SQL Server 2005 Setup has detected incompatible components from beta versions of VS, .NEt Framework, or SQL 2005. Uninstall from Add\Remove........

Thanks guys, I finally got one of our VB guys to do it with the code provided.

Thanks again

Hi, thanks for the info.

Unfortunately we cant upgrade at this moment. I am using crystal 8.

If what you say about the BLOB field storing the location address, why doesnt it...