You've got the order wrong in the SELECT TOP... statement. Try it like this:

select top 1 @@TheKey = InstantWinKey

Nice script. Note that to get it to perform correctly on SQL Server 2005 you must change "sysdatabases" to "sys.sysdatabases".

While I agree with Jack (especially about Service Broker, which can address both the synchronus and the remote server issues), I think that your first step here should be to...

Great article, I'm looking forward to using this.

Afraid I don't know much about Express Edition. Maybe someone else here can answer that question.

If you don't have anything else in your DB's it might be easier to just reinstall SQL Server. If you have other DB's that you need to retain, detach...

Well you can change the database's collation like this:

Alter Database itzakBG COLLATE SQL_Latin1_General_CP1_CI_AS

However it will probably fail because you already have objects bound to the other collation.

I think that you...

DB Mail definitely works on SQL 2005 64 bit, I use it all the time. You may need to have SP1 to use it for SQL Agent alerting though.

If...

You can check a databases collation with this command:

select DATABASEPROPERTYEX('MyDB', 'Collation')

It appears that your hosts SQL Server DB and your home SQL DB do not have the same collations.

Try using BCP for this. It is a lot faster than either DTS or SSIS stuff like this.

By the way, how is it that you have access to DTS...

You can use Database Mail to send, unless you need to receive mail too.

Glad I could help.

The simple datatypes (like int) cannot have multiple values at one time. If you want to do something like this you will need to:

A) use a Varchar() string encode...

This seems to work for me:

Create View vwIngresoLector_Import

as

Select ImportColumn from IngresoLector

GO

BULK INSERT vwIngresoLector_Import FROM 'C:\Archive.dat'