We are converting from SQL 2000 to 2008. Everything seems to be up and running and I have installed, I believe, everthing I need to use the old DTS packages and have actually tested some and they work.
However, one of them executes a stored procedure and I'm getting stuck at this point. When I open the properties for the execute package task and select the sql 2008 server and then try to select a Package name, I get an error that has this info:
ODBC SQL Server Driver....to connect to this server you must use SSMS or SQL Server Management Objects (SMO).
I've looked this up and saw that I need to install the SMO (which also requires MSXML, SS native client, SS CLR Types). I d/l'd those and installed (except for MSXML 6.0 because it said there was a newer version already installed).
Still have the same problem...any ideas?