Post reply

XML SSIS Variables

  • September 17, 2015 at 7:24 am

    #300502

    I have a process which connects to a SQL server remotely, runs some code, creates a temporary table with an output.

    I want to be able to select the results of this table into XML (not a problem), put the results into a variable in SSIS, and put the variable results into a SQL table a different SQL Instance.

    Doing it this way removes the footprint of needing a normal table on the source SQL Server.

    Is this possible? if so does anybody have any advice?

  • September 17, 2015 at 8:35 am

    #1827439

    Hi

    If you store results in XML document, you can use it as a source in the Data Flow Task.

    So, it is not necessary to declare the variable in any way.

    Br.

    Mike

  • September 17, 2015 at 8:52 am

    #1827448

    Thanks for the reply.

    I want to avoid having to have any external elements to the process.

    This SSIS Package will be connecting to 30+ SQL instances and it would require temporary external XML documents per instance so if I can do this all within SSIS it would be the best approach.

    Variable would be my preference if possible.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply