June 23, 2010 at 10:22 am
All,
This small company keeps it's customer data in an Excel file.
The boss wants to make certain data in the spreadsheet available to applications on other machines on the LAN while keeping other data secure.
I know that Access & Excel databases can be password protected, but AFAIK if you give someone access to some data in them, they have access to all data.
If this were an SQL database, I could create an SQL view which queries the public data only, and use security settings to make the view public while keeping tighter security on the underlying tables.
So I had the idea of creating a DB on SQLExpress to make the public data available on the LAN, and use a DTS job to update the public data from the confidential Excel file each day.
But SQLExpress lacks SQLAgent. Is it possible to create a DTS import job in SQLExpress and then use Windows Task Scheduler or other tool to run it daily?
June 23, 2010 at 11:38 am
This article explains how to use a T-SQL script in conjunction with Windows Task Scheduler to automate backups of you SQL Server Express databases on a scheduled basis.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply