Hi , i have a problem with a dts which have two steps .
First step run a data pump from sysbase database to sql server ( sql server
2k sp 3a on w2k server )
Second step is a store procedure that read record ( using a cursor ) and
make an elaboration , record read is more then 400.000 .

The first step run right the second step put the error in this log text .

The execution of the following DTS Package succeeded:

Package Name: Aggiornamento Dati Pivottone
Package Description: (null)
Package ID: {54C96150-B093-4D94-AA7B-7A4DE63D7EB6}
Package Version: {2EC9C0E4-0BF1-411B-99B7-38CE1047C2FC}
Package Execution Lineage: {1277D71D-FD60-4DFF-92D6-4D6A7E61BD4D}
Executed On: POMPEO
Executed By: SYSTEM
Execution Started: 13/01/2006 9.33.23
Execution Completed: 13/01/2006 19.29.53
Total Execution Time: 35790,985 seconds

Package Steps execution information:


Step 'DTSStep_DTSExecuteSQLTask_1' failed

Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Lo schema di tabella è stata modificato dopo la
dichiarazione del cursore. Impossibile completare l'operazione del cursore.
(Microsoft OLE DB Provider for SQL Server (0): 200511)
Step Error code: 80040E14
Step Error Help File:
Step Error Help Context ID:0

Step Execution Started: 13/01/2006 10.07.35
Step Execution Completed: 13/01/2006 19.29.53
Total Step Execution Time: 33738,188 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecutePackageTask_1' succeeded
Step Execution Started: 13/01/2006 9.33.23
Step Execution Completed: 13/01/2006 10.07.35
Total Step Execution Time: 2051,875 seconds
Progress count in Step: 1458

One thing , if i run only the second part , there are no problem ... i don't
understand what can be the problem . Maybe transaction ?

can u help me please .

Thanks a lot and sorry for my bad English ......

Thanks

Paolo B.