I have a SQL table that contains a column of type XML. This column stores data in XML format that represent a row that needs to be uploaded to another server. I need to have Integration Services read from this table and process each row. Since row contains 1 XML column which will contain X amount of "rows". Each row needs to be processed individually.
So... read table which has X amount of rows. For each row read XML in column and loop through each Node which represents a given row. Process/Insert the data within the XML (as parameters for another stored procedure).
I am hitting a wall here. XML Source requires a variable or physcial file. I am not sure how to do this with data from a SQL table of type XML. Any ideas/help?
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.