Yes, typically you would have the account type as an attribute in the Account dimension.

The main consideration would be if other fact tables need to be associated with the account...

Good to know, thank you 🙂

YESYESYESYESYES... Second Execute Process task working as well!!!!

I had the wrong freakin' switch!

I hate it when I spend so much time trying to troubleshoot something and it turns out...

I still think you would be much better off using a script task - where you can embed the code or import the code - or just add the...

Yeah...I would try unrestricted for the local machine (not user) too, if that's an option.

The only other thing I can try to think of here is to run Visual Studio as admin. Even with your local admin permissions, the VS process may not have...

Hmmm...your PS script might not even be initiated at all.

What is your local PS execution policy, and is the account you're using a local administrator?

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 4 years, 2 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...