Content
Send email in SSIS
How to configure the package when the data has been loaded successfully, send the emails to the workers?

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.

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…

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…
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…
Oledb Destination trying to connect to all schemas
SSIS oledb connection error
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
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…
Cases assigned to me
When we uninstall an unused SQL Server from our environment, is there any technical impact on the server side?

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

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…

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…
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 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…
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
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…

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…

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…
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…