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

Fairly basic stuff, this... I would recommend you spend some time reading about T-SQL programming.

UPDATE b

SET Actiontype = 4,

ActionNum = f.pluginid

FROM Routesteps a

JOIN Routesteptasks b

ON a.Routestepid = b.Routestepid

JOIN...

SELECT * FROM MyTable t JOIN

(SELECT DISTINCT DistinctRow FROM MyTable) d

ON t.DistinctRow = d.DistinctRow

John

Stacey

If I understand what you're saying, you're trying to connect from a computer on the same network as the server.  Have you looked at the Server/Client Network Utilities (or whatever...

Stacey

Are you running SSMS on the server or remotely?  If remotely, is there a firewall between the two computers? What is the authentication mode of the server, and how are...