Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
990 reads
Devin Knight
Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
8,350 reads
SSIS Checkpoints with Tasks Running in Parallel
Several months ago I blogged about why Checkpoints are a great feature in SSIS to use. It seems with every...
2010-01-22
3,452 reads
SQL Lunch #8 recording
If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website. ...
2010-01-15
599 reads
SQL Lunch #8 recording
If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website. ...
2010-01-15
576 reads
Configure Report Manager to open Report Builder 2.0
Recently while at a client I was discussing the differences between Report Builder 1.0 and Report Builder 2.0. The discussion...
2010-01-08
883 reads
Configure Report Manager to open Report Builder 2.0
Recently while at a client I was discussing the differences between Report Builder 1.0 and Report Builder 2.0. The discussion...
2010-01-08
1,733 reads
Analysis Services Performance Optimization Tips
Over the last few weeks I have focused most of my blog energy into writing a couple articles. So I...
2009-12-29
1,865 reads
Anaylsis Services Partitions and Aggregations PASS Session
For a little more than a year now I've been a part of the PASS BI SIG and have tried...
2009-12-18
426 reads
Using a SSRS Report to run SQL Agent Jobs part 2
In part one of this post I showed how you can use a report to run SQL Server Agent Jobs by...
2009-12-11
1,871 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers