I'm having some trouble getting some scheduled packages to run. I have created a package (SQL Server EP 2000) to pick up the most recent flat file in a folder and import it into a table. I can run the package manually just fine, and I can manually execute the job, but it always fails when it tries...

Welcome to the Forum & DBA World! First of all you have to ensure whether the local SQL Server services has been started successfully, also relevant protocols are enable from Server network utility, also ensure client tools are properly installed as this could be flaky issue of Enterprise manager...

Hi all, I've been reading up on DTS and its transactional capabilities and have a quick question regarding Package vs. Step transaction settings. Let's assume these parameters: DTS Package with "Use Transactions" and "Commit on successful package completion" boxes checked...