Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,680 questions
2 answers
What does ADF SSIS Error "Disk Full Exception Caught" mean
Hi, we are running an Azure-SSIS Type Integration Runtime in Azure Data Factory. This morning this IR suddenly got Unavailable for some reason. Fortunately we had the Diagnostic Settings ADFSSISIntegrationRuntimeLogs enabled and I found the following…
asked 2024-09-25T10:26:26.61+00:00
Cedric Ahlers
35
Reputation points
commented 2024-10-05T01:33:45.2433333+00:00
Chandra Boorla
1,810
Reputation points Microsoft Vendor
0 answers
Entra ID Authentication Issues for SSIS Deployment in SQL Server 2022
The scenario involves two users, both configured with Entra ID and the sysadmin role for SQL Server 2022. While one user can successfully deploy SSIS projects to the target SSIS catalog, the other user encounters an error message stating: "The…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,107 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
21,696 questions
asked 2024-10-04T21:14:32.7466667+00:00
David B Forbush
0
Reputation points
asked 2024-10-04T21:14:32.7466667+00:00
David B Forbush
0
Reputation points
1 answer
Error while running .dtsx package in development server
Hi Team, I have six .dtsx packages. The packages read flat files and insert the data from the flat files into the database tables. I reset the password of the DB account(account name , say VISH) in the DB server. After resetting, I cloned the MyAppETL…
asked 2024-09-29T08:59:20.51+00:00
Vishnu Narayan
0
Reputation points
edited a comment 2024-10-04T01:16:24.1766667+00:00
Vishnu Narayan
0
Reputation points
3 answers
How to pass in clause values via SSIS paramter
Hi, I have created SSIS package based on the query( big query),In query in clause is there. I have created parameter in ssis level and trying to pass multiple values(a,b) to in clause ,It is not working how i can achieve. Can you please suggest…
asked 2021-04-09T06:32:19.5+00:00
KlearnSSIS
1
Reputation point
answered 2024-10-03T17:50:01.8133333+00:00
Michael Baker
1
Reputation point
0 answers
Does SSIS and SSDT require additional licenses for SQL Server 2019 Developer Edition?
Does SSIS and SSDT require additional licenses for SQL Server 2019 Developer Edition? Here is my SQL Server details SQL Server Management Studio 20.2.30.0 SQL Server Management Objects…
asked 2024-10-03T13:37:18.4033333+00:00
Lyles, Kevin
0
Reputation points
asked 2024-10-03T13:37:18.4033333+00:00
Lyles, Kevin
0
Reputation points
1 answer
TITLE: Microsoft Visual Studio ------------------------------ Cannot map the input column, 'CurrencyDate', to the lookup column, 'FullDateAlternateKey', because the data types do not match. ------------------------------ BUTTONS: OK -------------------
i have changed the data types to DT_DBDATE as instructed but when trying to map the fields, it keeps saying I cannot map the currencyDate to the lookup column, FulldatealternateKey, because datatypes do not match
asked 2024-08-14T12:50:28.01+00:00
Joel Manhede
0
Reputation points
commented 2024-10-02T16:34:46.6766667+00:00
Jeremy Rutherford
0
Reputation points
6 answers
Miss-mapped columns in SSIS
I have a simple ETL that is selecting columns from tables in one SQL Server database and inserting them into a table in another SQL Server db. The ODBC Source uses a SQL Query. The ODBC Destination is loading directly to the table. All is working…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,107 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
1 answer
One of the answers was accepted by the question author.
What ports are required for running SSIS?
What ports are required for running SSIS services? Is port 1856 needed? If so, why?
asked 2024-10-02T13:36:33.2866667+00:00
Effie Lewis
20
Reputation points
accepted 2024-10-02T14:27:26.09+00:00
Effie Lewis
20
Reputation points
1 answer
TFS: Checking in SSIS Packages and removing credentials
Our team use TFS for source control, for various objects, including SSIS packages. Those SSIS packages will often contain personally-issued credentials used for configured DB connections, etc. which (at least) the UserId is saved, if not the password.…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,107 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
asked 2024-10-01T18:57:30.8066667+00:00
Tony Scott
0
Reputation points
answered 2024-10-02T05:07:25.33+00:00
Olaf Helper
44,501
Reputation points
0 answers
how to fix "XAAccess - EnableXAAccess(EnalbeXAAccess) => Exiting(False)" error in DB2OLEDBv6 in for Windows 2019 Server
When install DB2OLEDBv6.msi for a Windows 2019 Server it start install, but in middle cancel and do rollback for install process. I tried install it with "DB2OLEDBv6 /quiet /l log.txt" In log.txt file appears first errors: Calling custom…
asked 2024-09-30T17:24:55.6+00:00
Malagon, Jairo E INTL - Colombia
0
Reputation points
asked 2024-09-30T17:24:55.6+00:00
Malagon, Jairo E INTL - Colombia
0
Reputation points
2 answers
I have installed Microsoft SQL Server 2022, but I cannot see the SSIS & SSAS packages.
Good day! When I installed SQL Server, I remember having ticked the options that asked me whether I wanted to include SSAS, SSIS & SSRS; I ticked them all since I wanted to have a many features as I possibly could. Now, am studying the book below: I…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,107 questions
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,785 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,918 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,282 questions
asked 2024-09-30T10:23:41.08+00:00
Eric KALONJI
0
Reputation points
commented 2024-09-30T13:48:32.31+00:00
Eric KALONJI
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Problem with open SSIS folder by SSMS on clustered node
Hi Expert, I'd being installed SSIS service on each clustered nodes, only SQL Server engine that installed as FCI Resource, but I succesfully opened SSIS folder (MSDB folder) by SSMS at only one of nodes NOT both.. if any missed setting or configuration,…
6 answers
Error Fix (Database engine service failed in sql server 2022 and 2019)
Hello i am having troubles installing sql server 2022. my error is sql database engine fails to starts steps taken to install the sql on my laptop, was that i changed the account name of database engine service ( i did this because i have tried…
asked 2022-11-23T00:01:59.227+00:00
Nelson Nwachia
51
Reputation points
edited the question 2024-09-30T04:41:05.1433333+00:00
ShaktiSingh-MSFT
15,301
Reputation points
3 answers
Load file using SSIS if Exists in source folder else stop the process
Hi Team, Have a one requirement like bellow. My team placing a one excel file in folder and need to upload into data base. Before loading data need to check either file is exists or not. If exists load data into DB else stop the process. Please…
asked 2020-10-21T05:28:56.773+00:00
Bala Narasimha Challa
466
Reputation points
answered 2024-09-29T11:28:47.43+00:00
Ramana Kopparapu
306
Reputation points
2 answers
Msg 319, Level 15, State 1, Line 88 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Create Table #percentpopulationvaccination ( continent nvarchar(255), location nvarchar(255), date numeric, population numeric, New_vaccinations numeric, rollingpeoplevaccinated numeric, ); Insert Into #percentpopulationvaccination select dea.continent,…
asked 2023-03-31T12:41:12.3266667+00:00
pruthvi salian
0
Reputation points
commented 2024-09-27T22:53:31.02+00:00
Jehan
0
Reputation points
3 answers
One of the answers was accepted by the question author.
How many ways are there to reset Windows 365 Business Cloud PC password?
1:- How many ways are there to reset Windows 365 Business Cloud PC password? 2:- Windows 365 Business Cloud PC password {not portal login password => (windows365.microsoft.com) } and M365 account passwords are the same or different. 3:- I have…
asked 2023-03-06T18:20:41.81+00:00
VIPIN KUMAR
20
Reputation points
accepted 2024-09-26T17:09:02.67+00:00
VIPIN KUMAR
20
Reputation points
asked 2023-09-17T22:10:26.2266667+00:00
Ibukun John
0
Reputation points
commented 2024-09-26T13:26:07.5366667+00:00
Mattias Pihl
0
Reputation points
2 answers
How to solve - The value of the property 'Exclusiongroup' is incorrect ?
I had an SSIS package created with VS 2012 or older which transfers data from a flat file to a Teradata database (ODBC) . Used to work fine. I upgraded to Visual Studio 2017 and had to edit the package and save it. When I execute the package I get an…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,107 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
asked 2023-07-26T18:38:48.7433333+00:00
Janakiraman Balasubramanian
0
Reputation points
commented 2024-09-26T11:05:37.49+00:00
John Gibby
0
Reputation points
0 answers
Ambiguous variable property override in SSIS
0 In instances where a user tries to override the same variable multiple times while executing a SSIS package, all the records in SSISDB.internal.execution_property_override_values seem to be updated. DTExec.exe /ISServer…
asked 2024-09-26T10:29:07.82+00:00
Prabin Kayastha
0
Reputation points
asked 2024-09-26T10:29:07.82+00:00
Prabin Kayastha
0
Reputation points
2 answers
Export from SQL server to Excel with rich-text staying in each cell
Need to export from SQL server database to Excel. Data type is ntext and contains rich text. I need the data from each record to maintain within one Excel cell and preserve the rich text, i.e. line breaks and formatting.
asked 2024-09-23T16:45:19.29+00:00
Richard Bonnette
0
Reputation points
commented 2024-09-24T02:19:03.6033333+00:00
ZoeHui-MSFT
36,511
Reputation points