Passing parameter

• RG-363812

  SSC Enthusiast

  Points: 150

  More actions

  February 16, 2007 at 2:32 pm

  #116275

  I am working in a conversion process of DTS to SSIS. This is a senario:

  I am trying to get data for the AS400 . The connection to the AS400 is ADO.net connection manager( I tried OLEDb connection as well). In the data flow, the date source has a query which users parameter marker. For ex:

  select *

  from XXX.XX.XX

  where left(XXX,2) = ? and right(XXX,2) = ?

  For data flow source if i use oledb source i see the place where variable can be mapped to a paramerte. I tried it, it doent work. It might be a bug if you are passing a parameter to a Dle db source.

  I am thinking of using a datareader source but i dont see how to map the a variable value to a parameter.

   

   

• February 19, 2007 at 8:00 am

  This was removed by the editor as SPAM

• RG-363812

  SSC Enthusiast

  Points: 150

  More actions

  February 21, 2007 at 8:04 am

  #690914

  Any respond will be fine.

   

  I will try what ever is adviced

• Rootman

  SSCrazy

  Points: 2641

  More actions

  February 23, 2007 at 4:26 am

  #691354

  I  had a similar problem with a query to sql server via an OLE db connection.  The query wouldn't parse.

  however, if I clicked the "Build query" button, and then ran the query, it seemed to work.  After that, the query parsed OK.

  worth a try!