Interesting.

I will need to deep dive into this to get a better perspective.

Thanks again,

Steve

Cheers.

Appreciate the time

Steve

Thanks!

Exactly what I was looking for!

The only thing that bothers me is what the SSIS server might hold, regardless of the amount of time its held. I'm not worried about what is being transfered...

Thanks for the reply. This is very interesting, and I knew that this was the place to find the answers.

It is troubling to me though that the data is...

LOL...dont get me wrong, I like the idea. Am actually testing the script component now to see if it will remove that pipe on those records that are affected....

Wow....go grab a coffee and my post has a bunch of solutions....lol

I think what i'm going to do is actually redirect the file as an error. As GSquared said,...

Thanks but not exactly. I need it to happen upon import, before it tries to import the file i need to verify that the format is right. Essentially...

Thanks Todd,

It was a shot in the dark at best.

Hey Gail,

Thanks for your reply.

I read your post and I guess was just looking for clarification of it without disclosure. I'm just looking to know if its...

I am also going to write 433. With the study guide not out from Microsoft yet, and no practice exam to try, could someone give me a hint on...

Hey all,

With a little more testing i got all of this work perfectly. I can lock the table on Target so that nothing can be inserted until the process...

I think that is how I am going to have to go about it. I think I may have been trying to find a difficult solution to a simpler...

Sorry Maxim,

I think i led you astray somewhere. I can modify existing DTS packages only, just no creation of new DTS processes.

Hey Maxim,

Linked servers are not our policy here in our 2005 framework.

Our processes are so ingrained here that adding new DTS packages would be rediculous as we are investigating how...