Hy ,

how can i check that point :

"Have you verified that the task that fills the object variable is set to full result set?"

myrecord is fill by a simple adodatareader...

yes, in my sql commande ,

SQLSERVER :

select nom,id,date from mytable

nom varchar(50)

id interger

date datetime

this sql commande is linked to the variables Myrecord : type Object

In ssis,

Variables :

User::name string

User::id int32

date...

Oups, sorry, i have written date index 3 , but is index 2

so all my field are mapped to the index 0,1 and 2.

despite that mapping , i have...

At the end, i have took an other option :

i 've done as explained here :

http://www.windows-tech.info/15/b99bb4046f3f0c09.php

and everything goes right.

i will work on the upgrade to MSSQL 2008 in a...

Moreover, i have the DVD of SQLSERVER 2008, with SSIS 2008, which would give me the possibility to use ADO.NET Destination.

But, i have tried to upgrade SSIS 2005 to SSIS...

Hy, DEV,

it would be exactly what i want to do, but, i have installed the ODBC .NET Data Provider, and i can see the .net Framework Data Provider for ODBC...