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 |
|
dizzyjay
Starting Member
1 Post |
 Posted - 2004-06-02 : 10:19:34
|
I'm new to SQL Server and need some guidance. I have a link to a web page that contains data (space delimited). What I'm looking for is a way to get this data (the link is static), parse it, and input it in a table (SQL Server) replacing existing data. My guess is that this needs to be a script run as a preliminary step in the DTS package. Any help is greatly appreciated |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-02 : 12:47:32
|
| You can use bcp.exe for this or even BULK INSERT. You can try out the import/export wizard to get started with DTS by right clicking on your database, going to all tasks, then import wizard. Just follow the screens. Then you can save the package and later view in DTS designer. But bcp.exe or BULK INSERT are going to be faster than DTS.Tara |
 |
|
|
|
|
|
html to SQL table