Motorhead

Mohammed,

You posted your question on a thread that is 2 years old. I suggest that you open a new thread with your question.

terse

Give me a bit to play around with this. I'll get back to you, but it may be tomorrow.

productive

Replication is usually the best option for maintaining multiple copies of reference data accross databases. Your only other option would be to design your own replication functionality. You...

WayneS (6/25/2010)

---

Can you get the delimiter changed?

If you don't have any control over the file, then you need to be screaming really loud to who does about how they should...

Do you have any control over generating the file? If so, use text qualifiers around your text data. It should ingore any delimiter character inside of the text...

Here's a new tool for the trade (the Jedi trade, that is).....

http://www.wickedlasers.com/lasers/Spyder_III_Pro_Arctic_Series-96-37.html

Q

Just a hint, you may need to use SSIS to build out the DOS command string, stream it to a file, and then use the Execute Process task to envoke...

Yes.

Do you have an example of what I would enter...

You need to get a PGP product that has command line capabilities. Then, use an Execute Process task to envoke a command shell and run the decrypt process in...

SELECT @query

#1