Thanks, I'm aware of the situation but I really don't have the means to recreate a sample dataset...I'm working with protected information and it would be cumbersome to try and...

Bumping this back up as I did end up solving my original problem, but have another related question.

I ended up dumping fixed-width altogether and going with ragged-right. Afterwards it...

Oops, thanks for the heads up on the typos. Hmmmm, I'll have to try it again. When I ran as written, no matter what I set @db to...

The header row delimeter is CRLF, though I've tried LF before; it doesn't make a difference. There is no row delimeter as I've got it set as fixed-width. ...

Yeah, I am seeing clustered index scans, I'll see if I can up a graphic of it.

Setting the query as Chris suggests actually seems to perform the quickest, but it...

Thank you for your response! Sorry I wasn't more clear; my original query is at work and I just remembered that I wanted to look for help with that...

Thanks everyone for all the help! That actually seems to work quite well, and I've got my package working the way I need it. Thanks again!

Nice, I'll try that out. What is the expression syntax? I would just integrate that into the source dialog in the connection manager properties?

I was just starting to...

Interesting - and I'm assuming that would be faster than building/calling appropriate stored procedures for each "output" I want? I ended up deleting off my outputs, and essentially handling...

VS2008, I'll play with it some more tomorrow at work and see if I can figure out what's going on...

I think I've got it now where the script component is doing exactly what I want.

One thing - I notice that intellisense will off and on stop working when editing...

Thanks! I actually think the script component looks sort of like what I'm looking for...it looks like I can manipulate incoming rows and send them to multiple outputs. ...

Can't be done, huh?

Michael Valentine Jones (3/19/2009)

---

Re-designing the database to overcome network and application issues is usually a very bad idea.

It would be better to re-write the application to work as a n-tier...

Bump? Anyone?