Jedak (1/18/2010)
I've written a ton of DTS packages
I wrote only two or three when I was preparing to MCP exams, so I have a very brief experience in this area 🙂
I forgot to point out another link (http://msdn.microsoft.com/en-us/library/ms188279.aspx):
Linking Servers
A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers.A linked server definition specifies the following objects:
- An OLE DB provider
- An OLE DB data source
So you can only use OLEDB in linked servers. This means that only the quotation mark (?) can be used as the parameter marker in 'EXECUTE AT' statements.
Now I understand that .NET SQLClient and OLEDB are different things, and I understand your point of view 🙂 Thanks for the MSDN link, it's very useful.