clucasi (2/18/2010)
Does anybody have an idea if you can use raw files to update records in a table using SQL server 2005
I have trawled the internet but with no avail. I tried to using a TSQL update statement.
I have about 5000 records to update and need it to be fast.
Can use a OLE DB Source and OLE DB Command. but it is to slow.
Can you give some more details regarding your question? Are you trying to read from RAW files as a source or do you want to use them to speed up things?
In SSIS, you can use the Raw File Source and the Raw File Destination.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP