I am lookinh for an example of how to use XML Bulk Load to load data to a sql table. I have a url access that returns mutiple rows of data that I wish to load to a table. when I access the url I get this back in a browser window:
<?xml version="1.0" ?>
- <zip-three-coverage...
Ned some ideas, when ever I try to use the built in wizard to move/copy a database from one sql server to another it fails with a general error message:
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error
Step Error code: 80004005...
I am afraid I know the answer but just in case here is my dilemma:
I have a lot of network storage but I also have a sql server that has a 60bg drive holding a 40gb database. So far I can find no way to back up this db except by doing a file copy. I really need to backup this data along with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.