I would use mslava's method.

The problems with many of the earlier posts, which will tell you whether the file exists, is that they do not tell you whether you can...

Have you tried the DTSRUN utility?  Here is the stuff from bol:

dtsrun Utility

The dtsrun utility executes a package created using Data Transformation Services (DTS). The DTS package can be...

Here is another site that might help you

http://www.sqldts.com/

Jeremy

Found an answer here : http://support.microsoft.com/default.aspx?scid=kb;en-us;282966

I've fixed this now by deleting each step and recreating it.  Not sure why this would fix the problem or why the problem appeared in the first place.

Jeremy

I proved to myself with a msgBox statement that it is picking up the parameters at run time. 

Thanks

Jeremy

Thanks and a couple of questions.

1.  What's the best way of checking whether the DTS package is using the passed parameters?  I read in BOL that, depending on ownership and...

This may or may not help, but I found this UDF on this site:

CREATE Function fn_FileAvailable (@FileName VarChar(255))

Returns Int

As

Begin

/*

Return Values

 = 0 FileSystemObject can open...

Thanks Steve - it helps a great deal.

Jeremy

Thanks for the info.

I have just found the problem.  I discovered that when I checked to see whether the user already had Database access, I was getting a false result...

I must have an old version of BOL .  This is what mine says for db_ddladmin:

Don't use select *. Select the actual column names from table b.

Jeremy

Looks like Frank is away today but he normally refers people to these sites:

http://www.algonet.se/~sommar/arrays-in-sql.html

http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

Jeremy

Thanks for the ideas. I was thinking about a datediff function as well but it does need more investigation.

However, we going to try and get everything using Windows login...

SQL Server will change the dates into datetime fields so you query will read

select top 10 *

from fact_ins_booking

where date_key between '2002-10-16 00:00:00'

and '2002-10-25 00:00:00'

If your rows have a time stamp...