|
|
|
|
Browse by Tags
All Tags » SQL Server » SSIS (RSS)
-
Introduction
A few months back I received an email from a nice lady who was beginning to work with SSIS. She was trying to use SSIS to automate metadata collection in her enterprise and she had made a good start in the package she attached to the email. She had a few questions so I opened the package and began poking around some to answer ...
-
My latest SSIS 101 article - SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers - is live at SQL Server Central today!
Enjoy!
:{> Andy
-
According to numerous sources - most recently a SQL Server Magazine article entitled Too Soon for SQL Server 2008? Readers Say ''Yes!'' - a lot of SQL Server customers are holding off upgrading to SQL Server 2005, preferring to wait for the upcoming release of SQL Server 2008. While I understand the economics, I worry about the ...
-
Last week I had the opportunity to speak to a user group about SQL Server and in particular Integration Services. It was a nice opportunity to clear out the cob webs and talk about one of my favorite topics. https://www.clicktoattend.com/invitation.aspx?code=122496
Initially, it wasn't going so well. I've found that the audiences vary for these ...
-
You can find SSIS 2005 Custom Tasks and Component Samples at CodePlex. At the same location you can find SSIS 2008 samples. How cool is that?
The samples include source code in VB.Net and C#. They serve as a decent starting place for developing your own SSIS custom tasks and components.
Free registration to CodePlex is required to access the ...
-
I have been so used to use int identity fields as primary key for any table and to believe it’s the fastest way to define a clustered primary key that I never thought this can cause serious performance problems to SSIS. Until I tested it and discovered that int identity primary keys are among the slowest way to insert huge amount of data with ...
-
I was trying to find a way to repeatedly run the same MDX CREATE GLOBAL CUBE statement 70 times, building 70 different offline cubes for sales rep type folks to carry around for a client, and I just couldn't get it. I have some experience with SSIS, mostly from writing a tutorial on how to do RSS feeds with SSIS earlier that I am not sure ...
|
|
|
|
|