Issue with schedule adapter - BizTalk server 2016 RRS feed

  • Question

  • I have installed the latest schedule adapter version in BizTalk 2016 server

    Tried to configure "SQLSTREMPROVIDER" task, since i need to get the data from SQL table once in a day. I have configured the connection string as mssql://servername//db also tried with OLD SQL adapter format Provider=; Integrated security=; persist security info=; inital catalog=; datasource=; and scheduled with timespan.

    Getting below error in event viewer:

    format of the initialization string does not conform to specification starting at index 0

    Removed the provider in connection string and received below error in event viewer:

    keyword not supported : 'provider'

    kindly provide your suggestions.


    Tuesday, January 22, 2019 9:59 AM

All replies

  • Do you really need to use the Scheduled Adapter?

    The SQL Adapter already supports a Polling Interval.

    What you can do instead is use the Service Windows on the Receive Location + the Polling Interval.

    For example, if you set the Service Windows to 12 AM - 1 PM and the SQL Adapter Polling Interval to 43200 seconds, you will poll at Midnight and Noon.

    Wednesday, January 23, 2019 6:09 PM