SQL 2000 & txt files

[JonyBravo]

Hi.

I’m new on SQL 2000 and I need some help for this project at work. I’m building a database where the data that need to be inputted in come in a text file. Is any way (like a batch file or linking the database with a text file) to input the data strait away? Some files are over 100 MG size, so as can you imagine is not possible to input it manually.
I hope you understand my doubts.

Thanks to your help

 

[SQL_Hell]

Hi there,

What you need is a DTS package to load the data into a sql server table, you can do this easily by right clicking on the database (in enterprise manager), select all tasks then select import data. This will bring up a wizard for creating a dts package, select text file as your data source, browse to the file and the rest is pretty much self explanatry.

Let me know how you get on

 

[JonyBravo]

Thank you SQL_Hell to your quick reply. Thas was great.
By your explanation I take that is very similar the way is done on access. Is this right?

 

[SQL_Hell]

Yeah its pretty similar to access, although it's far superior. You can do lot with DTS packages.

Here is a good site with some examples http://www.sqldts.com/

 

[JonyBravo]

One last question. Where can I find a good SQL 2000 tutorial?

 

[tehNellie]

I can recommend "SQL Server 2000" by Sybex if you're after a printed book

http://www.sqlservercentral.com has some excellent articles and tutorials

 

[SQL_Hell]

http://www.amazon.com/Microsoft-Access-Developers-Guide-Server/dp/0672319446

This is a good book apparently