Hi all,

I'm on my way to creating a new pipeline on our Azure stack that is supposed to read Excel sheets located at Google Drive partitions.

We're using Data...

You said that the SSIS packages are all "very simple" and your followup after that seems like everything "works fine, fails safe, and drains to the bilge", to put it...

I have to ask... why do you...

Nothing like a bit of PPTS.  Can't help but watching.

Heh......

Ditto that and love your post.  Thanks for taking the...

@rajemessage 14195 ,

Enquiring minds want to know... did the non-XML method work for you?😋

Does anyone realize that if the docs are stored on the file system as opposed to a blob in a table, the need to scan them is then part...

Heh... I remember my Grandmother telling me when I was quite young, "Figures can lie... and liars figure". She was so right even back in the late 50's when she...

At least read the latest posts. 🙁  Kaj wrote a solution for you and I tweaked...

You've just gotta love people that give a super low rating to an article or QoTD without leaving a reason.  🙁  I thought this was a great question because of...

The rounding up of the last 30 seconds to the next hour is not a problem.

...

And as for space, if we have 100GB of data, then we have a...

Then you really, really need to make sure that security is as air-tight as it is in production and management needs to...

@Brandie...

The code at the following link, written by Jonathan Kehayias, has been a huge help on occasion.

https://www.sqlskills.com/blogs/jonathan/identifying-high-compile-time-statements-from-the-plan-cache/

As one example, one of the screens in an app that our folks wrote...

For any data you had to delete, anything with personally identifiable information, there are a couple of tools that can generate data for you to use in testing and...