Why not use SSIS to stage the data from the source server to the destination server? Create a staging database (I prefer those but you can use schema in...

Please don't create multiple posts for the same problem.

Answer here

I'm running Excel 2013.

When I go to Print I see a lot of settings. The bottom one is Scaling. There's various options of 'fit on one page'.

Grumpy DBA (2/24/2016)

jasona.work (2/24/2016)

/Me leans back, grabs bucket of popcorn

Sure sounds like Gail answered the original question, yet for some reason the OP decided to focus on the comments about...

Security.

Go into the package properties and look for the Security section. The default is 'EncryptSensitiveWithUserKey' which lets YOU connect nicely. If you want to retain SQL account connections...

I have to ask - what's in the stored procedures that you want/need to encrypt them?

I'm all for parameter tables. So that's a piece of my potential solution.

Read the parameter into a variable and then used a Derived Column transformation to get the value...

A bank I used to use limited passwords to 8 characters. Yes. You couldn't have a password longer than 8 characters on your online bank account. I wonder who...

The workaround (such as it is) is to create SSRS reports out of the catalog reports.

Currently there's no way to grant access just to view the reports.

I agree that it's...

There's 2 deployment models starting with version 2012.

Package - Every package is a separate entity

Project - The entire project is deployed to the SSIS Catalog

They both have advantages and disadvantages....

Define 'set up' and 'best practices'.

If you're saying that your company is going to start using SSIS and would like to know if there's any kind of guidance on how...

Does this strike anyone else as a homework/interview question?

So data 'could be used maliciously'. That's been true as long as data has been accessible in any form.

Public records are important. I have issues with states putting...

Yup! That did it for not having to code the ADO Object.

My test data is 12,460 characters. I don't see using the whole 2mil but I'm not complaining...

I still got truncation using the output to NVARCHAR. I'm surprised that your testing didn't show the same thing unless you didn't butt up against the limit.

Since I have...