ilimax

Does anybody have idea how I can export data from SQL Sever to text file. I want to make new text file every time I export data.
Also I need reverse; import data from text file to SQL server.



Thanks,

Ilimax

KnooKie

have a look at SQL Server's Data Transformation Services. Ideally you'll need SQL2000 to use this effectively i think. It existed in SQL7 but was rather primitive in comparison to what exists in SQL Server 2000.

You could also try this dedicated SQL Server newsgroup site...

www.sqlteam.com

ilimax

Quote:

---

Originally Posted by KnooKie
have a look at SQL Server's Data Transformation Services. Ideally you'll need SQL2000 to use this effectively i think. It existed in SQL7 but was rather primitive in comparison to what exists in SQL Server 2000.

You could also try this dedicated SQL Server newsgroup site...

www.sqlteam.com

---

Thanks guy. I am going to review this web page!