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
777 reads
An efficient and reliable method for reading CSV files with variable columns.
2018-06-12
28,006 reads
I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.
2018-05-17
3,082 reads
A tip to auto detect data types for flat file sources in SSIS. Never manually enter them ever again!
2018-05-14
11,402 reads
This article shows how DefaultBufferMaxRows and DefaultBufferSize properties can be used to improve dataflow task performance.
2018-03-22
35,884 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,541 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,026 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,080 reads
SQL Server Integration Services (SSIS) is the integration and ETL (extract – transform – load) tool in the Microsoft Data Platform stack. SSIS is typically used in data warehousing scenarios, but can also be used in common data integration use cases or just to move data around. SSIS is used behind the scenes in the Maintenance Plans of SQL Server and in the Import/Export wizard.
2017-10-06
4,301 reads
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
SQL Server 2025 introduces native support for vector data types and external AI models....
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
I'm building ETL packages in SSIS. My data comes from an OLE DB Source...
Comments posted to this topic are about the item Building AI Governance and Policies-...
Why is sql doing a full scan VS seeking on the index? I've included...
The DBCC CHECKIDENT command is used when working with identity values. I have a table with 10 rows in it that looks like this:
TravelLogID CityID StartDate EndDate 1 1 2025-01-11 2025-01-16 2 2 2025-01-11 2025-01-16 3 3 2025-01-11 2025-01-16 4 4 2025-01-11 2025-01-16 5 5 2025-01-11 2025-01-16 6 6 2025-01-11 2025-01-16 7 7 2025-01-11 2025-01-16 8 8 2025-01-11 2025-01-16 9 9 2025-01-11 2025-01-16 10 10 2025-01-11 2025-01-16The docs for DBCC CHECKIDENT say this if I run with only the table parameter: "If the current identity value for a table is less than the maximum identity value stored in the identity column, it is reset using the maximum value in the identity column. " I run this code:
DELETE dbo.TravelLog WHERE TravelLogID >= 9
GO
DBCC CHECKIDENT(TravelLog, RESEED)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-09-14', '2025-09-17')
GO
What is the identity value for the new row inserted by the insert statement above? See possible answers