Azure SSIS Feature pack can be used to upload the data over to Azure Storage account. In this article, Supriya Pande will describe how you can upload the data to Azure Blob Storage using SSIS task.
2018-09-24
6,101 reads
This white paper illustrates how Microsoft SQL Server Integration Services (SSIS) can be used in conjunction with commodity hardware or virtual machines running in Microsoft Azure to build elastic, highly available, and highly scalable ETL solutions.
2018-06-27
2,592 reads
2018-06-21
802 reads
An efficient and reliable method for reading CSV files with variable columns.
2018-06-12
28,754 reads
I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.
2018-05-17
3,239 reads
A tip to auto detect data types for flat file sources in SSIS. Never manually enter them ever again!
2018-05-14
11,680 reads
This article shows how DefaultBufferMaxRows and DefaultBufferSize properties can be used to improve dataflow task performance.
2018-03-22
37,132 reads
In this article, we discuss how schema swapping method can be used to keep tables online during the load process.
2019-08-02 (first published: 2017-12-05)
7,643 reads
Run multiple instances of your package in parallel so that each instance processes a portion of the total number of files
2019-08-23 (first published: 2017-11-07)
8,115 reads
It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.
2019-06-07 (first published: 2017-10-30)
13,318 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Using CHOOSE()
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
Comments posted to this topic are about the item The DBA is Dead! Long...
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers