I have a SQL 2005 cluster installation without SSIS and without management studio (I didn't install it).
Now we need to import data from an excel 2007 file into a specific table in a database.
I have tried doing this from a remote management studio, BI development studio and DTSwizard but I can't seem to make it work.
The error message from BIDS is that "the data source is on a remote computer..."
Does any of you have a step by step guide that works from a remote location.
View Complete Post