I would like to create the dynamic partition in one of my SSAS tabular model. To do so I found one approach with SSIS package which involves the "Analysis Servi
I have problems with SSIS process(acctually the same problem occurs for two different processes). So, we are doing some ETL work using SSIS. We have Business In
I am having an issue upgrading our existing 2017 SSIS packages to 2019 . I have updated the target server version in the package settings and we have installed
I have: Collisions{PK_id, cashLoss, deaths, city, state, county} I want: Collisions{PK_id, cashLoss, deaths, #IdLocalization} Localization{#LocalizationID(a
I have an SSIS package which intermittently fails with a handful of errors, the two most informative of which are: DFT_PlaySummary SSIS Error Code DTS_E_O
I have a problem in SSIS, with a simple data flow task between a sql SELECT and a CSV destination. I don't retrieve trailing spaces in string columns of the des
I am receiving the following error when trying to execute an SSIS package using Visual Studio 2012: Error 39 Microsoft.SqlServer.Dts.Runtime.DtsRuntimeExce
Here i am new in Developing the SSIS package I need your support to come up with the solution. I have 10 different set of stored procedures which I have to ex
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
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
I am getting following error while attempting to execute the package. I can execute individual task successfully. But whenever attempt to execute whole package
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];
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
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
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
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
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
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