Automatically run some codes in SQL server 2005
My problem is that our client will ftp some daily data file to us, and we will create a program to get the ftp file, read it and store the data to our database. I know this work will be done in SQL server, can anybody give me some detail step about how to do this in SQL server 2005? what security issue we need to solve to make it work?
I am a newbie in SQL server 2005.
A lots of thanks!