http://www.windowsitpro.com/authors/author/author/5777786/rss/5777786en-USSun, 27 May 2012 07:44:31 GMTSun, 27 May 2012 07:44:31 GMThttp://www.windowsitpro.com/article/sql-server-integration-services-ssis/keep-your-packages-in-the-darkMicrosoft guru Kirk Haselden gives tips for a general approach you can use to build SSIS packages that automatically adjust to their environment. When you keep packages in the dark about their environment, you can take them anywhere.]]>Kirk HaseldenTue, 18 Oct 2005 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-integration-services-ssis/keep-your-packages-in-the-darkhttp://www.windowsitpro.com/article/sql-server-2005/7-package-configuration-tidbitsHere are seven things everyone should understand about package configurations.]]>Kirk HaseldenTue, 18 Oct 2005 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/7-package-configuration-tidbitshttp://www.windowsitpro.com/article/sql-server-2005/5-things-to-know-about-property-expressionsHere are five things everyone should know about property expressions.]]>Kirk HaseldenTue, 18 Oct 2005 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/5-things-to-know-about-property-expressionshttp://www.windowsitpro.com/article/encryption2/security-in-ssisSQL Server 2005 Integration Services (SSIS) still includes familiar security functions such as password encryption, but the approach has changed dramatically. Take a look at the new security features and learn how and when to use them.]]>Kirk HaseldenTue, 19 Jul 2005 00:00:00 GMThttp://www.windowsitpro.com/article/encryption2/security-in-ssishttp://www.windowsitpro.com/article/encryption2/ssis-package-protection-levels-SSIS features six security levels for protecting packages. Here are their descriptions.]]>Kirk HaseldenTue, 19 Jul 2005 00:00:00 GMThttp://www.windowsitpro.com/article/encryption2/ssis-package-protection-levels-http://www.windowsitpro.com/article/data-access/editing-a-package-with-sql-server-2005-integration-services-designerSQL Server 2005 Integration Services has new features that simplify package creation and editing. Walk through the package-modification process and see how you can effectively create new packages without reinventing the wheel.]]>Kirk HaseldenTue, 15 Feb 2005 00:00:00 GMThttp://www.windowsitpro.com/article/data-access/editing-a-package-with-sql-server-2005-integration-services-designerhttp://www.windowsitpro.com/article/data-access/making-package-magicMicrosoft has completely rewritten SQL Server 2005 DTS, making the DTS Import/Export Wizard an even more effective tool for quickly building packages for moving data. Follow along with this example to learn about the wizard’s new features.]]>Kirk HaseldenTue, 21 Sep 2004 00:00:00 GMThttp://www.windowsitpro.com/article/data-access/making-package-magichttp://www.windowsitpro.com/article/net-framework2/what-s-new-in-dts-Microsoft has rewritten every aspect of Data Transformation Services (DTS) in SQL Server 2005, making it a true extraction, transformation, and loading (ETL) platform and improving performance. Take a whirlwind tour of some of the most important changes.]]>Kirk HaseldenTue, 20 Apr 2004 00:00:00 GMThttp://www.windowsitpro.com/article/net-framework2/what-s-new-in-dts-