locked
Does anyone have experience of using securetrading.net as a data source within SSIS RRS feed

  • Pergunta

  • Hi,

    Does anyone have experience of using securetrading.net as a data source within SSIS ? If so I would greatly appreciate your help.

    Kind Regards, 

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    sexta-feira, 7 de agosto de 2020 11:35

Todas as Respostas

  • Hi Kieran,

    I guess it is better to ask securetrading.net what APIs they have to connect to them.

    SSIS has Script Task and Script Component. They should allow to create a custom code and connect to pretty much anything.

    sexta-feira, 7 de agosto de 2020 16:33
  • I've consumed data from various remote data portals into SSIS. Typically the datasources come in two varieties, REST or SOAP webservices. I've always done this using an SSIS script task. This allows you to use the full .Net stack to access the data. SSIS has a Web Services task that uses the SOAP protocol, but I've found that this component is basically useless, except for the most basic operations.



    If my reply solves your issue, please mark it as the answer

    sexta-feira, 7 de agosto de 2020 17:19
  • Hi Kieran,

    Could you please share the detailed link where the data source is?

    May I know if you can download the data in securetrading.net to excel or text file?

    Best Regards,


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    segunda-feira, 10 de agosto de 2020 09:56
  • Hi Kieran,

    May I know if you have anything to update?

    Best Regards,

    Mona


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    sexta-feira, 14 de agosto de 2020 08:15