Post reply

query as datasource?

  • October 27, 2011 at 7:55 am

    #250730

    Hi,

    Sorry but I'm kinda new to SSIS.

    Is it possible in ssis to use a query as a data source? I don't see how to add that in the connection manager.

  • October 27, 2011 at 8:45 am

    #1400200

    You do this not in the connection manager itself, but when you add a source in your dataflow. You will get the option to set 'Data Access Mode'. Set it to SQL command and you will be able to write your SELECT query.

  • October 27, 2011 at 8:54 am

    #1400215

    thanks phil!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply