Hi Elliot,

thanks so much for your answer.

The situation is the following:

- I have an OLE DB source.

- Then I perform some lookups and splits

- I update some records...

Hi Pablo,

thanks so much for your answer. I will use the new table option, because at the moment the fact table is only used to generate weekly and monthly reports,...

I know this is a SQL Server and Microsoft flavour Forum, but I would try at least the Pentaho Reporting tools

Hi,

I can recommend this book to understand the Big Data fundamentals: Big Data by Nathan Marz and James Warren[/url]

And then just try to make your hands dirty and download...

Thanks Frank for this article, now Big Data starts to cross the SQLSERVERCENTRAL Path!

Hi,

you can use the deployment utility: Deploy Packages by Using the Deployment Utility

or you could find other options here: Deploy SSIS Packages across servers[/url]

and here: SSIS Deployments[/url]

Hi SQLSponge,

I recently read an article that proposed one of the best solutions I've ever seen. It is a little bit complex (technically speaking) but I suggest you to read...

Hi,

Even if you have small files, but...

Hi,

Thanks so much for this article.

I recently got involved with Hadoop too. I also faced the RAM and 64-Bit CPU limitations on my laptop, so I decided to buy...

Thanks so much for your answers,

Thanks to the opc answer I could learn about SPIDs, Wait Types, Packet Size, etc.

I have already implemented the IDENTITY column (Idx) in the staging...

Hi,

can you please explain your situation a little bit more. How limited is your control over the database design? If you don't have unique ID how do you make...

Hi,

I remembered a similar experience. You need to be sure that the Integration Services Service (I know it sounds redundant) is installed and enabled in the server. This is the...

Hi Big Bro!

Thanks for your comment.

I found many good reasons for using schemas as logical containers like the ability to manipulate objects independently of users, and the reduce of administrative...

Hi all,

I have found that it is not possible to avoid the generation of dynamic SQL code if you want to parameterized a SQL Server object name (sysname). However,...

Hi Phil,

Thanks for your quick answers.

In my case the source is a OLE DB component, and the reason to do such a things is the final destination is a Dynamics...