Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 600
  • Last Modified:

Use SQL Server 2005 to Open Email, extract Excel spreadsheet, open it and Import into a Table

Hi,
I have a service that provides information to me via an encrypted Excel spreadsheet through email.
Can SSIS/BI receive the file, open it, extract the attached spreadsheet and read that spreadsheet into a database table?

I think I can do it in pieces but I am wondering if everything could be handled by SSIS/BI.

Thanks in advance
0
prgMan
Asked:
prgMan
  • 2
1 Solution
 
SQL_SERVER_DBACommented:
Im pretty sure your going to have to take in consideration the security on the xls file, is your using ssis...I would decrypt first, turn off the security then import
0
 
prgManAuthor Commented:
I just noticed that there was not an option in Import Excel for the password.  MS does talk to each other don't they?  So is there no way to import an Excel spreadsheet that is encrypted?
0
 
prgManAuthor Commented:
I was through another question able to find out how to decrypt and resave it.  
http://www.experts-exchange.com/Microsoft/Development/.NET/Visual_CSharp/Q_22899960.html

And to extract an email from Outlook
http://www.experts-exchange.com/Microsoft/Development/.NET/Visual_CSharp/Q_22899942.html

Can I do this all within SSIS/BI.  I'm not sure how to use C# within SSIS yet.  Any ideas?

Thanks!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now