The column delimiter for column "" was not found.
I'm importing a csv file. I'm getting an error: The column delimiter for column "" was not found. It's always on the last column. And one of the columns in the csv file has a comma in the column value.
Looping through excel files
I am trying to load multiple excel files using for each loop container. In my 'Excel Connection Manger' I am accessing the data through 'SQL Command from variable'. I am getting an error message when I try to make the filename dynamic in the connection…
The scriptmain.cs can not be found in the SSIS package
I have a SSIS package with a script task. I can edit this script taks, but when I add a breakpoint in the C# code and I run the package I get an error that the ScriptMain.cs can not be found. I use Visual studio 2022 with data tools 2017 and integration…
Installing IBMi Access Driver on Azure Data Factory Integration Runtime
Hello, I've been trying to install the Windows version of the IBM i Access Driver on a Data Factory Integration Runtime through adding a script (main.cmd) and the desired installer in a Blob Container This script seems to work perfectly locally but when…
How to send data to an SAP C4C tenant through their OData API using SSIS
Hello, I need to be able to send data from an SQL Server Table (OLE DB Source) to an SAP C4C tenant using their OData API in SSIS. In the toolbox there is an OData Source through which data can be retrieved from the tenant but can't be sent back. Is…
Protocol Error in TDS Stream in SSIS - connected host has failed to respond
Hello, We are having issue when we are running SSIS package and getting following error: Code: 0xC0202009 Source: Sync Details Data FLow sqlssis OLE DB Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error…
"Incompatible" project
(Relatively new to SSIS so apologies if this is an easy one) I set up a data flow in the community version of VS as a proof of concept. Then moved to the enterprise version but opened the old project before installing SSIS and of course it said the…
how to enable the Integration Services Catalogs node
I dont see the "Integration Services Catalogs"node option in my sql sever connection. how to enable this option in my server. i installed the developer edition and also have sql integration service
VS2017 - SSIS Project
Hello Team, We are using VS2017 with SSDT installed (PFB the screenshot) We cannot find BI projects, unable to create SSIS projects. Please advice. Regards, Nagesh CL
Getting errors trying to import data from an SAP Cloud for Customer tenant using OData API in SSIS
Hello, So, I am attempting to import data from an SAP Cloud for Customer (C4C) System into an SQL Server Table using SSIS on Visual Studio 2022. I am using the Odata Source tool to connect to the system and the connection is successful. I can even see…
How to handle pipe delimiter file in SSIS?
|Col1| |Col2|Col3|Col| |101| |A|21|DC| The values in the file starts with vertical bar(|). The first column's values are moved to 2nd column and 2nd column's values to 3rd when I tried delimiter approach. How should I deal with it in SSIS to…
Microsoft.DataTools.IntegrationServices setup fails in Visual Studio Professional 2022 (Version: 17.10.4) Error Code: MainViewModel.OnBundleAction: Bundle action failed: Unknown error (0xe0434352) (0xE0434352)
I was trying to set up SSIS and SSAS extensions in Visual Studio Professional 2022 on Osirius PAM. The SSAS package was completed successfully, but for the SSIS package, I am still getting the same error: Unknown error (0xe0434352) (0xE0434352). Here are…
ApplicationName in project connection manager
We have a large number of packages within an SSIS project and these make use of project connection managers. I would like to change the ApplicationName property of the connection string to reflect which package it is coming from as this will be useful…
VS2019 - Connection Managers not saving passwords
I have an issue where passwords are not saving in the connection managers in my solution. I am able to add in the password and test it, then I ok it, however, when I go back in the password has disappeared. I have done some reading on this and one…
unable to convert unique identifier
Hi Team, unable to convert this value as an unique identifier and getting null values SELECT try_convert(uniqueidentifier,''9UIC32D1-932-4V03-45E9-FGSGDASASDATY'')testid
left and right join
Hi, table 1 Table 2 select A.* from table1a LEFT join table2 b on a.col1=b.col1 output: which is correct but on right join it shows above results how to calculate this join and how it will react on NULL and blank
~|~ Delimiter. Has anyone seen ~|~ as a delimiter?
I received the text files from our vendor every morning. The file contains ~|~ as a delimiter. Has anyone ever seen this kind of delimiter and if so, how do you handle this kind of delimiter? I am using SSIS Package to import the text file into SQL…
How to fix the error : Bundle action failed: Unknown error (0x80131500) (0x80131500) when trying to install SSIS on Visual Studio 2022 ?
Whenever I try to install SSIS on my laptop I run into this error : Bundle action failed: Unknown error (0x80131500) (0x80131500). I already repaired VS studio , uninstalled but nothing is working. I already followed the steps mentioned there :…
UNABLE TO DOWNLOAD SQL SERVER 2022 REPORTING SERVICES
Hi, I tried downloading the SQL SERVER 2022 REPORTING services but the download page is unable to reach don't know why is it temporary I'm trying download it from morning still same issue. Does anyone have any idea regarding thsi
Workday and alternative
Hi, I have a table which needs to duplicate with weekday and alternative create table table3 ( col1 varchar(20) , col2 varchar(20)) expected results Insert into table1 values('catch', 'catch1') …