Microsoft Q&A

SQL Server Integration Services

2,226 questions

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,226 questions with SQL Server Integration Services tags

Sort by: Updated
2 answers

Send email in SSIS

How to configure the package when the data has been loaded successfully, send the emails to the workers?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2023-09-22T00:24:42.34+00:00
ELEVEN 0 Reputation points
answered 2023-09-22T04:34:42.3333333+00:00
Olaf Helper 33,836 Reputation points
2 answers

Can i load multiple txt files to table at one time

Like titled, I try to use bulk insert, however, it seems does not work. Suggest please.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2023-09-22T00:20:59.91+00:00
ELEVEN 0 Reputation points
answered 2023-09-22T04:32:19.6333333+00:00
Olaf Helper 33,836 Reputation points
3 answers

Connecting to Azure SQL Database Using Either Service Principal or Managed IdentityPpl

Using SSIS (Visual Studio 2019 Community), on my home PC I am trying to create a DB connection to the Azure SQL Database using either an AZ Service Principal or Managed Identity. Not sure if this is possible or not? NB: I don't want to use either ADF or…

Azure SQL Database
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2023-09-16T19:48:08.9566667+00:00
commented 2023-09-21T14:51:47.7066667+00:00
GeethaThatipatri-MSFT 21,396 Reputation points Microsoft Employee
2 answers

How to fix data convertion error from string value to int in ssis

Currently, I am working on a task where I am using the "SSIS Integration Toolkit for Microsoft Dynamics 365" to fetch data from online dynamic CRM source and populate this to on prem CRM database(just a copy activity). I am using dynamic crm…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
431 questions
asked 2023-09-20T17:25:25.2733333+00:00
Avijit Swarnakar 0 Reputation points
commented 2023-09-21T06:49:58.71+00:00
Avijit Swarnakar 0 Reputation points
2 answers One of the answers was accepted by the question author.

Duplicate rows based on a column

HI Team, I am trying to duplicate the rows based on a column. Input: declare @table table ( accountid varchar(20), startdate date, numberofinstance int, instanceamount decimal(18,2) ) insert into @table select 1,'2023-09-10',3,100 union all select…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 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,545 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2023-09-20T12:46:16.23+00:00
Eshwar 196 Reputation points
answered 2023-09-20T14:06:10.85+00:00
Eshwar 196 Reputation points
1 answer One of the answers was accepted by the question author.

Oledb Destination trying to connect to all schemas

SSIS oledb connection error

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2022-09-28T08:08:49.357+00:00
Ersan İmrat 21 Reputation points
edited a comment 2023-09-20T11:03:12.6033333+00:00
Ersan İmrat 21 Reputation points
1 answer

how can i find any calculations dervied in ssrs paginated report

Hi !! I am very new to ssrs reports , I have bulk of ssrs paginated reports in web portal , I need to find any calculations dervied in ssrs paginated reports. Can some help me

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 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,545 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 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,167 questions
asked 2023-09-20T00:17:07.67+00:00
Mounika, Durgam 1 Reputation point
answered 2023-09-20T06:55:07.2+00:00
AniyaTang-MSFT 9,601 Reputation points Microsoft Vendor
1 answer

SSIS package not importing data for some files, even when entire package successful

I am trying to import roughly 300 delimited UTF-8 txt files using SSMS 2019 into SQL Server 2016. However, around 88 of these files do not import any data, despite there being data in the original file. The entire package shows as successful and there…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2023-09-19T14:41:48.58+00:00
Bill Park 0 Reputation points
commented 2023-09-20T05:41:48.89+00:00
Bill Park 0 Reputation points
2 answers One of the answers was accepted by the question author.

Cases assigned to me

When we uninstall an unused SQL Server from our environment, is there any technical impact on the server side?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 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,545 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
431 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,167 questions
asked 2023-09-19T07:59:23.8866667+00:00
Rao, Mayank 20 Reputation points
accepted 2023-09-19T16:15:04.33+00:00
Rao, Mayank 20 Reputation points
3 answers

How to fix SQL Server 2022 installation error

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2023-09-17T22:10:26.2266667+00:00
Ibukun John 0 Reputation points
answered 2023-09-18T21:15:30.2366667+00:00
Erland Sommarskog 87,271 Reputation points
2 answers

change table exampe

Hi Expert, can i get some easy CHANGETABLE example in sql server which is easy to understatnd and understand or explain loigic in it Regards

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 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,545 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2023-09-16T23:19:15.72+00:00
Shambhu Rai 996 Reputation points
commented 2023-09-18T20:32:13.0966667+00:00
Erland Sommarskog 87,271 Reputation points
1 answer

