SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,839 questions
Content
1 answer
Does Interactive authoring of the integration runtime have to be activated manually?
Hello! I just wanted to know if there's a way to automate the enabling of the interactive authoring of the AutoResolveIntegrationRuntime. Thanks!
asked 2022-06-29T16:07:00.26+00:00
Federico Arturo Ramirez Seidel
26
Reputation points
commented 2023-01-27T15:53:05.7033333+00:00
Marc Scirri
1
Reputation point
7 answers
One of the answers was accepted by the question author.
Can you recommend a sql formatter?
Dear colleagues, Which SQL formatter would you recommend? In our organization, we have coding standards. My problem is, there are to many of them. As I am responsible for the repositories containing SQL, I want to enforce a single standard by…
asked 2020-11-17T14:17:45.18+00:00
Chris Sijtsma
106
Reputation points
answered 2023-01-27T15:42:17.4866667+00:00
Liubov Bovan
0
Reputation points
2 answers
SSIS Custom Connection Manager
I`m trying to create a custom connection manager for SQL Server Integration Services 2019, this component already works in SQL Server Integration Services 2012, but, after converting to SQL Server 2019 and changing DLLs of the same version, when I use…
asked 2023-01-19T20:08:21.2066667+00:00
Josivan Laskoski
0
Reputation points
commented 2023-01-27T15:41:56.5933333+00:00
Telen Wang
80
Reputation points
0 answers
Where can I find R Package MicrosoftML to use with SQL Server 2022 Machine Learning Services?
Hi, I am in the middle of the testing phase within migration from SQL Server 2019 to SQL Server 2022. I am using Machine Learning Services in SQL Server 2019 and this part has changed with SQL Server 2022. I have followed the installation guide here:…
0 answers
Best way to handle product selection when creating a quote
We are on dynamics 8.2. When I am creating a record for a quote, it doesn't allow me to select a product at the time of the creation of the record. I have to save it without selecting a product and modify the quote to select the product I want to sell.…
asked 2023-01-27T15:33:18.8366667+00:00
Raz. Usmani
0
Reputation points
asked 2023-01-27T15:33:18.8366667+00:00
Raz. Usmani
0
Reputation points
3 answers
SSIS package execution fails from the integration services catalogue - Failed to decrypt an encrypted XML node.
Hi, I've migrated SSIS packages from SQL 2014 to SQL 2019. Software and tools used in the VM: Visual Studio 2019 SQL Server 2019 SQL Server Integration Services 15.0 Microsoft Connector for Oracle (SSIS Oracle connector) 15.0 And use Standalone SQL…
0 answers
SSRS report - Export hidden columns to Excel
Is it possible to export a report into Excel with some columns being hidden but not completely removed? Thanks
2 answers
Visual Studio 2022 SSIS cannot enable logging
Right-click Control Flow area. Select logging. In Containers, I see Package1, that is not the name of my package. There is no checkbox next to Package1. How do I get the correct package in Containers and enable logging.
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,387 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,839 questions
asked 2023-01-26T20:11:26.6066667+00:00
John Eveland
0
Reputation points
edited an answer 2023-01-27T14:48:52.98+00:00
Yitzhak Khabinsky
19,846
Reputation points
2 answers
Cannot login into an SQL server remotely through ssms when using windows credentials. This reoccurs after exactly a week and stops after a reboot.
We have a SQL Server 2008 R2 which locks all remote windows connections after a week. We get this error message The target principle name is incorrect. Cannot generate SSPI context. Upon reboot, connections are successful but this reoccurs exactly…
asked 2023-01-23T20:34:01.2366667+00:00
Eudias Kifem
0
Reputation points
commented 2023-01-27T14:03:24.7566667+00:00
Eudias Kifem
0
Reputation points
0 answers
Performance issues - Sql Server 2022 Standard Edition
Hi, I've been using SQL Server 2014 express to store data and interact with my C# applications on Windows 10 for different years. I wanted to do some test with Sql Server 2022 before upgrading to that version so I've installed the Evaluation Edition (all…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,387 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.
6,910 questions
asked 2023-01-27T14:01:43.71+00:00
Leonardo Azzari
0
Reputation points
asked 2023-01-27T14:01:43.71+00:00
Leonardo Azzari
0
Reputation points
5 answers
Jeremy Louder Define Version of SQL Server is Best For Developing Database
Jeremy Louder | I need To Develop Some Database in SQL Server 2012. I Might be Best SQL Server 2012 To Develop Database with Enhance Features.
asked 2023-01-26T20:35:47.8066667+00:00
Jeremy Louder
0
Reputation points
edited a comment 2023-01-27T13:59:56.7733333+00:00
Erland Sommarskog
67,481
Reputation points Microsoft MVP
1 answer
Access primary database instance from read replica instance
Since we are starting to use read replica in our projects, we are going to migrate the our data retrieval procedures to read only database. But, we are doing the performance track inside that procedures that we are moving to read only DB and it is…
asked 2023-01-27T12:04:45.9166667+00:00
Mathankumar Rajendran
0
Reputation points
answered 2023-01-27T13:48:34.0666667+00:00
Alberto Morillo
24,631
Reputation points Microsoft MVP
2 answers
Where is the #tmptable?
Dear All, I created a temp table by the following Select Statement. However, I was not able to find #tmptable in the Tables list in SSIS. Might I know where the $tmptable went? (84242 rows affected) Tables in Object Explorer
asked 2023-01-27T08:13:03.64+00:00
Anonymous
commented 2023-01-27T13:47:39.2966667+00:00
Anonymous
1 answer
how do i launch an app to play store
i just need answers
asked 2023-01-26T15:21:54.4+00:00
KAMU JOSE
0
Reputation points
answered 2023-01-27T13:32:56.52+00:00
Olaf Helper
25,476
Reputation points
0 answers
I can`t import data from Streaming dataset by API
I am working in my Local Dataset and I need to add a new table, but this table is in Streaming Dataset. I am the owner of the Stream Dataset, but when try includ this table, the system show me that exist an error in the connection Technical Details:…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
3,415 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
5,892 questions
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
12,559 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
5,270 questions
asked 2023-01-27T13:28:05.1733333+00:00
Saul Bohorquez
0
Reputation points
asked 2023-01-27T13:28:05.1733333+00:00
Saul Bohorquez
0
Reputation points
0 answers
SSRS - export to Excel and image size
I have a column with small images. They look fine in the Browser but in Excel they look too big: Browser: Excel: Image settings are the following: Any idea?
3 answers
One of the answers was accepted by the question author.
SSRS 2019 Add New Data Source an error has occurred. something went wrong
Trying to add a new data source, and as soon as I click "new, data source" an error box pops up "an error has occurred. something went wrong. please try again" If I click OK under properties and name in the text box to add the…
asked 2020-09-16T21:11:37.69+00:00
John Abel
211
Reputation points
answered 2023-01-27T12:42:29.8866667+00:00
Shoeb Shabibi
0
Reputation points
0 answers
Can we convert R script to M code (Power Query)
As we are having few scripts in R which we are consuming in another scope, as per the new scope that needs be migrated to M (Power Query). If so, are there any best practices to migrate existing scripts to M code. Do we have any tools that can be used…
asked 2023-01-27T12:38:18.8+00:00
Manohar Kondragunta
0
Reputation points
edited the question 2023-01-27T12:42:10.4366667+00:00
ShaktiSingh-MSFT
4,666
Reputation points Microsoft Employee
1 answer
An Unexpected error has occured
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "dga1app20rescs_RS_BlankTemp" requested by the login. The login failed. Login failed for user 'sa'. at…
asked 2023-01-27T11:56:33.8933333+00:00
Vivardhan Reddy Vedium
0
Reputation points
answered 2023-01-27T12:11:48.3533333+00:00
Olaf Helper
25,476
Reputation points
2 answers
One of the answers was accepted by the question author.
how to change tabular mode to multidimensional model？
Hi there, I am trying to deploy multidimensional project to sql server and get an error. I was installed a tabular database. How to change tabular to multidimensional? Or I need to reinstall SSAS?
asked 2021-09-23T02:32:42.227+00:00
ismepopola
61
Reputation points
edited a comment 2023-01-27T11:54:22.1733333+00:00
Martin Belak
0
Reputation points