What types of connectors make the most sense for SSIS packages? New author Mike Frost brings us a look at the various options along with some recommendations for different types of data as well as the 64-bit platform.
2007-08-30
9,167 reads
2007-08-22
1,480 reads
SQL Server Integration Services has changed the ETL process dramatically with many new capabilities. It's extensibility is unmatched, allowing you to build workflows that were not possible in DTS. Dinesh Priyankara brings us a useful new technique for referencing your .NET assemblies from within SSIS to take advantage of code reuse.
2007-08-21
12,711 reads
2007-08-08
1,606 reads
SSIS introduced a feature called "Package Configurations". Package configurations allow us to make SSIS packages portable and help us change SQL Server and file connectivity information dynamically.
2007-07-19
2,738 reads
SQL Server Integration Services (SSIS) includes two very interesting transforms, the Fuzzy Grouping and Fuzzy Lookup transformations. Brian Norberg discussed the former in another article and this time examines the Fuzzy Lookup Transformation.
2007-07-19
10,301 reads
SQL Server 2005 has greatly increased the capabilities of the platform and brought the capabilities for complex ETL packages to many businesses at an affordable cost. One of the very interesting transformations you can use in SSIS is the fuzzy grouping task and new author Brian Nordberg brings us a look at how you can use this.
2007-07-16
8,439 reads
2007-07-11
1,394 reads
In this series, Brian Knight shows you an actual difficult business problem to solve, gives you hints about how to solve it and then lastly shows you step-by-step instructions how to solve it if you want the help. n this video of the series, Brian demonstrate how to unpivot data that may arrive from the mainframe and load a many to many table with SSIS.
2007-06-28
2,119 reads
SQL Server Integration Services is an incredibly rich and complex development environment that can handle almost any data movement task. Even those that do not involve SQL Server. Longtime author Tim Mitchell brings us a use that has nothing to do with SQL Server, but can be very handy for many of us.
2008-05-21 (first published: 2007-06-25)
11,854 reads
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I