Okay, just a quick update... I got the PowerQuery working (Text.Combine in PowerQuery is my new best friend!!!) Here's the PowerQuery:

let
    Source = Folder.Files("C:\Users\User\OneDrive\Documents"),
...

Sounds like a hideous design.

Why not just put all the data in the same database with a foreign key column to the server name? Then you don't need any dynamic...

Okay. The other way I was thinking of doing it was to write a query to find changed prices each week (since he only sells cnce a week) and then...

To quote Gene Wilder in "Charlie and the Chocolate Factory", "Wait a minute, Strike that! Reverse it! Thank you."

The trick is to avoid SSIS altogether. If you have DAX Studio...

• This reply was modified 1 month ago by  pietlinden.
• This reply was modified 1 month ago by  pietlinden.

Martin,

I'm trying to work out options. Would you use something like a system-versioned table to handle the ingredient slowly changing dimension? Or can I just use a few fairly simple...

Sounds like you're missing the other table, Student.

Student(StudentID (PK),...)

StudentTest(StudentID (PK1), TestID (PK2), TestScore)

Test(TestID (PK), TestDate...)

if you allow nulls in StudentTest(Score), then you can just cross join a filtered view of...

I'm trying to simulate price changes of some of my ingredients over time. (Not really necessary to change the prices of more than just some of the most commonly used...

Thanks Steve! Like I said, I felt like I was missing something that should have been blatantly obvious! Thanks for clarifying!

So this is my plan (after staring at this for...

Why not just script out all the objects and then run all that in a separate database?

Otherwise, you could make a copy of your database and then use dynamic SQL...

Apparently Imke Feldmann wrote some code that does it... but by the looks of it, you have to configure everything just right:

Export data from Power BI using Python

"Re-search. It...

So essentially you're grouping islands together. (The island consists of consecutive months of data). Fancy that! I found an old Dwain Camps article! (I miss his posts... he could...

Pretend I'm dumb as a rock and explain how your result is correct and how you got there.

Are you talking about something like the "Islands Question" discussed by Itzik Ben-Gan...

• This reply was modified 1 month, 1 week ago by  pietlinden. Reason: clarification

Where's the data coming from?

I'm basically terrible at SSIS (but Phil's good at it, so listen to him), but you can pivot data in Excel using PowerQuery and then you...

How to remove quote marks using SSIS and a little C# – SQLServerCentral ?

Got some details? Like the parameter values you're trying to pass, the parameter definition, the stored procedure text, the related column types and sizes... you know, something so we can...