Just a quick question re DTS packages. We have a legacy product that is written in FOX and to run reporting off it we are going to DTS the data into a SQL database on a weekly basis. The issue I have is that I have created a shared directory to the Fox database but whenever I run the package via a schedule it doesn`t recognise the share. Whereas if I just execute directly it works fine. Why does the scheduled job not pick up the share ?
Any thoughts would be great.
Cheers
Si