Wow. I appreciate the help.

You are all awesome. 🙂

ok a lot to ask but do you have a simple example?

GilaMonster (7/15/2014)

---

That's the exact article I would have given you as an example. See the other examples that it links to.

Bear in mind this isn't something you implement without a...

GilaMonster (7/15/2014)

---

No. T-SQL, with the T-SQL encryption functions like EncrypByKey and DecryptByKey, or whichever of the similar functions you identify as meeting your requirements for protection, key management and all...

GilaMonster (7/15/2014)

---

There's nothing about the column which makes it encrypted. You would need to encrypt the values when you insert (eg with EncryptByKey) and decrypt the values when you select...

GilaMonster (7/15/2014)

---

TDE is entire database encryption. Transparent encryption, data encrypted on disk, decrypted in memory. It protects against the theft of the data files or the backups. It doesn't protect...

I have this example.

http://msdn.microsoft.com/en-us/library/ms179331.aspx

I can't have the SSN in the table.

I just want to encrypt an SSN in a simple manner.

Thank you for your responses.

Thanks for the link.:-)

I was hoping to get a simple example to encrypt an SSN.

Thank you.

Maninder Kumar (7/11/2014)

---

Hi Welsh,

Do you use Foreach loop container to traverse through these file(s)? I had faced similar situation, where I stored the Fully Qualified file name of file in...

I changed the default on the script. I'm not sure how that changed. Thanks.

I want:

ANDPromo.[Group] IN ('FL_Small','FL_Large')

Not:

ANDPromo.[Group] IN (''FL_Small'',''FL_Large'')

The later throws a syntax error. I have not changed anything.

Thanks.

Actually the name of the file should be dynamic in the OLE DB Excel Connection and that name to subsequently be used with the Send Mail Task as an attachment.

The number for the month is ok but I need to to list the prior month.

Sean Pearce (6/29/2014)

---

Welsh Corgi (6/28/2014)

---

Sean Pearce (5/21/2014)

---

Welsh Corgi (5/20/2014)

---

You are right you can't set the Identity Property to true.

You can set the identity property to false by simply going into...

Sean Pearce (5/21/2014)

---

Welsh Corgi (5/20/2014)

---

You are right you can't set the Identity Property to true.

You can set the identity property to false by simply going into design mode and set...