Did you create the package from your pc or actually sitting at the server?  If you created the package at your pc, you probably won't be able to schedule it.  I...

I've come across the same thing.  Try this.  Open the package and do a "save as" and you will see where the password was probably hard-coded.  After you save it with a different...

We had the same issue with the Client Access driver and could not count on the results, so we ended up purchasing a driver called HiT to install on the...

Actually, that's what I did too--create a job to look for my trigger.  If your application is pretty much done with modifications and the indexes help performance, I think you...

We use Remedy here too but haven't experienced any performance issues yet.  However, before making any changes to the tables you may want to review your service contract if you...

I found this to be the easiest way:

Install Pervasive Client on the SQL Server and create an ODBC connection to the Pervasive data. 

Create a DTS package and select "Other...

If it is an older Access database like Access 95 or 97 you might have to convert it to a newer version before the option is available.  Also, are you trying...

The error message is deceiving.  I've gotten the same one when trying to create a linked server to Oracle 7 / 8i.  The problem ended up being the Oracle alias...

We saw those kinds of errors when one of our locations added a firewall. Don't know the particulars, but it took weeks for the network guys to figure it...

I have a procedure to BCP from a view and export the data into a spreadsheet. Works like a charm.

EXECUTE master..xp_cmdshell 'BCP Database..ViewName out "E:\FullPath\Spreadsheet.xls" /c /Sserver /Uuser /Ppassword'

Linda

...

Or you can create a view and BCP from the view.

Linda

That error occurred here once too following the install of sp3. The log file to look for has a .mdmp extension but you can't read it in notepad. ...

Which evaluation edition are you trying to install? Take a look at 'Hardware and Software Requirements for Installing SQL Server 2000' in Books On Line. You may need...

We also have problems with unskilled Access users because of a third-party application that uses DSNs with too much permission. Since we cannot change the situation, I monitor who...

This may or may not help, but we got the same error when someone changed the drive letter where SQL Server was installed. This might not be your issue,...