2Tall (3/31/2015)

---

Hi Phil. Indeed I can have multiple variables!

I found I had to perform an additional step within the SSIS project. On the FTP Connection Manager I chose Parameterize then...

2Tall (3/31/2015)

---

Phil one last question. If individual environment variables are created for Server Name / User / Password the subsequent SQL Agent Job appears to be only able to reference...

You've been here long enough to know that you need to post DDL, consumable data and desired results to get a working solution.

See the first link in my signature for...

2Tall (3/31/2015)

---

Hi Phil. I was not prompted for the password. After importing the package into SSIDB I selected configure. I then selected 'Connection Managers'. I selected the connection manager of...

2Tall (3/30/2015)

---

Hi Phil.

Are you using the project deployment model, or the package deployment model?

You need to use the former if you want to use environments. If you are not, I...

wendy elizabeth (3/30/2015)

---

In a t-sql 2012 stored procedure, I would like to know if my solution to solve the problem is correct and/or if you have any other suggestion(s)...

MMartin1 (3/27/2015)

---

I would recommend to use the registry to store a password though the configuration manager. It's a good practice so that the text is not exposed in a file...

Yes, I am already 'looking forward' to regularly changing passwords for them all 🙂

Good to know that there is an automated way of doing that. I might get back to...

Jack Corbett (3/27/2015)

---

Since I'm old school I do prefer working in SSMS, but am working to get all our databases into SSDT Database projects to get them into...

mister.magoo (3/26/2015)

---

I don't use runas /netonly any more for that reason (and I hate typing passwords), so now I store the credentials in the Windows Credential Manager and just run...

Are you using the project deployment model, or the package deployment model?

You need to use the former if you want to use environments. If you are not, I recommend that...

Samuel Vella (3/27/2015)

---

Bulk loads are quickest for tables which are either empty or have no indexes.

If you are inserting a lot of data into an already large table then rebuilding...

Knowledge Hunter (3/27/2015)

---

Hello,

I have a package that uses Script task to refresh excel files in a shared folder.

The credential I am using to run the package has read write access...

Then it becomes very easy – use multiple Rowcount transformations to capture the counts in the DF and then write those variables out to your logging table using a subsequent...

I use both.

In a shared environment (multiple devs to one DB) I find SSMS works better than SSDT.

But if you can get to the point where you do your dev...