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

It's a really cool way of managing config settings in SSIS 2012+. Including sensitive data, like...

Drenlin (3/26/2015)

---

Phil Parkin (3/26/2015)That's exactly what the compatibility level is for, though it does come with downsides: all of the new features in 2014 are turned off for the databases...

Have a read through of this[/url] Stairway article and see whether you can begin to get to grips with the use of SSISDB environments, then feel free to post back.