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 |
|
Daniel_Buchholz
Starting Member
28 Posts |
 Posted - 2002-04-26 : 05:27:50
|
| Hey Folks!I´m wondering how i could import text file data into tables and while doing so perform some validation and calculation tasks. I know of BULK INSERT or bcp but I can not do anything on row level here.Does anyone know of something like SELECT ... FROM OPENROWSET(...) and some thing like a text driver? This work fine with excel files. So I can open a cursor and perform any row-level task.A workaroud would be to bulk insert into a temporary table and do things there, but....Daniel |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-04-26 : 06:19:11
|
| Daniel,Use a DTS package to do this. You can create a custom transformation using VBScript to do any sort of validation you want. As a starting point, use the Import Data Wizard which will create a DTS package for you, then you can go in and add the validations you want.The other alternative is to use an intermediate table to import the raw data into, then you can run a query to populate your destination table.Tim |
 |
|
|
|
|
|
Text import with validation