All time succeded this.

By example run this:

BEGIN

update server1.table set Comments ='TEST' where adcid=2

END

this execute without problem, but when I execute this, show the same error:

BEGIN TRANSACTION

update server1.table set Comments ='TEST'...

Hi, I has doing that you wrote, but show this error:

Error at Data Flow Task [Excel Destination Recuperados [1570]]: An OLE DB error has occurred. Error code: 0x80040E37.

Error at Data...

Hi, thanks by your answer. I has add to Expressions property, the ConnectionString inserting the code that give me, but when run the package show this error:

Nonfatal errors occurred while...

Jeff, thanks by your help. Thats just what I needed.

Thanks Antonio, thats just what I needed.

Thanks Jhon by your answer. The solution was change 'Protection Level' from 'Encrypt sensitive data with user key' to 'Rely on server and storages and roles for acces control'.

Adam, finally I can export the data...but How i can export the data with headers of columns the table?.

Thanks a lot by your help.

Thanks Adam by your answer.

I want to use the BCP. Sorry is the first time that I going to use this function, can yu help me, step by step how...

'D:\AHD_Nuevo.dat' is a backup that has done using SQL Server 7. Now I have SQL Server 2000.

The .dat is in Server Drive.

I'm using the Enterprise Manager.

Right-click Database->All Tasks->Restore Database

Thanks...the problem has been resolved.

Thanks by your help...

The column Fecha_Apertura int 4

The data that I want convert is e.g:     1157472771

And when I use the script: Convert (Fecha_Apertura as datetime), show the follow error:

Arithmetic overflow error converting expression to...

Hi, I have a problem I want UPDATE a column of name "alumnokey" of type "int" to "int identity(1,1) primary key", when i want do the change, show me error. Someone know how can...

The solution is in create a table in the destination database, with the column respectives, after import with DTS to the created table, and that is the solution.

Lucky