hi everyone,

Even when i remove the comments it deosn't work.

here is my code:

select coalesce(SUM(case when Dat_Echeance=? then 0 else Taux * Qte_Devise end ) ,0) AS Qte_Ecrs_Tx

FROM Wrk_Agreg_Faible

WHERE Id_Tranche_Rec_Dur_Init IS NOT NULL

AND Cod_Famille_Taux <> 'S' -- hors produits structurés

GROUP BY Dat_Mvt_Ecrs

,Cod_Type_Tcn_Transcod

,Cod_Devise

,Cod_Famille_Taux

,Id_Fam_Tranche_Rec

,Id_Tranche_Rec_Dur_Init

,Cod_Emet

,Lib_Zone_Geo_Mec

,Id_Categorie_Not;

I have this error when i execute the old db source:

"It is not possible to extract parameters from the SQL command.

The provider can prevent analyze the parameter information from the command.

In this case, use the access mode "SQL command from variable" in which the

entire SQL command is stored in a variable.

violation of authorization or other non-specific error (Microsoft SQL

Server Native Client 10.0)"

Thank you for your response