Lads,

You all done good. Thanks for de-mystifying the issue for me.

I'm not too keen on the @@rowcount check because it does not look logical. eg..

SELECT @variable_name = {some_data} FROM {some_table}...

quote:

---

Generally, probably true. Absolutely true? No

---

Finally a realist. I have been in this...

If you have to be a ludite and use a text editor to develop SQL, rather than as suggested by another responder - use GUI it's easier - then it...

Try using the standard ActiveX Copy feature within the Transform task.

Basically, Add a Text Source, Add a Database Table Targe, Connect using a Transformation, Identify the Source, Identify the Target...

Try creating a database table which contains the name(s) of the files to be imported.

The first step of the DTS would be to read the name of the file to...

What about creating a temporary table?

Prior to running the query create a temporary table into which you insert all the values in the @param field eg:

CREATE TABLE #TEMP_KEYS

(

KEY_FIELD nvarchar(x)

)....etc.....

CREATE INDEX...

-- #

-- ### Add as many comments as you can to all your T-SQL

-- ### Ensuring that a reader of your code knows

-- ### Exactly what it is the following...

quote:

---

I have two tables in my DB

---

Have you tried :-

INSERT INTO Table1 (

...

Connie,

I ran your script and all seems to work fine in WK2. There is however a typo in the code :-

strLenght = Len(strCurrentMonth)

It does not seem to cause a problem...

Your client asks you to import data currently maintained on Post-It notes via a DTS and are not surprised when you achieve it?

Your client thinks adding a new entity is...