@Shahfaisal; what you provided here is about destination, but question is about source ;) @Smash126; Table or View; You can select exact name of table or view from source database Table name or view name from variable; This is very useful when you want to do dynamic thing, for example you fetch table names from somewhere and load it into a package variable and then that package variable will be used here as source table or view's name SQL Command; you can specify a query, query can be structured based on underlying database. you can use joins, running stored procedures and .... SQL command from variable; Dynamic stuff again, when you want to create your select query dynamically and load it into a package variable and finally use that query as a source this option is very useful. http://www.rad.pasfu.com

@Shahfaisal; what you provided here is about destination, but question is about source ;) @Smash126; Table or View; You can select exact name of table or view from source database Table name or view name from variable; This is very useful when you want to do dynamic thing, for example you fetch table names from somewhere and load it into a package variable and then that package variable will be used here as source table or view's name SQL Command; you can specify a query, query can be structured based on underlying database. you can use joins, running stored procedures and .... SQL command from variable; Dynamic stuff again, when you want to create your select query dynamically and load it into a package variable and finally use that query as a source this option is very useful. http://www.rad.pasfu.com

@Shahfaisal; what you provided here is about destination, but question is about source ;) @Smash126; Table or View; You can select exact name of table or view from source database Table name or view name from variable; This is very useful when you want to do dynamic thing, for example you fetch table names from somewhere and load it into a package variable and then that package variable will be used here as source table or view's name SQL Command; you can specify a query, query can be structured based on underlying database. you can use joins, running stored procedures and .... SQL command from variable; Dynamic stuff again, when you want to create your select query dynamically and load it into a package variable and finally use that query as a source this option is very useful. http://www.rad.pasfu.com

@Shahfaisal; what you provided here is about destination, but question is about source ;) I agree, the table talks about destination(my bad), but my explanation holds good for source. Thanks.Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

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.Smash126

Hi, The SQL command option actually lets you write a SELECT statement which is very useful when you want to grab only a few columns from the table as opposed to pulling all the columns(for performance reasons). Each option is for a different purpose and is very handy in different scenarios. With the "from variable" option, you can make the package dynamic by having it grab the table name from a variable. This is very useful for example, when tables are created on the fly and so you would know the name only at run time. http://msdn.microsoft.com/en-us/library/ms188439.aspx Table or view Load data into a table or view in the OLE DB destination. Table or view - fast load Load data into a table or view in the OLE DB destination and use the fast load option. For more information about the fast load data access modes, which are optimized for bulk inserts, see OLE DB Destination. Table name or view name variable Specify the table or view name in a variable. Related information: Use Variables in Packages Table name or view name variable - fast load Specify the table or view name in a variable, and use the fast load option to load the data. For more information about the fast load data access modes, which are optimized for bulk inserts, see OLE DB Destination. SQL comman Load data into the OLE DB destination by using a SQL query.