CptCrusty1 (5/9/2012)

---

I thought about that, but wasn't sure if that would end up being visible in the report... hadn't got around to trying it yet... Guess I'll have...

Welsh Corgi (4/13/2012)

---

I removed the WHERE Clause that included the input parameter and I still get the error.

When the Task executes the parameter does not have a value.

I did not...

Welsh Corgi (4/13/2012)

---

The variables are set during runtime.

I checked the variables when...

Does your variable have a hard-coded value before execution, or is the value only assigned during execution?

+1 on all Jeff's points above. Most people in this forum would lean towards SQL Server, and for good and valid reasons as Jeff has mentioned.

To give another perspective, you...

PaulB-TheOneAndOnly (3/25/2012)

---

Surrogate Keys add a level of abstraction that isolates and protects...

SQL Padawan (3/13/2012)

---

I was wondering if there was a data management view for data source views. I can not for the life me find anything, anywhere on the web. I've...

FunkyDexter (3/7/2012)

---

OK, so I've been using SSRS and SSIS for a while and decided I ought to learn SSAS. I've spent some time going through a tutorial or two...

Ells (3/7/2012)

---

Kind of

"Any variable that is marked as sensitive. The marking of variables is controlled by Integration Services.

Whether Integration Services considers a property sensitive depends on whether the developer of...

Ells (3/6/2012)

---

Have been looking into this a bit more.

There appears to be two components to the security.

1. The ability to edit the package

2. The security of passwords

I already use config...

Ells (3/6/2012)

---

Guys,

I have normally worked by myself and when it comes to protectio level for the packages I have opted for Encrypt sensitive with User Key.

However when I open someone...

I bet you it will 😉

The only thing left to do is for you to implement, test and provide some feedback of your success.

Divine Flame (2/24/2012)

---

I am thinking of something like this:

IF OBJECT_ID('tempdb..#MyTestTable24Feb2012') IS NOT NULL

BEGIN

DROP TABLE #MyTestTable24Feb2012

END

CREATE TABLE #MyTestTable24Feb2012

(

ID INT IDENTITY(1,1),

Value VARCHAR(20)

)

GO

INSERT INTO #MyTestTable24Feb2012 VALUES ('Param1')

INSERT INTO #MyTestTable24Feb2012 VALUES ('Param2')

INSERT INTO #MyTestTable24Feb2012...

Not sure...I guess it depends on exactly what you are trying to do. How are you envisioning the use of dynamic sql...

stephen99999 (2/24/2012)

Most definitely makes sense. At least that way, we would only be generating the City data one time vs. 10 times. I could even still end up using an...