hi All,
Actually i have a project on data minning...n i have to convert the databases into text files so that they can be consolidate ....n when consolidation of the databases(in the form of text files) would be done i have to convert the consolidated one (text file) into database again.
so anyone plz tell me dat how to convert a database (using sql server & C#) into text file...
regards,
Hello.
This is what Sql Server Integration Services was made for. Any reason why you want to create the text-files?
You have many other options.
It looks to me that what you can do with an INSERT queries using linked servers. Have a look at sp_addlinkedserver in TSQL. You might get help from reading http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html (ignore step 1 and 3)
Hope this helps.
No comments:
Post a Comment