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
Mike Davis SQL
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
776 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,345 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
3,372 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,194 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
545 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,473 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,346 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
9,288 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,504 reads
Blogs
Hyperconverged storage tuning tip for SQL Server
By kleegeek
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...
Daily Coping 25 Nov 2022
By Steve Jones
Today’s coping tip is to connect with someone from a different generation. This tip...
Snowflake Classic UI vs Snowsight
By Arun Sirpal
This blog post is not about which User Interface is better, Classic or Snowsight...
Forums
Can someone explain where non - clustered index is stored?
I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...
Null value when checking unused indexes
I'm using this query to check if I have any unused indexes.. One of...
Retrieve Password from CyberArk using powershell
Hi, I am new to Powershell script and i have to create a power...
Ask SSC