I was just about to question your 'steroids' comment, Eirikur, when I noticed it had been edited out!

vprunic (4/26/2016)

---

Hello all,

Im not an expert so, still struggling with some issues, and was hoping I could get some help

How would I be able to rename all the members that...

Storing passwords anywhere in plain text, when there is an alternative not to, is why.

As simple as this, or more sophistication required?

IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL

DROP TABLE #test;

CREATE TABLE #test (Id INT, Value VARCHAR(20));

INSERT #test

...

What is the scope of User::SheetName?

So _xlnm#_FilterDatabase is the name of the first tab?

What is your connection string expression?

DuncEduardo (4/25/2016)

---

Hi,

Having a problem getting a package to work.

This package is supposed to load multiple sheets, from a single Excel workbook, into SQL Server 2014.

I am using Visual Studio 2012...

DuncEduardo (4/25/2016)

---

Phil, it turns out that if I run Visual Studio Pro 2012 on server "as admin" then I'm able to save and execute package (fixed minor errors).

In addition I...

Brandie Tarvin (4/25/2016)

---

Oh, here's two in German that I learned from a coworker when I was in high school.

Er/Sie hat nicht alle tasse im Shrank.

and

Du hast ein Vogel.

Roughly translated as...

DuncEduardo (4/25/2016)

---

Phil,

When I start Visual Studio 2013 Shell (Integrated), open project and I upgrade it says Upgrade Complete, albeit with several warnings and 2 errors. Main error is "invalid connection"...

Eirikur Eiriksson (4/22/2016)

---

Brandie Tarvin (4/22/2016)

---

In this case I did add my two cents because I've seen that damn failure before and it took me days to figure out what the...

If you look under All Messages, you should see something more like this:

Does the Agent History tab give you anything at all useful?

Yikes. That thread is already following a familiar pattern.

I expect two more pages of fumbling, followed by: "It's OK. This problem is resolved now."

Must. Resist.