Do you have any precedences on the data pump? If not, try setting one using the copy task as the source. I had problems this past week when the...

We have several tasks of this sort and in the package we first delete the current spreadsheet, next recreate it using an ActiveX task and then populate it. One...

I agree with Jonathan. I've had this issue several times, always after Excel has been removed from one server or the other since our standard configuration does not include...

Here goes... THe names have been changed to protect the guilty

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

 Dim appExcel

 Dim newBook

 Dim xSheet5

 Dim xSheet6

 Dim oPackage

 Dim oConn

 Set...

If you using SP3, check out http://www.novicksoftware.com/Articles/SQL-Server-2000-SP3-and-xp_cmdshell-Woes.htm

We have quite a few DTS pacakages that function similarly.  In each, we delete the spreadsheet using xp_cmdshell within an execute SQL task, and recreate it using the Visual Basic...

Thanks... I did check the file header and it is marked as a differential. So I guess I have to redo the process. My main question is why it...

I often have problems like this, generally when I'm trying to debug another developer's code. I generally start by removing the where clause completely. After that I add back...

I tried the Restore Database and it worked! Which is not a good thing since it restored on the 1st server as a Log. I'm following up with the...

Thanks. The same log file works on one server but not the other. I thought I had a problem pulling the log from the ftp site, so I copied the...

Try adding TRUNCATEONLY - this should release empty space without moving the data. Depending on how fragmented the data is, that can affect the elapsed time.

 We schedule...

And the answer was... Installing SQL with a local admin startup account initially. We were then able to change the account to a non-privilged account to run under.  Apparently,...

Our experience with similar problems have generally been one of two things: resources not available to the server (for example, exporting an Excel spreadsheet would work manually but not...

We use a book by Carl Rabeler SQL Server 2000 DTS step by step - although it did not contain any information on the specific task we were looking...

I setup an Excel connection and a database connection. I used the Excel connection to create a "table",  and setup a SQL query within the transform data task properties to...