Encryption in SSIS Package

Hello,

I want to import data from a excel source to SQL Server 2005 using SSIS. Among all the calls columns to be imported, there is 1 column which needs to be encrypted using asymmetric encryption and stored in destination table. Can anybody guide me how to program SSIS package using encryption function.

JatinShah wrote:

Hello,

I want to import data from a excel source to SQL Server 2005 using SSIS. Among all the calls columns to be imported, there is 1 column which needs to be encrypted using asymmetric encryption and stored in destination table. Can anybody guide me how to program SSIS package using encryption function.

I think Donald Farmer's book contains some information on how to do this. You'll be able to find it at all the usual places.

-Jamie

|||

You would need to use the Script Component, so you can use VB.Net to do the work.

Have you found out how to write the encryption functions in VB.Net, if not try this-

Walkthrough: Encrypting and Decrypting Strings in Visual Basic
(http://msdn2.microsoft.com/en-us/library/ms172831.aspx)

Then just wrap that into a Script Component.

|||

Hello Jamie,

Could you please get me the name of the book.

Thank You

Jatin Shah

|||

JatinShah wrote:

Hello Jamie,

Could you please get me the name of the book.

Thank You

Jatin Shah

http://amazon.com/s/ref=nb_ss_gw/102-7891523-4086513?url=search-alias%3Daps&field-keywords=donald+farmer

Encryption in SSIS Package

Hello,

I want to import data from a excel source to SQL Server 2005 using SSIS. Among all the calls columns to be imported, there is 1 column which needs to be encrypted using asymmetric encryption and stored in destination table. Can anybody guide me how to program SSIS package using encryption function.

JatinShah wrote:

Hello,

I want to import data from a excel source to SQL Server 2005 using SSIS. Among all the calls columns to be imported, there is 1 column which needs to be encrypted using asymmetric encryption and stored in destination table. Can anybody guide me how to program SSIS package using encryption function.

I think Donald Farmer's book contains some information on how to do this. You'll be able to find it at all the usual places.

-Jamie

|||

You would need to use the Script Component, so you can use VB.Net to do the work.

Have you found out how to write the encryption functions in VB.Net, if not try this-

Walkthrough: Encrypting and Decrypting Strings in Visual Basic
(http://msdn2.microsoft.com/en-us/library/ms172831.aspx)

Then just wrap that into a Script Component.

|||

Hello Jamie,

Could you please get me the name of the book.

Thank You

Jatin Shah

|||

JatinShah wrote:

Hello Jamie,

Could you please get me the name of the book.

Thank You

Jatin Shah

http://amazon.com/s/ref=nb_ss_gw/102-7891523-4086513?url=search-alias%3Daps&field-keywords=donald+farmer

Encrypt Report Attachments (through Subscriptions) -- possible?

We currently email out reports as either PDF or Excel attachments using Data Driven subscriptions in SSRS 2005. I've been asked to be able to encrypt the attachments and am wondering if anyone has done this or can point me in the right direction.

There's been a couple of mentions about "encrypted email" -- but I don't know where to find further information. Is this possible using SSRS subscriptions?

Thanks in advance,

- Jesse Wolgamott

Currenlty, the way to do this is to write a custom delivery extension. The one provided with reporting servcies does not support encrypting the report.

-Lukasz

|||Thanks!

For people who are reading this later on, more information about custom delivery extensions is here: http://msdn2.microsoft.com/en-us/library/ms154050.aspx

Encrypt Report Attachments (through Subscriptions) -- possible?

We currently email out reports as either PDF or Excel attachments using Data Driven subscriptions in SSRS 2005. I've been asked to be able to encrypt the attachments and am wondering if anyone has done this or can point me in the right direction.

There's been a couple of mentions about "encrypted email" -- but I don't know where to find further information. Is this possible using SSRS subscriptions?

Thanks in advance,

- Jesse Wolgamott

Currenlty, the way to do this is to write a custom delivery extension. The one provided with reporting servcies does not support encrypting the report.

-Lukasz

|||Thanks!

For people who are reading this later on, more information about custom delivery extensions is here: http://msdn2.microsoft.com/en-us/library/ms154050.aspx

Encrypt Report Attachments (through Subscriptions) -- possible?

We currently email out reports as either PDF or Excel attachments using Data Driven subscriptions in SSRS 2005. I've been asked to be able to encrypt the attachments and am wondering if anyone has done this or can point me in the right direction.

There's been a couple of mentions about "encrypted email" -- but I don't know where to find further information. Is this possible using SSRS subscriptions?

Thanks in advance,

- Jesse Wolgamott

Currenlty, the way to do this is to write a custom delivery extension. The one provided with reporting servcies does not support encrypting the report.

-Lukasz

|||Thanks!

For people who are reading this later on, more information about custom delivery extensions is here: http://msdn2.microsoft.com/en-us/library/ms154050.aspx

Enabling Drill thru in Excel Pivot Table

Am I mistaken, or are we not able to share details contained in the fact table with our excel pivot table users?

I have enabled drill through in Analysis Services and it works terrifically from that console...how can I deliver the same detail content to my pivot table users? If not in a pivot table, what is recommended that can easily be integrated with the pivot tables?No you cannot drillthrough from a pivot table but microsoft was nice enough to give you code to enable a drillthrough. (Although I havn't tested it on fist glance I personally would modigy some of it).

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlextendolap.asp|||You're assuming I'm capable. Despite my inadequacy, I will see what I can manage.|||PS - Thanks for the heads-up. It's appreciated.|||Ok, after I tested it I decided against it.
It only works with office XP and an addin.
A link to the AddIn in found on the same page i gave you.
I you have office XP and this works, let me know.
Although this is a pathetic reason to upgrade a office of 300 people to office XP.
Sorry for Bitchin just letting off some steam.

Empty rows in excel data sheet used in DTS

Hi Everyone,

I am using a DTS package where one of the inputs is an Excel Sheet. Actually this sheet is updated manually whenever required i.e once a week or sometimes once a month, but the DTS package runs everyday.

Whenever new rows are added or deleted manually in the excel sheet, empty rows are showed in the sheet after the last row of data. This hinders the DTS package, because the destination table to which the data in the Excel sheet is sent has Primary keys in it.

Can anyone suggest me how to avoid getting the empty spaces in the excel sheet.

Thanks in advance.

Regards,
kalyanExcel has a funny habit of recognising that there is data present when there really isn't. The easiest solution is when deleting records don't just press the delete key, actually right click the mouse and choose delete from the available options. It may even be better to run some macro inside the document that deletes all records below the last record in this manner.|||Hi SJP,

Thanks for the prompt reply. I think to run a macro to delete all records below the last record would be the most feasible solution.

Thanks again.

Regards,
kalyan|||The simple solution I applied was to delete all the named ranges in the Excel worksheet (From the Excel menu: Insert > Name > Define. It seems that after rows are deleted in the Excel sheet, the named ranges do not get updated. After deleting the named ranges, it was easy to Import the data.