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.
| Author |
Topic |
|
demon999
Starting Member
1 Post |
 Posted - 2007-10-21 : 08:28:00
|
| Hi guys, I'm pretty new in SQL Server and trying to build up a BI Solution for my firm. We have got monthly data about revenue headcounts and so, which should be integrated into a DW. I was wondering whether there is an automated way to import this csv data in SQL like in a batch, because the users are not familiar with SQL Server at all. The structure of the data will be the same all the time, since it comes from legacy systems.YOur help would be highly appriciated:) demon |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-22 : 03:07:31
|
| You could also set it up as a DTS package , and register as a jobJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
|
|
|
Automated CSV Import