Got it right by selecting one of the two correct options. I wonder if if the other option also leads to success.

Thanks for the question.

I don't think it uses TDE, as TDE would encrypt everything in the database, while the SSIS catalog only encrypts sensitive data and parameters using a database master key.

It might. Depends on the queries and how often they are executed.

They do not block each other, but they compete for the same resources of course (mainly IO I guess).

Any filters in the data source view?

jonidotcodotuk (8/7/2014)

---

Jeff Moden (8/6/2014)

---

Ed Wagner (8/6/2014)

---

How about a very simple one?

Please write the T-SQL code to count from 1 to 10.

There are many correct answers and how they answer can...

twin.devil (8/7/2014)

---

...

Create a Derive Column data flow, place all the logic in the expression by doing so you will get the updated column you wanted, just use that column in...

Maybe just for enlarging the row count for performance testing?

happycat59 (8/6/2014)

---

ericjlawson (8/6/2014)

---

Hi,

We have a LKP table that we will use to decode incoming codes from multiple sales feeds to link to the relevant surrogate key for the ultimate dimension...

You really should do some research on how to work with CTEs.

Into what object do you want to insert the rows?

Junglee_George (8/6/2014)

---

Also, have a sql code like a temp table creation and insertion inside the Stored proc, please guide me how this can be achieved using CTE or by any...

ronan.healy (8/6/2014)

---

ya was getting errors and I used a datagrid view to look at the data but this fixed my problem

ISNULL([Fixed Rate]) || [Fixed Rate] == "" ? "0.00" :...

Any errors when running the package?

How do you verify if the NULL values have been replaced?

What data type is Fixed Rate?