last extracted date and change date

Hi Expert, Have loaded data in table for 2 times in a week without date dimension table or last extracted date ... how will i identify last refresh date and current refresh date in sql server create table emp(employee varchar(23),Age varchar(23),Salary…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 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,545 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 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,167 questions
asked 2023-09-15T21:04:31.4466667+00:00
Shambhu Rai 996 Reputation points
commented 2023-09-18T20:30:34.1+00:00
Erland Sommarskog 87,271 Reputation points
7 answers

SSIS Data Flow Task error - The version of the Flat File destination is not compatible with this version of the dataflow.

I am trying to edit an SSIS package and getting the error "The version of the Flat File destination is not compatible with this version of the dataflow." when trying to run it from a SQL Agent Job or when performing a validation on the SSIS…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2020-10-15T14:09:43.287+00:00
WMB853 6 Reputation points
commented 2023-09-18T20:23:08.5866667+00:00
Abdul Khalique Mohammed 0 Reputation points
2 answers One of the answers was accepted by the question author.

How to combine multiple columns into one single row and aggregate the strings into list or one string

How to combine multiple columns into one single row . eg if you have two columns in a table called name, surname, and location. neo hlophi london peter lock asia bernad jules asia result : I want to have name and surname combined by a dash e.g :…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
Microsoft Graph Toolkit
Microsoft Graph Toolkit
A collection of reusable, framework-agnostic components and authentication providers for accessing and working with Microsoft Graph.
27 questions
asked 2023-09-14T20:18:25.22+00:00
Mahlangu, Neo N 20 Reputation points
commented 2023-09-18T10:49:17.45+00:00
Mahlangu, Neo N 20 Reputation points
0 answers

SQL Agent SSIS job step fails with "The login is from an untrusted domain and cannot be used with Integrated authentication"

A user raised an issue with me today where a SQL Agent SSIS job step was failing with: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication The SSIS step was using an SSIS subsystem proxy rather than the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2023-09-15T16:28:42.2066667+00:00
Peter Bishop 161 Reputation points
3 answers

alternative to store procedure

Hi Expert, do we have any alternative to store procedure while running merge statement where we can use exec or run like exec sp_name can we use view instead of any table to something else Regards

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
43 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.
10,923 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
431 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,167 questions
asked 2023-09-14T13:26:11.2666667+00:00
Shambhu Rai 996 Reputation points
edited a comment 2023-09-15T10:25:28.9566667+00:00
Shambhu Rai 996 Reputation points
4 answers

SSIS Package run via a job step with a proxy. Which account determines where BufferTempStorage goes?

And what write permissions are required. I've asked both Bing AI and ChatGPT and they contradict each other. Is it the SQL Agent service account or the Proxy account that determines where the files are written and which account requires Write…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2023-08-04T01:52:36.57+00:00
Nick Ryan 0 Reputation points
commented 2023-09-15T08:48:13.9033333+00:00
Amira Bedhiafi 4,071 Reputation points
2 answers One of the answers was accepted by the question author.

Split column based on keyword in SSIS and delete from main colum

Hello Experts, In continuation of earlier raised question. https://learn.microsoft.com/en-us/answers/questions/1320469/split-column-information-based-on-keywords-in-ssis With the help of Token and TokenCount I am able to split information from…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2023-08-09T14:54:40.2+00:00
PANDEY Prashant 85 Reputation points
edited an answer 2023-09-15T08:23:59.33+00:00
Amira Bedhiafi 4,071 Reputation points
1 answer

Compiling script components in SSIS package through code

Actually, we have SSIS packages built in visual studio 2017 and target version as Sql server 2016 and now as part of new changes, we are updating the sql server installed version from 2016 to 2022. because of this, we changed the visual studio to 2019…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,923 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 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.
8,963 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,085 questions
asked 2023-09-14T11:17:08.1566667+00:00
LVS Raghu Vamsi 40 Reputation points
edited the question 2023-09-15T01:27:11.76+00:00
Tianyu Sun-MSFT 20,686 Reputation points Microsoft Vendor
5 answers

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536

We have moved our SQL Database to SQL Server on Azure VM. I have already ran these USE SSISDB GO EXEC sp_changedbowner 'sa' Alter database SSISDB SET Trustworthy ON I am trying to deploy the package and create a folder but I still gettign…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
asked 2020-10-07T10:41:41.68+00:00
Nicky 116 Reputation points
commented 2023-09-14T13:50:59.1266667+00:00
Claudia Cavalcante Pires 0 Reputation points