Tag Info

New answers tagged

0

Create an XML index on the column, you will have to create a primary index and then a secondary index on the path or value you are querying. CREATE PRIMARY XML INDEX PXML_NAME ON SCHEMA.TABLE (XMLCOLUMN); then create a secondary index for the { VALUE | PATH | PROPERTY } you are querying with Xpath https://msdn.microsoft.com/en-us/library/ms191497.aspx and ...


0

Your current setup seems to be on the right track. I would cut SSIS out of the equation - the stored procedure INSERTs into the staging table, and then a C# app pulls the data out, creates the XML files, and SFTPs the files off to the destination. I realize that's more a 'developer' solution than an 'DBA' solution, but flat files and SFTP are not things ...


0

Install power query ad-din http://www.microsoft.com/en-us/download/details.aspx?id=39379 And you still might want to install MySQL workbench to test your connection.



Top 50 recent answers are included