SSIS only has one execute task that  calls the web service.  I run today, there are 2000 routes to process, it runs about 8 hours on dev, and 10...

How many total service calls is it making?  And how long does each one take?

All the steps in ETL runs pretty quick except this only task called execute process task which calls a web application .exe which is a wrapper that actually called...

Well unless it's the most basic of installs there's going to be a lot more set up than just clicking next next next in the install and then forgetting about...

When you reply uncheck "Notify me of follow-up replies via email" 🙂

Annoyingly...

You mean like virtually everyone on StackOverflow...

They're also a good way...

Well what if your app or API starts to be used in the US or somewhere...

They're also a good way to show you...

Well the extremely lazy way, since your query is kind of a mess of sub queries, is just to do the conversion back to datetime in the order by.

So ORDER...

Well for starters, your VBA request seems to be a post with a JSON request body so you would need to update your SQL Request to do the same which...

• This reply was modified 4 years, 1 month ago by ZZartin.

Do you have any data?

It doesn't even matter what format - you can define a fixed width file, ragged-right, CSV, TSV, XML, JSON or any other file format and if the data isn't...

• This reply was modified 4 years, 2 months ago by ZZartin.

You might be able to use OPENQUERY instead and force the date into a format Oracle likes, So something like

DELETE FROM OPENQUERY([REMOTESERVER.COMPANY.COM:1234], 'SELECT * FROM [DW_STG_OWNER].[FACT_BOOKING_INCR_STG] WHERE INCREMENTAL_RUNTIME = TO_DATE('2021-07-26...

We had originally gone back to our 1 day WFH 4 days in office schedule but I suspect some people were milking the situation and we've been 5 days in...