2013-10-22
2,197 reads
Integration Services (SSIS)
Talend vs. SSIS: A Simple Performance Comparison
With all of the ETL tools in the marketplace, which one is best? Jeff Singleton brings us simple performance comparison pitting SSIS against open source powerhouse Talend.
2013-10-22
14,658 reads
SQL Server Integration Services Connection Manager Tips and Tricks
In this article, we will take a look at the following Tips and Tricks for Connection Managers: Adding an "Application Name" property to the connection string; Creating Two Connection Managers for each Database Connection; and Capturing Connection Manager details in Package Configurations
2013-10-15
5,063 reads
32 bit SSIS in 64 bit environment
This article provides a solution to executes 32 bit SSIS packages in 64 bit environment.
2013-10-14
7,392 reads
2013-10-10
2,423 reads
SSIS Deployments with SQL Server 2012
This article describes different methods for deploying your SSIS projects to a server.
2013-08-15
10,079 reads
SSIS 2012 - Using PowerShell to Remotely Execute File System Packages
A Powershell script that allows you to execute SSIS packages using the traditional Package Deployment Model can be very useful. But what do you do when the execution isn't triggered by the same computer where the target package resides? Marcin Policht offers a solution.
2013-08-09
2,741 reads
2013-08-05
1,758 reads
2013-07-19
2,689 reads
Resolving Errors While Connecting to SSIS
This article will help you solve connection errors with SSIS due to permission issues.
2013-07-18
3,571 reads
Blogs
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Forums
Even When You Know What You're Doing, You Can Screw Up
Comments posted to this topic are about the item Even When You Know What...
The New Software Team
Comments posted to this topic are about the item The New Software Team
Database Mail in SQL Server 2022
Comments posted to this topic are about the item Database Mail in SQL Server...
Question of the Day
The string_agg function
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers