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,690 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
798 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,365 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,039 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,650 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
554 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,500 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,713 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,516 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,990 reads
Blogs
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
BCA KCU GAJAH MADA No.Telpon 087781685647
Whatsapp 087781685647 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers