Check out this article on Looping and Importing multiple files via DTS:

http://www.sqldts.com/default.aspx?246

I have used this code in a modified fashion to import from multiple files and tag the records...

I have found http://www.sqldts.com/default.aspx to be very useful when I need to get something done in DTS.  Plus a general familiarity with VB/vbsript technologies.

-Ed Zann

Another option is to  create the import and transformations in a DTS Package, then save as a VB .bas file, then build an interface around it.

The 5 users with valid NT SQL DB accounts will have access to the linked SQL objects.  The remainder of the users will have access only to the remaining non-SQL...

See the SQL BOL topic "How to restore a database with a new name (Transact-SQL)" for the TSQL command.

I don't use the wizard, but the Restore GUI inteface can also...

I agree that DTS might be the better way to go.   I have had similar issues linking to Excel on another server.  I believe it has to do with Windows...

I believe there are some sample databases included with some MSFT Code samples, like Duwamish, Fitch & Mather, etc.

You can download at:

http://msdn.microsoft.com/netframework/downloads/samples/default.aspx

Pubs & Northwind are most helpful because they...

If your DTS is accessing external resources, like drives on other servers, perhaps the account that ASP uses to execute the DTS does not have sufficient permissions, but the account...

Here is a "HalfHour" function I came up with:

/*

Returns the half hour segment of a date

numbered 1 - 48

*/

CREATE  FUNCTION [dbo].[HalfHour] (@TimeIn DateTime)

RETURNS int

AS 

 BEGIN

 DECLARE

 @Hour int,

 @Mins int,

 @HourPart int

 SELECT @Hour...

Refer to the DATEPART functions in your Books Online.  There are params for returning the month or the week. 

For the half hour - assuming you're using SQL 2000 - I...

@Find should be a VARCHAR(20).

When you use CHAR(20) it pads out to 20 characters with 19 trailing spaces.  So intead of getting '%', you're getting '%                  '.

In order to backup to a network drive, your SQL server must be started using a domain account that can "see" your network resources.

By default many folks just select "Local...

I appreciate all of your input on this.

I have tried the different approaches suggested.  I have found that the temp table approach is the fastest in my situation.  Here is the...

Also, you might look into the Transform Data Task Properties - Option tab. It has a couple of features that deal with errors during a transform. Click the...