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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-11 : 08:36:28
|
| Anurag writes "Previously, We are exporting data from two tables(one master table & other sibling table) using SQL DMO Object in VB, it will make files in some encrypted format. But now we are exporting files using our own function which will make files in simple english but appending " character at the beginning of each line.We have done this because DMO object imports all the data whethere it is correct or not.While my function deletes all unwanted data. Problem is:- if we have older files which are exported using DMO object then how to import data from those files?In my function, before starting importing i check that whether first character in file is " or not. if it is then simple importing is done using my function otherwise first importing is done using DMO object then exporting is done using my function & then importing is done using my function.This works ok but if the file size is too large then it will take long time.Is there any other way to do this?Let me know." |
|
|
|
|
|
Problem while importing file