Are you running on SQL 2000? If so, turn on package logging and see if that gives you any info.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click...

Why do you need to use the CAST in the indexed view?

Surely the presentation/formatting of the data is something best left with the application?

Just a thought.

Hope this helps

Phill Carter

--------------------

Colt 45...

Steve

VBScript does have a FormatDateTime function, however unlike VB it does not allow you to specify a formatting string. You can only specify one of five pre-defined constants, eg: vbShortDate,...

Not sure I fully understand what you want to achieve, but how about this.

Create a temp table with an identity field that has a seed value of the first number...

I know, the formatting for code isn't the best, but they're working on it

I like your use of the extra functions for the month and...

When a package is executed it assumes the security context of whoever/whatever triggered the execution.

eg: When you execute the package it runs under your security context, when SQL Agent executes...

I'm presuming the DTS Package is setup as a scheduled job. That being the case you can set the Retry attempts and Retry interval on the Advanced tab of the...

Do you get any sort of format file or header record that can be used to determine the columns?

If so, and you're using SQL2K, have a look at the properties...

In SQL7, the logging is only to a text file. From memory I think this is specified on the General tab of the Package Properties window.

Hope this helps

Phill Carter

--------------------

Colt 45...

First thing to do when scheduling a DTS package that you can manually execute successfully is check the permissions.

Also, given the message says something about DLL's, maybe the DLL...

Can you provide some more details about what you want to do?

For starters, do a search (http://www.sqlservercentral.com/Search/fulltextsearch.asp) for XLS, there have been a number of discussions dealing with Excel files.

Hope...

Have you checked that all the permissions are correct? That's usually the cause of a lot of problems when you try and schedule a DTS job.

Are you getting any other...

Check out 'Professional SQL Server 2000 DTS' ISBN:1-861004-41-9

The Appendix A lays out the DTS Object library pretty well.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

You can't do any conversion within the view. Check out 'Creating an Indexed View' in BOL.

Also, you'll need to add a COUNT_BIG(*) to your statement. Just another of those many...

... is fun

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface