|
|
-
|
|
In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does not support BI. Meaning, VS 2012 does not support SSAS, SSIS, or SSRS. If you try to open one of those projects, you will be greeted with:
At least th...
|
|
-
|
|
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio, and now supports SQL Server 2012 (including tabular mode) and Visual Studio 2010 (SSDT). Version ...
|
|
-
|
|
In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what events you were going to log, which containers you were going to collect logs for, and where you were going to store those logs.
In SSIS for SQL Server 2012 that all goes away. ......
|
|
-
|
|
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in memory. The benefit of this in-memory processing is that you do not need to physically copy and stage data at each step of the data integration. Rather, the data flow ......
|
|
-
|
|
Parallel execution in SSIS improves performance on computers that have multiple physical or logical processors. To support parallel execution of different tasks in a package, SSIS uses two properties: MaxConcurrentExecutables and EngineThreads. If you are like me, you probably did not even know ab......
|
|
-
|
|
If you have been creating SSIS packages in Business Intelligence Development Studio (BIDS) for any length of time, you have likely noticed that SSIS packages run slower in BIDS as opposed to running them in a SQL Server agent job (which uses the command prompt utility DTEXEC) or when in integration ......
|
|
-
|
|
This is my biggest gripe with SSIS: I have a data flow task, and within that I’m pulling data from multiple sources into multiple destinations, with a few performing data flow transformations. While testing, I want to disable some of the components. You can’t. You can disable any task......
|
|
-
|
|
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am writing a blog about it, will be able to solve it in no time (a big benefit of blogging is to never have to try to remember a solution to a problem you have had before…just search your blog!):
In Visua......
|
|
-
|
|
When doing ETL, you have the choice of using T-SQL or SSIS. What things should you consider when deciding which one to use? Here are some of the major design considerations to think about. These points were derived from Tim Mitchell’s (site) presentation:
Performance - With T-SQL, everyt......
|
|
-
|
|
If you are using a SSIS lookup transformation editor to determine whether to update/delete/insert records and the reference dataset is large (millions of rows) and you are using “Full cache” on the lookup transformation (the default), you might run into a problem. With this setting the ......
|
|