SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,346 questions
0 answers
SharepointListSource Issue in SSIS when Deploymed on SQL Server 2019
Hello, i have an SSIS Package project that was designed in 2015 and was working fine and deployed on the windows server 2012 R2 targeting SQL Server 2014.Now we are migrating to windows server targeting SQL Server 2019.I took the package and opened it in…
asked 2024-06-21T15:50:35.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 96%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tumo Maraisane
0
Reputation points
edited the question 2024-06-26T08:35:08.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHX%3C/text%3E%3C/svg%3E)
Haoyan Xue_MSFT
22,381
Reputation points Microsoft Vendor
3 answers
Get error column name using script transformation
Hello, Hello with error caused by the GetIdenfificationStringByLineageID. I'm trying to get the actual error column name and I can't get pass this error message. Thanks,
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,641 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
1 answer
Connection to a managed SQL instance using Microsoft Entra Integrated Authentication
We need your assistance with connecting to a managed SQL instance using Microsoft Entra Integrated Authentication from VM. We're encountering the following error when attempting to connect. This is required for migration of our solution to Cloud. …
asked 2024-06-19T13:03:52.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 56.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vishwanath K Bellubbi
0
Reputation points
commented 2024-06-24T22:30:30.5833333+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Return End of String Between 2 Brackets - SSIS Derived Column Expression
Hello, The difficulty of extracting the error column name in an SSIS data flow is widely recognized. To meet the requirement of minimizing scripting transforms/components, I cannot use a complex scripting solution to identify error columns in the…
1 answer
Error loading Oracle components in VS 2019 after SSIS upgrade to version 4.6 and rollback to 3.16
I'm getting the following error when attempting to open an Oracle source, destination, or connection manager in VS 2019. The text version of the above screenshot and message details are in the code block below. We began encountering this error after…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,883 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
193 questions
asked 2024-06-20T18:12:19.3033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 73%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Amanda Hansen
0
Reputation points
commented 2024-06-21T19:54:53.9333333+00:00
Amanda Hansen
0
Reputation points
5 answers
SSIS Project Connection Manager - Connection string format incorrect
We have the same Problem as this Ticket. We have an SSIS project that uses a Project Connection Manager for the destination tables. It's feeded from a project parameter that contains the connection string: Data Source=XXX;Initial…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 94%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 20%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
2 answers
DT_BYTES not able to convert Packed decimal in right format
I get weird result when I convert the ASCII file containing the packed decimal received from upstream system. The data is in form 0x00 0x00 0x00 0x00 0x00 0x97 0xB4 0x62 0x19 0x0A which dosen't seem to me correct ZONED format. Can someone please…
asked 2024-06-18T07:26:12.0633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 26%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Alkari, Niranjan
0
Reputation points
commented 2024-06-19T14:55:43.88+00:00
Alkari, Niranjan
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Is it possible to run an SSIS package with FUZZYGROUPING transformation in Azure?
I am using Fuzzy grouping transformation in SSIS locally "on premises", but I would like to explore the option to run it in Azure…
asked 2024-06-13T09:35:48.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 27%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jose M Naranjo-Espinosa
20
Reputation points
commented 2024-06-19T08:42:55.0333333+00:00
PRADEEPCHEEKATLA-MSFT
85,511
Reputation points Microsoft Employee
2 answers
how to insert records in a table using script task
I would like to insert records in a table by using script task. I cant use execute sql task and other task available in ssis. The script should be in C#.
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,346 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,641 questions
asked 2024-06-19T03:33:51.8233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 76%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Nilimesh Maiti
0
Reputation points
answered 2024-06-19T05:51:19.7066667+00:00
Olaf Helper
43,246
Reputation points
1 answer
How to Implement Late Arriving Dimensions in SSIS 2022
Hello, I'm looking for end-to-end documentation, if possible, with demo packages on implementing Late Arriving Dimensions use case leveraging the Inferred Flag approach in SSIS 2019/2022. I've been researching this for a while, and although there are…
1 answer
How do I configure OLE DB connection settings in Visual Studio?
While I tries to connect OLE DB in visual studio, i am getting error as TITLE: Connection Manager Please select .Net Provider. BUTTONS: OK
asked 2024-06-14T07:28:37.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 31%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Revathy D R
0
Reputation points
edited a comment 2024-06-17T05:36:44.9066667+00:00
Olaf Helper
43,246
Reputation points
2 answers
Visual studio 2022 crash when i create SSIS package
I installed VS 2022.. and create SSIS package for project. When i create the package VS 2022 unexpectedly close several times . why this happen the error is "A previous session ended unexpectedly. Disabling the extension SQL Server Integration…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,883 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
asked 2024-03-14T05:42:23.9166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 33%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Bakhtawar
1
Reputation point
commented 2024-06-14T23:25:00.45+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 17%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Amy Southworth
0
Reputation points
3 answers
Unexpected Termination Excel Export - Microsoft.ACE.OLEDB.16.0
Hi, 64 bit Microsoft.ACE.OLEDB.16.0 is installed on the server and the ssis package that exports data to excel fails with unexpected termination or doesn't export full data to excel tabs. No error logs shown. Please let me know if both 32 bit and 64 bit…
asked 2024-06-06T15:33:06.15+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 71%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Challagundla, Sindhura (ITS)
0
Reputation points
answered 2024-06-14T10:37:07.6366667+00:00
Ali Varzeshi
80
Reputation points
1 answer
One of the answers was accepted by the question author.
ADF Copy Data from on-premises SQL server to Azure SQL server
Error details local_sql_db_2_azure_sql_db Error code SqlFailedToConnect Failure typeUser configuration issue DetailsErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database.…
asked 2024-06-13T06:50:30.07+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 79%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Manoj Kumar
20
Reputation points
accepted 2024-06-13T13:49:08.9833333+00:00
Manoj Kumar
20
Reputation points
1 answer
SSIS Dataflow Task issue, moving data from any Source to MySQL via ADO.Net
Can you please help me in getting this problem solved.. I'm trying to build a SSIS package where I'm moving the data from any Source to MySQL. However I'm getting a weird problem in dataflow task. [ADO NET Destination [2]] Error: An exception has…
asked 2024-06-12T06:39:54.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 64%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Hossein Kazemian
0
Reputation points
commented 2024-06-13T08:36:39.1133333+00:00
Hossein Kazemian
0
Reputation points
1 answer
SSISDB page compression on big table is ok?
Hi all, I've just ended a ssis migration on a dedicated machine and today is the real first day run. I reduce the logging on the SSIS step to BASIC (but I would like to set to NONE). There are so many SSIS with HIGH frequency and from this morning ssdb…
asked 2024-06-12T20:53:53.1266667+00:00
Alen Cappelletti
992
Reputation points
answered 2024-06-13T05:48:12.92+00:00
ZoeHui-MSFT
35,551
Reputation points
2 answers
Error: "Please select .NET Provider." in Connection Manager, SSIS
Hello, So I am pretty new to SSIS and am trying to use the different Control Flow tasks that show up on the left in Visual Basic 2022. I created a new Execute SQL Task and tried to connect it to the test database I created on SSMS but I got an error in…
asked 2024-06-12T15:43:35.9633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Amogh Sharma
0
Reputation points
answered 2024-06-13T05:35:21.5133333+00:00
ZoeHui-MSFT
35,551
Reputation points
2 answers
Importing Large Data Sets in Visual Studio 2019 and SQL Server 2019 on Windows 11
Hi everyone, I recently installed Visual Studio 2019 and SQL Server 2019 on my Windows 11 system. When creating a project that involves importing a large data set with more than 1 billion rows, I encounter some issues. When using the SSIS process and…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 79%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
3 answers
Is It Possible To Call HTTPClient From SSIS Script Task?
Hi, I have the following code in my SSIS script task: However, if I put a break point on the client.SendAsysnc, the code goes right by it. Then if I take out the break point and do a break point after execution, the SSIS project just stops running. …
asked 2024-06-06T17:37:15.7233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 76%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Paduck, Daniel
0
Reputation points
answered 2024-06-07T06:24:10.11+00:00
ZoeHui-MSFT
35,551
Reputation points
3 answers
asked 2024-06-03T08:19:20.6533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 46%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cydrx Malla
0
Reputation points
commented 2024-06-06T03:28:25.09+00:00
MikeyQiaoMSFT-0444
1,910
Reputation points