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,600 reads
The lookup transform in SSIS 2008 gives you the ability to join data and eliminate non matching rows. One of...
2011-09-26
1,600 reads
When setting up a lookup in SSIS it is usually just a basic comparison between two key fields like an...
2011-09-23
776 reads
On a forum post recently the questions was asked how to replace a cursor with an SSIS package. This can...
2011-09-22
1,345 reads
Using SSIS to load a flat file into a database is a common use of the tool. This works great...
2011-09-12
3,396 reads
The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way...
2011-09-06
12,225 reads
I am super excited to announce that there is a strong demand for the Foundation Training to be held more...
2011-09-02
545 reads
Variables and expressions help make any SSIS package dynamic and flexible. It is always a best practice to use variables...
2011-09-02
1,473 reads
Converting EBCDIC to ASCII in SSIS 2008 can seem like a daunting task. There is a lot of manual work...
2011-08-31
8,363 reads
A common request I have received over the years is to move or copy files from one directory to another...
2011-08-29
9,311 reads
The checksum function in SQL is a great way to compare two rows to see if the data matches. The...
2011-08-15
3,525 reads
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
By Steve Jones
The grade for January is a D. Details below, but just not making a...
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
I'm in the process of converting some scripts we use to restore SQL Server...
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...