nevermind the fun when your order by field is the last one, and then you drop a field.....

Try flipping that around. As in, something like....

Where (Case When @Ticker IS Null THEN Ticker Else @Ticker End) like '%'+ticker+'%'

Or - with being a little more thorough

Where (Case When @Ticker...

sorry - just notice you're dealing with SSIS in this case, and the code I gave you is for "classic DTS".  SSIS seems to have slightly different syntax (such as -...

Hmm - who's Spid and what has he done to get a contract out on him?

I fully agree with you - the split sequence using SQL gets shot to hell with the pivot table.  Not irretrievable but highly messy, which was why I brought the alternate...

When you describe this "Excel-like" setup - is that absolutely required as the data entry mechanism, or are you describing what the "report" coming out of this data should look...

I feel for you - I've been in situations like that.  I don't understand the concept, but having been in the job pool recently, I got the distinct impression that...

Well - while i often would agree that a fair amount of data manipulation should be done server side, forcing the server to do things "it's not good at" doesn't...

What are you trying to do with this call?  It's not terminating, because notepad isn't self-terminating.  It's probably sitting in some hidden state - waiting for something to do or...

So it's probably fair to say that it scans the table until it found enough matches?  meaning - if you had 10 matches, but the 10 you're looking for happened...

The reason I am asking is that if you don't know how deep this will go - you need a recursive method, which would very easily subject you to any...

Now - are you sure that this is processing SQL-side, and not web server side or client-side?  You are encapsulating this in a stored proc, right?

Stole this from some code I have previously used:

dim pkg as new package

pkg.GlobalVariables.Remove(

"filename")

pkg.GlobalVariables.AddGlobalVariable(

"filename", <value&gt

pkg.Execute()

You apparently need...

Does the machine running the package have the DTS runtime components installed?  Are you creating an install package (which would have the extra pieces like the DTS runtime DLL in...

What you're asking to do is built right into DTS - just make sure you use the "on success" and "on Failure" connectors.  Assuming you put the "e-mail customer on...