SSIS Package to import XML file in Sql server 2005 Database
Database
2
Posts
2
Posters
0
Views
1
Watching
-
-
I have to create a SSIS package which will take data from a large xml file(~10GB), and import it into sql server 2005 database. Can anyone tell me the steps which i have to follow to do this? I also have to do XSD validation and maitain Transaction.
well you could better use BCP command for large files to import into a database. See here for more details
In Word you can only store 2 bytes. That is why I use Writer.