Cursor... my word... A very effective non-cursor solution has already been posted. Why ya gotta go swearing like that? 😉

Hmmmm... it's starting to sound like a "connection leak", although I don't know for sure. We had that problem only once and, if memory serves correctly, we found out...

Heh... don't feel bad... it took me half a day to figure out what I was doing wrong the first time I forgot the parenthesis.

EXEC (@SQL)

Heh... I'm still trying to read what may be the greatest fantasy novel of all time... every time I get close to finishing a major part of it, they rewrite...

Steve Jones - Editor (2/23/2009)

---

I could grab them from the DB. We won't add "download", but perhaps an "forward on to an email" would be nice.

The delete is a mess....

p.s. You may have better luck if you posted this on the SSIS forum.

Yes... just sub a column name in the place of the string literal in both places.

So far as exactly how to do it in SSIS, I don't know because I...

I'd like to be able to click on a folder and select "Download" and have it create a simple file (or, 1 file each) instead of manually opening each PM,...

FULL OUTER JOIN would solve it all.

SELECT SUBSTRING('02968-01999-00013 - 9',1,CHARINDEX(' ','02968-01999-00013 - 9')-1)

I'd be happy to delete mine... right after someone tells me how to download them all. I'd like to keep the ones that still remain.

One of the few sets of "novels" I've read from start to finish is the 10 book collection for "John Carter of Mars" written by Edgar Rice Burroughs (same guy...

That would be correct... and the OPENROWSET solution I provided took that into account by using a discrete SELECT list.

And, I even phat-phingered my response... I meant to say "can't" and it...