SQL Express 2005 1

[Hondy]

Hi

Can anyone tell me if I can do scheduled imports of data from a flat file using SQL Express 2005 or do I need a commercial grade SQL server?

Thanks

 

[mrdenny]

SQL Server 2005 Express Edition does not include Intergration Services nor a SQL Agent to do the scheduling.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

If you use BCP or the BULK INSERT T/SQL command and another scheduling app (suck as the Windows Task Scheduler) then yes you can. With SQL only, no you can't.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Hondy]

Thanks MrDenny!

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com