Are you running it locally or scheduling it to run?
What we do is create a connection to excel and a connection to whichever database we need. Then create a datapump to excel, it will ask you to create...
The reason that it fails (most likely) is that the server SQL Server is installed on does not have Office installed so it does not know how to...
I originaly placed this in the DTS forum, but being new here I reconsidered and thought that this might be the appropriate place.<br /><br /><br...
<br />I've created two sproc's to measure DTS package and DTS Step run times. It gives either an exact time or an average. Logging needs to be turned...
Separate names with a comma.
