Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I import binary files into SSIS as well as how to improve throughput by...
2010-05-28
3 reads
SQLRunner
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I import binary files into...
2010-05-28
2,458 reads
Evernote and the posting of scripts.
I heard of EverNote sporadically in the Twitter community and from my boss. I had checked it out and it seemed...
2010-05-23
539 reads
Evernote and the posting of scripts.
I heard of EverNote sporadically in the Twitter community and from my boss. I had checked it out and it seemed like another place to store notes/tips/ideas. I thought to...
2010-05-23
1 reads
SSIS : Data Flow paths
I had a very interesting bug that had me running around for over a week. Turns out the bug was...
2010-05-01
868 reads
SSIS : Using the VariableDispenser object within Script Components
I have become accustom to modifying package variables within my Script Task using the VariablesDispenser object. It is convenient and powerful. I started working...
2010-04-26
1,473 reads
SSIS : Using the VariableDispenser object within Script Components
I have become accustom to modifying package variables within my Script Task using the VariablesDispenser object. It is convenient and powerful. I started working...
2010-04-26
3,077 reads
SSIS : Conditional Split optimization
I have built an enormous number of packages for this project over the past few weeks (just over 60) and...
2010-04-26
548 reads
Indexed Views
Views are used quite often within SQL Server for a number of reasons. They can be used to restrict access...
2010-03-26
440 reads
Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-26
885 reads
Blogs
Friday Flyway Tips: State-based deployment with Flyway Teams
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Advice I Like: The Main Thing
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Smile and Wave Boys
Comments posted to this topic are about the item Smile and Wave Boys
ExecutionLog3 table in Reportserver Database
I have a SSRS report for which users are complaining to be slow, but...
Question of the Day
Counting Bits IV
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers