I don't see how I can make it work.

My script task to pre-process the file works pretty well but it doesn't seem real professional. At least it's a backup...

Wait a minute. My problem is happening very early on in the pipeline, in the flat file connection mgr. Any fix I would implement would have to happen prior to...

Ahhh! I see. Great idea. I'll give that a try. Thanks!

Seems like the best idea I've heard. I'm just not grasping how a derived column gets me around the problem. Can you give me a little bit more detail?

Thanks!

Yadava. I like your solution a lot, it's just that the existing data flow that I would have to clone is pretty complicated. I'd hate to turn this into a...

All the mgr. types wanted me to use SSIS, and since I knew I could make that work I didn't argue. Are you suggesting I use SSIS BULK INSERT task,...

The input file has 266,000 420 byte records. I was trying to import it into my SQL Developer instance on my run of the mill 4GB laptop. Using the RBAR...

Unless anybody has a better idea, I'm going to write a script task to pre-process the input file and strip out the CR/LF's before the import. I'm not sure why...

I've come up with an adequate solution. Thanks.

A positional file is a flat file that contains records of a specific format. That is all record members start at a specific...

Thanks Koen. That's the answer I was hoping for.

I know I'm probably not supposed to do this sort of thing, but I noticed your certifications. I need to get my...

Actually I have many more search criteria. All are strings. Can I still take the simple approach or does that change things?

Thanks as always!

Fantastic info, which is exactly what I knew I would get as always from this forum. Gails post is exactly what I needed.

Thanks all!!

Great. Thanks for the quick response. I can't actually get to the box to try it. I'm sure you're right. Maybe I'm thinking of variable initializers.

I appreciate the concept, and I can definitely go that direction, but forcing developers (of which I am one) to use the sprocs and not the tables directly can be...

Thanks Dev. I hear ya. I like that plan, but what would be the best way to enforce the the "two members per team" rule on the server side? Check...