I think 'Jamie' was the name you were looking for 🙂

You could try something like this (untested):

Select HouseLine1 = (case when len(House_No_End) > 0 then House_No_Start + ' - ' + House_No_End

when len(House_No_Start) > 0 then House_No_Start

else House_Name...

How big is the file, roughly?

One option would be to pre-process it - maybe use s script task to replace "" with ".

If the file is huge, it might make...

kurt.whaley (5/9/2013)

---

I have an FTP command file that I want to open in a data flow and then using a Script Component find the "get" command and dynamically assign a...

s_osborne2 (5/9/2013)

---

The error seems to suggest your script task may be trying to display a message box. When this package is running via the agent there is no user to...

David Rueter (5/9/2013)

---

@Phil: 🙂

Not to belabor the point... but "generation and display of graphic output" sounds like it applies to a PDF...as well as JPG, PNG, HTML, etc. ...

How did 2005 handle it? Did it ignore one of the two repeated "s?

If it did, sounds like a bug to me.

I just had a quick look - if you...

I'm at risk of sounding repetitive I know - sorry but I couldn't resist trying again.

Here is a link to the Wikipedia definition of 'rendering'.

It relates to the generation...

There is a solution -...

Reported as spam.

Reported as spam (again).

Do not use messagebox in server-side jobs. There is no one there to click OK.

Try this for starters.

Then please post back with any specific questions.

That's a neat technique, thanks for posting.

Quite a common requirement seems to be reading the first n characters, or the first row, of a text file to determine its type/layout...

I've just checked your solution - the data flow starts by using a Script Component to check the file type - and every single row of every file will go...