Category "ssis"

SSIS using Script task - Convert XLS to CSV

I am using C# script task component to convert XLS to CSV file , my entry point is set to ScriptMain But I am constantly getting error "Error: Cannot execute s

SSIS - Connection Manager Work Offline is grayed out

I am trying to debug an SSIS package locally, but for some reason the connection manager is offline and it can't be changed. Have anyone faced this issue before

Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

I am getting following error while attempting to execute the package. I can execute individual task successfully. But whenever attempt to execute whole package

TextFieldParser ignoring header row C#

Reading in CSV files and the TextFieldParser skips the header row. Any idea how to make certain the first row is skipped. String[] Col3Value = new string[40];

Script to Download xls files embeded in a .msg file

There are 1000s of .MSG files on my d drive and each containe an XLS file,as attachemnt. Is there any way to download these xls files from these .msg file usin

To read Xml file from variable in XML Source in SSIS

I am getting the result in variable through web Service Task as shown in below image, Then I have used XML task to remove the excess namespace and stored the

SSIS loading data error

I have a CSV file which contains this data: EmployeeCode,EmployeeName,EmployeeSalary,Date 101,raju,1000,2/2/2003 102,krish,100,3/4/2005 103,rishbh,320,12/9/200

Kafka vs StreamSets

I was reading articles related to Kafka and StreamSets and my understanding was Kafka acts as a broker between Producer system and subscriber. Producer push t

Kafka vs StreamSets

I was reading articles related to Kafka and StreamSets and my understanding was Kafka acts as a broker between Producer system and subscriber. Producer push t

Kafka vs StreamSets

I was reading articles related to Kafka and StreamSets and my understanding was Kafka acts as a broker between Producer system and subscriber. Producer push t