Solved

Crazy Question

Posted on 2014-02-27
5
192 Views
Last Modified: 2014-02-28
Hello All,

You may think I am day-dreaming or currently on something. But actually I want to know if this is at all possible? please correct me -

Can I set up a sql server DB such that it can read my outlook attachments directly by itself and store it somewhere in network - without me been logged on to my computer? so lets say if I give the SQL server my network ID and other credentials - will it do that then?

Just a crazy question with no heads or tail - I am thinking

Thank you
0
Comment
Question by:Rayne
  • 3
5 Comments
 
LVL 82

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 200 total points
Comment Utility
No.  SQL Server don't "reach out" for things.  You write programs that do that.  In addition, the program will have to login as you if you aren't logged in.  Logins and user credentials are specifically intended to block things like that.
0
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 300 total points
Comment Utility
As Dave says, not directly.

You would need to find/write a script/program that:
- connects to Outlook or your email server
- downloads attachments in a local folder
- connects to a SQL DB
- uploads attachments from the local folder to the SQL server

This would need to run on some computer/server, using credentials that allow it to connect to Outlook and SQL.

HTH,
Dan
0
 

Author Comment

by:Rayne
Comment Utility
Thank you Dan and Dave for your brillaint help and insight :)

For your four steps - I know vbscript will get me there for sure, I have done several of them before. I love vbscript so much.

For this step "using credentials that allow it to connect to Outlook and SQL" - that means lets say if there is a server/pc - all i do is login to it just once with my credentials and keep it ON always - and that does it daily?

Thank  you
0
 

Author Comment

by:Rayne
Comment Utility
For this step "uploads attachments from the local folder to the SQL server" - which one do you think makes more sense from a robust daily event perspective - doing a SSIS event or shell script or any other script?
0
 

Author Comment

by:Rayne
Comment Utility
thank you a zillion times  - this idea was a life saver, thank you

Respect
R
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now