SSIS Lookup Cache Connection Manager with Excel
The lookup transform in SSIS 2008 gives you the ability to join data and eliminate non matching rows. One of...
2011-09-26
1,683 reads
Partial Cache Lookup with a Date Range
When setting up a lookup in SSIS it is usually just a basic comparison between two key fields like an...
2011-09-23
784 reads
Replacing a SQL Cursor with SSIS
On a forum post recently the questions was asked how to replace a cursor with an SSIS package. This can...
2011-09-22
1,360 reads
Handling Flat File Headers and Errors in SSIS
Using SSIS to load a flat file into a database is a common use of the tool. This works great...
2011-09-12
4,011 reads
Using the SSIS Merge Join
The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way...
2011-09-06
12,587 reads
Pragmatic Works Foundation Class Oct 2011
I am super excited to announce that there is a strong demand for the Foundation Training to be held more...
2011-09-02
550 reads
Variables and Expressions with Connections in SSIS
Variables and expressions help make any SSIS package dynamic and flexible. It is always a best practice to use variables...
2011-09-02
1,494 reads
Convert EBCDIC to ASCII in SSIS
Converting EBCDIC to ASCII in SSIS 2008 can seem like a daunting task. There is a lot of manual work...
2011-08-31
8,679 reads
SSIS For Each Loop over files with Date in Name
A common request I have received over the years is to move or copy files from one directory to another...
2011-08-29
10,395 reads
Using Checksum in SSIS for Delta Loads
The checksum function in SQL is a great way to compare two rows to see if the data matches. The...
2011-08-15
3,972 reads
Blogs
Back in the EU
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Setting up SQL Server S3 Object Storage Integration using MinIO with Docker Compose (Updated for SQL Server 2025)
Update for SQL Server 2025: This post and the GitHub repo have been updated for...
Forums
Flexible Laptop on Rent in Noida for Students & Businesses
Looking for laptops without heavy investment? Laptop on rent in Noida is ideal for...
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers