Post reply

Question about extracting data from different ways from OLEDB Source

  • July 27, 2012 at 11:36 am

    #264391

    This may seem very simple for many of seasoned SSIS punters. I wanted now for extracting data from OLEDB source we use different options like

    - Table Or View

    - Table Name Or View Name from variable

    - SQL Command

    - SQL Command from variable

    My question is all there options does the same thing. Why these many number of options. Please let me know.

  • July 27, 2012 at 11:57 am

    #1518678

    Smash125 (7/27/2012)

    This may seem very simple for many of seasoned SSIS punters. I wanted now for extracting data from OLEDB source we use different options like

    - Table Or View

    - Table Name Or View Name from variable

    - SQL Command

    - SQL Command from variable

    My question is all there options does the same thing. Why these many number of options. Please let me know.

    Because they do not all do the same thing.

    Table or View accesses a table or view.

    Tablename or Viwename from variable expects a variable containing tablename or viewname

    SQL command requires input of SQL command

    SQL Command from variable expects a variable

    You will come to see the different uses as you go along. I mostly use SQL command in order to sort my output and not bring columns I do not want. Could be used for filtering also.

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

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