Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 is this possible and if so where do i start?

Author  Topic 

baggerus1
Starting Member

1 Post

Posted - 2012-02-17 : 11:00:57
Hi all

I've set up a web application in Visual studio that look to an sql 2008 r2 database (express edition) and the data it relies on runs nightly extracting the data from another system and saving a text file in a location say; c:/cris3/stats... I would like my sql database to look in that folder for the text file, when it sees it is there is then appends it into an existing table. This would save my clients from performing and statistic running. I'd appreciate any advice you have on completing this; i had a feeling maybe the integration services were the way to go but they dont seem to be avaialble in the express edition i have :( very new to sql please help a rookie :)

Cheers all

Thanks so much

Dave B

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-17 : 11:18:41
Does express have a sql agent and Jobs?

I do not know

But Yes, basically you can do what you are saying



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

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

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -