Category Archives: SSIS (SQL Server Integration Service)

Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#

Previously, I have posted some SSIS solutions which would handle dynamic column mapping in data loading. This time, I was wondering how to handle dynamic column mapping when the source is an excel file. I was quick to realize that … Continue reading

Posted in MS Visual Studio, C#.NET, SQL, Database, SSIS (SQL Server Integration Service) | Tagged , , , , , | 13 Comments

Access SSIS variables in script task and script component

You have to write codes to access the variables in these two components in a slight different way. For Script Task: DTS.Variables[“VariableName”].Value For Script Component: Variables.VariableName Don’t forget to add these variables in task editor first. 🙂

Posted in SSIS (SQL Server Integration Service) | Tagged , , | Leave a comment

Avoid Concurrency problem while running SQL Server Jobs

Hello everyone, This time my problem was to delay the start of a SQL server job if another job is already running. Obviously, the reason for this is that the jobs use the same database resources. The sysjobhistory table in … Continue reading

Posted in SQL, Database, SSIS (SQL Server Integration Service) | Tagged , , , , , | Leave a comment

Cursor Using Foreach Ado Enumerator in SSIS

Recently, I have been trying to make a cursor using SSIS components and came up with this idea. The trick is explained below: Let’s say, we have a record set and we need to loop through the records to concatenate/append … Continue reading

Posted in SSIS (SQL Server Integration Service) | Tagged , , , , | 9 Comments

SQL Server Agent needs to Log on As Local System for using Oracle Oledb Provider in SSIS Job

This problem was one of the most terrible one in my short SSIS career. I was using a script task which uses Oracle Oledb provider to connect to an oracle server. After the package was complete, I created a SQL … Continue reading

Posted in SSIS (SQL Server Integration Service) | Tagged , , , , , | Leave a comment

the connection string format is not valid . it must consist of one or more components of the form….error

Back again with another SSIS SQL Server based configuration problem. I was using SQL server based configuration and the SSIS configuration wizard created one table with the default field lengths. The table is like this: CREATE TABLE [dbo].[SSIS Configurations](     [ConfigurationFilter] … Continue reading

Posted in SSIS (SQL Server Integration Service) | Leave a comment

Password must be included in connection string for SQL server based configuration in SSIS

Recently, I have been working with SSIS configurations a lot. At the beginning, it seemed not much difference between XML configuration and SQL server configuration to me. Very quickly, I was proved wrong. In the configuration wizard, we can choose … Continue reading

Posted in SSIS (SQL Server Integration Service) | 1 Comment