Matt, While I...

Whack the following into a SQL task at the end of your package, and you should be good

You'll need to edit both the path and the file name you want...

Take a look at this article.

http://www.sqlservercentral.com/articles/DTS/importingthelatestfileinafolderviadts/1829/%5B/url%5D

It finds the latest file in a folder and could be adapted to your needs?

HTH

Dave J

Try this

[font="Courier New"]CREATE PROCEDURE dbo.usp_GET_ITEMS

@ITEM_IDS varchar(1500)

AS

SET NOCOUNT ON

CREATE TABLE #ITEM (ITEM_ID INTEGER)

DECLARE @Comma_Value VARCHAR(8000)

select @Comma_Value = @ITEM_IDS

DECLARE @Counter INTEGER

DECLARE @Comma_Point INTEGER

DECLARE @String_Length INTEGER

DECLARE...

Nooo! :w00t: If you restore master, the server won't be aware it IS a cluster! I'm afraid you have got to do some leg work. Not that much...

David Jackson (1/19/2008)

---

David Jackson (1/19/2008)

---

Am I missing something? (likely :P)

Did you intend to use your view in a join?

I've answered my own question. 🙂 This...

I've answered my own question. 🙂 This does it.

Declare...

PW (1/17/2008)

---

>>Heh... I'm thinking that's not quite true, PW... see David Jackson's post. Only limit is the 8K barrier in SS2000.

Right, it is dynamic, but it doesn't avoid a...

Cheers Jeff.

(I'm replying to test my newly created sig) 😛

Edit: How do I get a line in? Hang on... Got it 🙂

Dave J

One more thing, you will want an Order by sptd_lineno in the function to guarantee they come out in the right order.

Another one of those 'bloody obvious' solutions once you...

You can use a function with no cursor for this.

create function fn_GetComments (@keyno int)

returns varchar(8000)

as

begin

declare @comment varchar(8000)

select @comment = coalesce(@comment,'') + Rtrim(sptd_text) from sptextdt

where sptd_keyno = @keyno

if @comment is...

If you don't mind creating a function, this will do it.

if object_id('udf_csvlist') > 0

drop function udf_csvlist

go

create function udf_csvlist (@name varchar(255))

returns varchar(8000)

as

begin

declare @list varchar(8000)

select @list = coalesce(@list,'') + activityName...

Regarding the larger images, they used to work but the site upgrade appears to have killed them off. They are just standard DTS screenshots however. You can see...

FYI, I have tracked down the offending rule in *our* mail anti-spam product, (mailsweeper), and I'm now geting my daily fix again. 😀

It objected to the word sex aparently....

(From the...

Try a SET DATEFORMAT statement at the top of your script, obviously using the correct settings for your data. If the dates were in the UK, I'd use

SET DATEFORMAT...