SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
Content
2 answers
Send email in SSIS
How to configure the package when the data has been loaded successfully, send the emails to the workers?
asked 2023-09-22T00:24:42.34+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(230.39999999999998, 69%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
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.
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…
asked 2023-09-16T19:48:08.9566667+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(262.40000000000003, 24%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECI%3C/text%3E%3C/svg%3E)
CARRICK, Ian (NHS NORTH EAST LONDON CCG)
0
Reputation points
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…
asked 2023-09-20T17:25:25.2733333+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(201.6, 1%, 29%)' 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)
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…
![](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(86.4, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Oledb Destination trying to connect to all schemas
SSIS oledb connection error
asked 2022-09-28T08:08:49.357+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, 16%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
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
asked 2023-09-20T00:17:07.67+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(233.6, 34%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mounika, Durgam
1
Reputation point
answered 2023-09-20T06:55:07.2+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(230.39999999999998, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
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…
![](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(163.2, 54%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
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?
asked 2023-09-19T07:59:23.8866667+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(60.8, 82%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rao, Mayank
20
Reputation points
accepted 2023-09-19T16:15:04.33+00:00
Rao, Mayank
20
Reputation points
asked 2023-09-17T22:10:26.2266667+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, 51%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIJ%3C/text%3E%3C/svg%3E)
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
asked 2023-09-16T23:19:15.72+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(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
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…
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…
asked 2020-10-15T14:09:43.287+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(41.6, 46%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
WMB853
6
Reputation points
commented 2023-09-18T20:23:08.5866667+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(265.6, 5%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
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 :…
asked 2023-09-14T20:18:25.22+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(0, 69%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
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…
asked 2023-09-15T16:28:42.2066667+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(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Peter Bishop
161
Reputation points
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
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…
asked 2023-08-04T01:52:36.57+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(96, 53%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
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…
asked 2023-08-09T14:54:40.2+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(92.8, 19%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
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
![](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(198.4, 88%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
LVS Raghu Vamsi
40
Reputation points
edited the question 2023-09-15T01:27:11.76+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(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
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…
asked 2020-10-07T10:41:41.68+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(22.400000000000002, 52%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Nicky
116
Reputation points
commented 2023-09-14T13:50:59.1266667+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(131.20000000000002, 68%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Claudia Cavalcante Pires
0
Reputation points