Not sure if I'm misunderstanding your terminology, but staging tables should be a copy of the source from which they come (ie. no transformations).
Once you have all of your new data...

If you need to pass multiple values in a parameter, look at using a table valued parameter.
If you pass a parameter as you have done, SQL still sees it...

Have a look at step 7 of the article: http://www.sqlservercentral.com/articles/R+Services/157272/
You'll have to upgrade each library from the R command line.
The trick is to check exactly...

What does your query look like so far? ie. what have you tried?

You can check out this link:
http://www.sqlteam.com/article/introduction-to-dynamic-sql-part-1

I do not agree with this design as I don't think table names should be time based.
Instead there should be an additional column in the table that contains the...

Thanks Misha
Like I mentioned in the article, my code is probably not the most elegant 🙂
The reason I'm using it is because I can't add to a null...

@amartinez
It's never too late to go back and rework existing processes 🙂

Thanks Jowee
I think you might be trying to execute "TestPackage" by itself.
Make sure you set "ParallelFileProcessor" as the startup object for the solution.
It will pass the FileList...

Hi Mohammad
Here's a zip of the solution.
The package that you call is in the same solution as the package containing the script task with all the code as...

Hi Stan
It would depend on how many threads can run on the processors your server has, but you'd need to test it out on your individual environment.
The purpose...

I'd recommend PowerBI as well, as it is very affordable.
If you're familiar with SSRS already, then working with PowerBI will be a walk in the park.
There are tons...

How many unique dimensions are you connecting to?
Also, how large are these dimensions?

Not sure if it would speed things up in your case but, if your dimensions...