Extract the File Name in SSIS Data Flows using the FileNameColumnName Property
When extracting data from a flat file, it is handy to have the name of the file from which the...
2018-12-15
446 reads
Blog Posts
Test connection failed because of an error in initializing provider. Oracle client and networking components were not found
You may experience the following error. When a...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2018-12-15
9 reads
Test connection failed because of an error in initializing provider. Oracle client and networking components were not found
AdvertisementsYou may experience the following error. When a developer installed oracle client and tested the visual studio BIDS packages ask...
2018-12-15
8,095 reads
Using the SSIS Multiple Flat Files Connection Manager
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
25 reads
Using the SSIS Multiple Flat Files Connection Manager
When building an ETL pipeline to import data from a text file, it’s very common to have the incoming data...
2018-12-15
332 reads
ASF 017: Alex Whittles interview
Introduction Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the...
2018-12-14
202 reads
Azure Backup Storage Options
As a database administrator, I am very conscious of how data is being backed up. Up until SQL Server 2012,...
2018-12-14
651 reads
Fun time Friday - A week is a long time in....
A week is a long time in...
SQL Server LandA week is a long time in SQL Server land. This week I have been busy working on a version migration...
2018-12-14
8 reads
Fun time Friday - A week is a long time in....
A week is a long time in...
SQL Server Land
A week is a long time in SQL Server land. This week...
2018-12-14
179 reads
SQL Server Guide To NULL Handling
Every language handles null equality differently and understanding this is crucial as a misunderstanding here can lead to some quite...
2018-12-14 (first published: 2018-11-29)
3,223 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kantor Bank BCA KCU KEDIRI Telp:08218154393
WA:08218154393 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Alamat Kantor Bank BCA KCU MALANG Telp:08218154393
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers