Correct me if I'm wrong but even if you tell it that it already has the Schema and Data, it will still need the sp_MSins, sp_MSups, and sp_MSdel stored procedures....

thanks this sounds promising. I'm going to look into this and hopefully I will be able to resolve it.

Jeff Matthews

Thanks to the both of you. I will be trying both strategies late this afternoon and I'll let you know if this works or not.

Thanks Again!

Jeff Matthews

I had made a copy of the logfile and moved it to the new path while renaming the old logfile. Even after running the sp_attach_db and specifying the new path...

Yes, I used that method to get the Database re-attached, but my problem still exists. I need to move the log file off of one disk to another.

Jeff Matthews

I made sure to check the server's local drive and my local drive (just in case), but I didn't find the testjob.txt.

O.K. basically you don't know of any problems...

O.K. I created a package and ran it from a scheduled job. Then I looked in the c:\ dir for c:\TestJob.txt. I couldn't find that text file. The job reported...

Is this an Active X Script?

Jeff Matthews

Yes, xp_cmdshell executes successfully.

Jeff Matthews

Well that didn't work, so I'm back at square one.

Jeff Matthews

Can you execute (call a dts package) from a store procedure? If so this might be a solution (reaching here).

Jeff Matthews

Sql Job that runs a batch command

Jeff Matthews

Yes, I have some full-text incremental packages that run fine. It's just the ones that are calling DTSRun.exe packages. None of these are working. As a matter of fact, I...

Steve,

One of the packages is importing data from a text file, manipulating the data then inserting them into it's appropriate table. The others are exporting...

Yes they are enabled and I'm possitive that they ran. The dates are showing that they ran at the correct time. I have also recreated the package and recreated the...