Interesting...that's not the behavior I'm seeing. If I use the Execute Process Task the way described by...

Seems to be working fine for me?  Execute Process Task waits for the process to complete, then depending on the return code you can branch to a failure or...

I don't disagree with this comment, but... There is a precedence constraint between this task and the unzip task. Why would the Execute Process task mark "successful" and act...

• This reply was modified 3 years, 4 months ago by  Martin Schoombee.

SSIS will execute external processes in a disconnected fashion, so what is happening here is the following:

1. SSIS initiates the execution of the PowerShell script
2. SSIS comes back and says...

Yes, I would store it in the fact table as well. The general premise is to make reporting as easy as possible, and if you can persist the Sales Amount...

Firstly, great job at taking the bits and pieces from everyone and going through the paces to make sure you get to the right solution for your specific needs. I...

No shortage of opinions...eh...ideas here, so you have lots to play with 🙂

Side-Note: In order for everyone to see a mapped drive, an administrator will have to create it and...

Do you mean the following? : Copy the .csv files to the local hard drive on the SQL Server.  Then the SQL Server shouldn't have any trouble accessing the...

You should see the user context in the Catalog reports, and if that doesn't work it's most likely Kerberos delegation.

One other thing to try: In stored procedures you can force...

You can create a proxy account in SQL Server, using the credentials provided by your network folks. Use the proxy account in the SQL Agent step that executes the SSIS...

• This reply was modified 3 years, 6 months ago by  Martin Schoombee.

I agree with the comments made by Jeff and Grant. There are many variables here, and it all depends on what you are doing to the data once it's in...

• This reply was modified 3 years, 7 months ago by  Martin Schoombee.

If you change the SSRS report to create one page for each customer (with a page break in-between), you should be able to execute that report in the same way...

Blog post as promised: https://martinschoombee.com/2021/01/26/fixing-incorrect-drill-through-results-in-analysis-services-part-1/

Yes.

My understanding is that CALCULATETABLE(), because of the syntax and the fact that it allows you to provide multiple filters that will be applied in an "AND" fashion, will not...

How about this?

CALCULATETABLE
(
    'Table'
,   FILTER
    (
        'Table'
    , ...