Using The Transfer Jobs Task in SQL Server Integration Services
Database Administrators can use the Transfer Jobs Task to transfer one or more SQL Server Agent Jobs between different SQL Server instances
2009-10-21
2,013 reads
Integration Services (SSIS)
Using Transfer Error Messages and Transfer Master Stored Procedures Tasks in SSIS
DBA's can use the Transfer Error Messages and Transfer Master Stored Procedures tasks to transfer error messages and stored procedures between difference SQL Server instances.
2009-10-05
2,328 reads
Using SSIS to Capture the File Name
This article will show how to use SSIS to capture the file name during the load process and later remove bad data from your warehouse. New Author J.D. Gonzalez has an interesting approach that you might find useful.
2009-10-05
60,624 reads
Creating Dynamic Outputs in SSIS
In this article, we'll see how you can use the Foreach loop and the Expression Language to create multiple, dynamic outputs through object reuse.
2009-09-24
13,162 reads
SSIS & WMI Data Reader Task Query
This article will cover how we can make use of the WMI Data Reader Task to retrieve information about remote machines. Our example will focus Disk space usage of remote machines.
2009-09-01
7,835 reads
Flat File Imports with SQL Server Integration Services 2008
A main function of SQL Server Integration Service is to move data into and out of SQL Server. The external data source can exist in almost any format, including a plain text file. This article focuses on importing a text file into a standard SQL Server database table.
2009-08-20
4,444 reads
How to Specify Command Line Parameters for DTEXEC Using Command Files
Everything I've read about the built-in configuration options is that you can retrieve values from a SQL Server table, an XML file, etc. but I really prefer to just use the command line options. I'm currently specifying 10 or more command line options on average. Do you have any ideas on a better way to do this?
2009-08-18
3,212 reads
How to Resolve a BIDS 2005 and SQL Server 2008 Compatibility Issue
Caught in between upgrades, new author Mohan Jumar has an interesting article. Using Visual Studio 2005 to save packages in an SSIS 2008 package store.
2009-08-13
5,014 reads
Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS
The Transfer SQL Server Objects Tasks is a very useful tool in SQL Server 2005 to move objects between SQL Server Instances.
2009-08-13
2,578 reads
Where is my app.config for SSIS?
Sometimes when working with SSIS you need to add or change settings in the .NET application configuration file, which can be a bit confusing when you are building a SSIS package not an application. First of all lets review a couple of examples where you may need to do this.
2009-08-12
3,085 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers