Do it like this,

Create Procedure test

@start int,

@end int = NULL

Begin

if @end is Null

@end = @start

Remainder of sp ...

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface...

Check the Global Variable definition. A couple of times I've had variables with the datatype set to dispatch with the value set to <not displayable>. The only way I was...

Not to sure about MSDE.

The EXE's for the connection utilities are usually stored in c:\winnt\system32. Look for something called svrconfg.exe, or srvconfg.exe

Failing that, you can always edit the registry. Look...

What sort of "macro" are you running? Maybe it can be changed to write out status messages?

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Don't know if this helps any, but maybe you could execute it by creating a Access object and referring to the macro via that object.

Here's and example of creating an...

Ok then, so for the best of both worlds, how about,

OPTION EXPLICIT

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

' Visual Basic ActiveX Script

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

Function Main()

< ... snip ... >

sFileName = sPath & ReturnMonth(sNow) &...

The Wizard usually includes a create table step. If the table already exists, you should remove the create table task from the package.

Hope this helps

Phill Carter

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

Colt 45 - the original...

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...