Working with Excel Destinations in SSIS - 0xC0202025, 0x80040E21
Working with Excel in SSIS is not fun and something I whole-heartedly discourage. With that said, I had a not...
2012-12-12
1,539 reads
Josef Richberg
Existence Check Deconstructed -- SSIS Lookup Transformation
There are countless ways to mix and match components in SSIS to simulate what SQL Server does in a query....
2012-11-10
1,051 reads
Existence Check Deconstructed -- SSIS Lookup Transformation
There are countless ways to mix and match components in SSIS to simulate
what SQL Server does in a query. Here I am going to show you how to...
2012-11-10
81 reads
Existence Check Deconstructed -- SSIS Lookup Transformation
There are countless ways to mix and match components in SSIS to simulate what SQL Server does in a query. Here I am going to show you how to...
2012-11-10
31 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so...
2012-04-27
2,844 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune
the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it places them into...
2012-04-27
252 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it...
2012-04-27
27 reads
SSWUG Expo..I'm up!
I am proud to say that one of the webcasts I taped last year for SSWUG is part of the...
2012-04-26
341 reads
I'm presenting at 24 Hours of Pass!!
Woohoo! I have been selected to present my SSIS Tips & Tricks presentation at this year's 24 Hours of Pass. I am...
2012-03-04
523 reads
PASS Virtual Chapter: SSIS Enhanced Threading Framework
I'll be giving a presentation tomorrow, Tuesday 2/21/2012 at 12PM EST on my Enhanced Threading Framework design. Here is the...
2012-02-21
428 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers