You should read in Books Online about BULK INSERT, bcp and DTS, then post again if there's anything you don't understand.  We can't give you an example unless you describe...

Have a read about dynamic properties in DTS.  It's not something I've used a lot myself, but I think it will do what you need it to.

John

Arthur

Just set the rest of the parameters to default to NULL - and include logic within your procedure to deal with this.  Look up CREATE PROCEDURE in Books Online for...

BULK INSERT, bcp and DTS can all do this for you.  Sounds like DTS might be your best bet if you have more than one file since you can use...

Mark

I believe the sysobjects table has a crdate column, or something similar.  But beware - check what happens when you alter a table (for example by adding a column): does...

From memory, the CREATE PROCEDURE permisson will only allow you to create MyUserName.MyProc - you won't be able to create dbo.MyProc.

John

Create your DTS package, then right-click on it and choose Schedule Package.  This will create a SQL Server Agent job that invokes the package using the dtsrun command line utility. ...

From the Search Condition topic in Books Online (for SQL Server 2000, but I don't think it's changed in 2005):

The order of precedence for the logical operators is NOT (highest),...

Then I think you need to use a temp table, something like this (tweak this to suit your own requirements):

CREATE TABLE #t1 (clName char(10), clID int)

INSERT INTO #t1...

This is very similar to one I answered yesterday:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=337775#bm337792

Andrew

If you can "see" one server from the other, use the Transfer Jobs task in DTS.  If you can't, use Enterprise Manager to generate scripts for each of the jobs.

John

Actually, I must have been asleep when I posted that query.  It won't work.  What we need to know is where there are duplicates in your column, which row...