OLE DB Source Adapter
The OLE DB source connection has several Access Modes:
Openrowset
Openrowset From Variable
SQL Command
SQL Command From Variable
For now, I am going to focus on the SQL Command options. Using the SQL Command Access Mode requires you to set the SqlCommand property (typing in your SQL query directly), effectively ‘hard coding’ [...]
