"Faiza Ashraf" wrote:

> Hi ,
>  I am trying to insert data from SQL server 2005 source into DB2 table.
> I am using OLEDB command transformation with a connection(successfull) on
> DB2 This is the Syntax i am using inside OLEDB command task:
>
> Insert into MMTSTLIB.INTIIF
> (IIFDTA)
> values
> (?)
>
>
> The query gets parsed successfully. The problem is that SQL sends null in
> place of ? in this query , although i have data in my source SQL table.
> Because of this i am unable to send data to DB2. Can you tell me if there is
> naything i am doing wrong? is this because using '?' syntax is not allowed
> when using SQL on DB2?
> i have a build waiting here today...can anybody help?
>
> Faiza
>
>
>