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...

Gary Varga (3/27/2015)

---

dwain.c (3/26/2015)

---

-- Whilst I'm a consultant named Jack

-- I swear that I'll never be back

-- Removing this code

-- Causes server overload

-- Despite you're thinking its a hack.

See what...

vipin_jha123 (3/26/2015)

---

Hi ,

I am working on SSIS package where I have to implement logging for records count.

In my package I have 20 Data Flow Task, now my requirement is to...

It's been that sort of a day here too. I'm going for a cleansing ale to...