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,691 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
801 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,370 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,043 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,665 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,504 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,717 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,529 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,997 reads
Blogs
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Forums
Bank BCA KCU BCA KCU Jayapura telp 0817 844 112
WhatsApp CS,0817844112 Komp. Pertokoan Jayapura, Jl. Pacific Permai Jl. Dr. Sam Ratulangi No.31 Blok...
Bank BCA KCU Tanjung Pandan telp 0817 844 112
WhatsApp CS,0817844112 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten Belitung,...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers