Yesterday I wrote about the little-known but still useful multiple flat file connection manager. In this post, I will briefly show a more commonly used alternative approach for processing...
2018-12-17
17 reads
When extracting data from a flat file, it is handy to have the name of the file from which the...
2018-12-15
427 reads
When extracting data from a flat file, it is handy to have the name of the file from which the data was retrieved. Whether you capture this information for...
2018-12-15
5 reads
When building an ETL pipeline to import data from a text file, it’s very common to have the incoming data...
2018-12-15
323 reads
When building an ETL pipeline to import data from a text file, it’s very common to have the incoming data spread across multiple files. For example, if you are...
2018-12-15
4 reads
I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions...
2018-12-13
189 reads
Call me pedantic, but I can be a stickler for standardized naming conventions. Whether it’s application code, database objects, documentation,...
2018-12-13
206 reads
It’s that time again! My Eleven Days of Festivus blogging extravaganza is now in its third year, and I’m happy...
2018-12-13
164 reads
It’s keynote time again! The second full day of the conference starts now, and like yesterday, I’ll be live-blogging during...
2018-11-08
187 reads
Today is the first full day of the PASS Summit in Seattle, Washington. This is the 20th year of the...
2018-11-07
305 reads
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
Hi I am working on a rolling average calculation that is not working quite...
Comments posted to this topic are about the item Subscribing to a Great New...
Hi, is there a way when using excel as a flat file source in...
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers