I have an Excel file that is periodically placed at a certain location on the network. I want to make MS SQL Server to read this file, and update a MS SQL table based on the contents of the Excel file.
Is this a job for DTS?
If so does someone have a quick cheat sheet on hoe to configure DTS to do things like this? I am pretty comfortable with SQL Server but have no experience with DTS.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Is this a job for DTS?
If so does someone have a quick cheat sheet on hoe to configure DTS to do things like this? I am pretty comfortable with SQL Server but have no experience with DTS.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports