Thanks for your tips. I am going to see if I can get something working with SSIS tomorrow or Friday.

Jeff and Jeff -

Currently, all the detail data is in one table that gets refreshed each month. I'm not terribly good with SSIS. I am just now figuring out how...

• This reply was modified 3 years, 10 months ago by  usererror. Reason: Clarity

If I am understanding your question correctly:

The main export data output is 85 columns. They must be delimited by the bar character per the recipient's requirements.  The end result should...

• This reply was modified 3 years, 10 months ago by  usererror. Reason: Visual Clean up

Thank you, I didn't see your post until just now, but I removed the SSL option and tested then with Ports 25 and 587 to send mail and that worked....

This request also sounds odd to me. I'm also a newbie and I don't even know what to ask online until I encounter something new I can't figure out. Odd...

Well, I'm not quite there yet with SSIS to make changes to data as it imports. I'm at the point where I have the "basic" SSIS packages saved from the...

Thanks, I'm now starting to venture into areas where my beginner's knowledge is reaching its limits!

1. I have a long way to go because I only understand the implications of some of these code posts.
2. I wonder if any of my code would be...

This read made my day. Love the comment about troubleshooting printers!

Are you trying to copy query results from the SSMS Results Grid and then paste them into an excel workbook? Are you wanting the pasted results to retain the hyperlink...

I gather from your post that you would prefer to just connect with SSMS directly to your SQL Server(s). No jumping to another box via RDP as a 'middle ground'....