363 questions
0
votes
0
answers
88
views
How to execute multiple SSIS packages in parallel from a Script Task?
I have an SSIS master package with a Script Task that launches other packages.
Inside the Script Task, I load the package list into a DataTable and try to execute them in parallel using Parallel....
- 36
0
votes
0
answers
35
views
SSIS DtsDebugHost.exe automatically creates unnecessary bindingRedirects in the local DtsDebugHost.exe.config
I have:
Microsoft Visual Studio Community 2019, version 16.11.45.
SQL Server Integration Services (SSIS) Projects 4.6.
A project in SSIS with the target server version SQL Server 2019.
The problem is ...
0
votes
1
answer
44
views
SSIS - script task - if the date validation fails that OK
I have an SSIS package that has a script task that compares the date from a database table column and the date of a file on a network share. I'm using the following VB script in the script task. The &...
- 1,890
0
votes
0
answers
65
views
Date modified does not change when copying existing file using FileInfo
I am using SSIS script task to copy a file from source directory to destination directory.
It works well when:
a. The source file is new and it does not exist in destination.
b. The file exists in ...
- 1
0
votes
2
answers
120
views
ORA-01422 error thrown when executing a stored procedure from SSIS script task, however it executes successfully when run from SQL Developer
I am executing an Oracle stored procedure from SSIS script task and the package used to execute successfully without any issues. However, it started to fail with an ORA-01422 error suddenly.
There ...
- 1
0
votes
0
answers
44
views
Variable file path on csv import
I am importing a CSV file daily. The package currently runs as expected with the static path. The problem is that the name of the csv file changes daily so a static file path doesn't work. I basically ...
1
vote
1
answer
104
views
Cannot see the Solution Explorer References node in VSTA project
We are building SSIS applications in Visual Studio 2022. When editing an SSIS Script Task Visual Studio launches a VSTA project instance.
Normally the project will look something like this:
However, ...
- 946
0
votes
1
answer
258
views
How to access tables from two databases in one ADF Script?
I have two databases Employee and Employee_Archive, each one has a table 'dbo.Employee'.
I was planning to delete Employee.dbo.Employee if the records already in Employee_Archive.dbo.Employee.
I tried ...
- 400
0
votes
1
answer
309
views
Issue with HttpClient.SendAsync("...") in SSIS Script Task
I want to access the MS Graph API from inside my script task.
I didn't get the SDK to work (in SSIS at least) so I thought I would write my own class using the System.Net.Http HttpClient. Outside of ...
1
vote
0
answers
406
views
SSIS Script Task "Object reference not set to an instance of an object" When Executed from SQL Server Agent Job
I have a strange issue. I have an SSIS package that runs on a SQL Server Agent job. It intermittently fails with the error "Object reference not set to an instance of an object" and I can ...
- 11
0
votes
0
answers
85
views
XML Edit in SSIS using Script task
Trying to include element in an xml which already contains data. The File needs to be processed part of a ssis package to bring in information on the server. Example of the xml file structure - I have ...
0
votes
1
answer
177
views
Must declare the scalar variable "@ID" error, C#, SSIS, in Script task
This is driving me nuts. Probably it is something silly I can't see.
This is my code:
cnnDbLocal = new OleDbConnection(localDbStringConnection);
cnnDbLocal.Open();
string select = "INSERT INTO ...
- 47
0
votes
1
answer
305
views
SSIS Script Task not Executing
I have an SSIS script task package executing using SQL Server Agent Job.Initially I got the following error.
The application-specific permission settings do not grant Local Activation permission for ...
- 1,010
0
votes
0
answers
103
views
Enable to get bucket location, using default endpoint
I have a script task in SSIS 2008 which should upload data from S3 Bucket.
Now, I faced an issue and receive such error:
GetRegionCode - unable to get bucket location, using default endpoint:
s3.us-...
0
votes
0
answers
1k
views
Write a SSIS script task to get oauth2.0 bearer token from a Web API
I am trying to figure out a way to get oauth2.0 bearer token from the rest API.
So from Postman I can do a POST method for "https://helloworld.org:443/xyz/oauth2/token"
And in the body, I ...
- 87
0
votes
1
answer
390
views
SSIS Data Flow Task indicates it wrote x rows, and reported no errors, but none of the rows appear in destination
This package had worked in the past but, for whatever reason, hasn't been working as intended recently. The package has a script task that sets a file path variable to the file path for the most ...
- 153
0
votes
0
answers
44
views
Incorrect authentication data C# SSIS
I'm trying to send a list of missing products from a table through the mail. For that, I'm using a Script task in SSIS. I don't have any experience in C# as I'm an SQL developer. I don't know what's ...
0
votes
0
answers
60
views
Why SSIS Script is losing NuGet package and references after I close and reopen the script? [duplicate]
I have written a script in SSIS script task editor to read csv files using CsvHelper. While executing the package it is throwing the following error:
'Could not load file or assembly 'Microsoft.Bcl....
- 11
0
votes
0
answers
66
views
SSIS - How to write line by line into flat file using ForEach Loop Container
I need to get data from table and write it into flat file line-by-line.
Example File 1:
Alice ID ST-01
Alice Gender F
Alice Subject English 69
Alice Grade C
Alice Subject Mathematics 85
...
0
votes
0
answers
63
views
Script task component is not working without Visual studio
I have the packages in SSISDB catalog which is having script task component with C# code in it & I’m not having visual studio in that server.I’m trying to run the packages through Job but the ...
- 1
0
votes
1
answer
769
views
Visual Studio Will Not Edit Script Task
I've had trouble trying to get an Excel file to connect to this SSIS package so I've uninstalled and reinstalled VS2019, Integration Services, and Access Server 64bit a half dozen times.
This most ...
- 1,550
0
votes
1
answer
550
views
SSIS Script Component Does Not Recognize Dts.Variables Namespace
I want to read the rows inside a user object, but when I try to fill it to a DataTable, Dts.Variables is not a recognized namespace.
public override void PreExecute()
{
base.PreExecute();
...
- 4,653
0
votes
1
answer
306
views
SSIS Script Task - Count Number of Unique Rows in Output Object
My SSIS script task generates 5 rows of records into an Output script component.
if (conditionMeets)
{
WOProductBuffer.AddRow();
WOProductBuffer.WorkOrderId = workOrderId;
WOProductBuffer....
- 4,653
0
votes
1
answer
619
views
How to add values to System.Object Variable inside a foreach loop container with script task in SSIS?
I'm trying to add new values to a variable (System.Object) inside a foreach loop container that is using that variable. How can i do that ?
To understand my flow :
first script i'm adding a value to ...
- 13
0
votes
1
answer
1k
views
SSIS Script task fail, but works again when simply opening the script (no modification) and save it again. How come?
I'm developing SSIS packages on Visual Studio Community 2015 (version 14.0.25431.01 Update 3) with SSDT (version 14.0.61707.300) where I often use SSIS Script Tasks in C#.
My Packages are developed ...
- 176
0
votes
1
answer
1k
views
"Script Task" missing in SSIS Visual Studio 2019
My Visual Studio SSIS is missing the "Script Task" tool. There is only "Script Component" tool.
I tried to search google for this problem but there wasn't anyone who had ...
1
vote
0
answers
429
views
Service Principal Authentication method to connect to SQL MI server using SSIS - Script task - C# code
From last few days I am looking for solution-
I need to connect to Azure SQL MI server using service principal authentication through SSIS script task - C# code. I am using Microsoft.Data.SqlClient....
- 11
0
votes
1
answer
363
views
SSIS which having script task throwing "not enough memory resources" error
In one of my SSIS package giving error during the execution time. Package contains two script task which will run in parallel. From script task what I'm doing is that, getting some svg files from a ...
- 119
0
votes
1
answer
1k
views
SSIS Script task Call stored procedure with OleDB
In SSIS Script task how to execute a stored procedure using oledb connection.
- 119
0
votes
2
answers
421
views
How to create a database, table and Insert data into it and use it as a source in another data flow in SSIS?
I have a need to create a SQL database and a table and Insert data into the table from another SQL database . And also to use this newly created database as a oledb source in another dataflow in the ...
- 17
0
votes
0
answers
668
views
SSIS Script Task using client.GetAsync(url) not waiting for response
I have an API call using client.GetAsync(url) within a SSIS script task but for some reason its not waiting for response from API and jumping back to the entry point for the script task which is ...
- 770
0
votes
1
answer
707
views
SSIS: Need to Process an excel file in SSIS upto certain range until it finds a blank row
I have an excel file .xlsx which i will get from client and after certain rows data it will have a blank row and then a generic comment everytime and the starting work of that phrase will be same all ...
- 151
0
votes
0
answers
2k
views
Upload flat file to sharepoint via SSIS Script task
I need to modify numerous packages to deliver a flat file to a SharePoint. I've found this routine online to do it via C# in a script task but I am getting a "remote server returned an error &...
- 159
0
votes
1
answer
639
views
JSON post to the elastic API using C#
I have an elastic post API. To fetch the data from the post API I am using the below JSON code in the body section in postman.
{
"query": {
"bool": {
"should":...
- 25
0
votes
1
answer
153
views
Error at serializer Deserialize in C# code
I am trying to load the data from the API which consists of JSON data in C#. But I am getting an error when I am trying to serializer.Deserialize<Dictionary<string,string>[]> the data.
...
- 25
1
vote
1
answer
2k
views
Expression to check if a given string exist in a output of a script task in ADF
I get following result from my script task, How should I build expression to check if the result contains 'exceed'
{
"resultSetCount": 1,
"recordsAffected": 0,
"resultSets&...
- 87
1
vote
1
answer
721
views
Having issue running SSIS script task in Visual Studio with 2019 as target version
We are upgrading from Sqlserver 2012 to 2019 in that process we need to migrate our SSIS packages also from 2012 to 2019. We have lot of script task which uses connection string and other ...
- 11
0
votes
1
answer
225
views
SSIS Report: How to rename an excel file in a specific location
We get an excel file in a specific location where the name of the file may vary every time.
So every time we rename the excel file manually to "Report.xlsx" and then we have some operation ...
- 797
0
votes
1
answer
675
views
C# script to load data into SQL Server database doesn't work as expected
I am trying to query the APIs and insert the responses from it in to the SQL Server table using the script task. The script task is behaving in consistent that one time loads the data the other time ...
- 1,053
0
votes
0
answers
404
views
Script task in SSIS package is executing but not performing the action
I have the two SSIS packages which basically has two action like below
First it truncates the contents of the table and then it executes the script task like basically call an API and inserts the ...
- 1,053
0
votes
1
answer
134
views
Find missing files (dates) in folders using C# Script Task
I have some flat files with filename includes date in yyyyMMdd format. Here are some example:
Folder Path: C:\Source
FileNames:
myfile1_20220104983423.txt
myfile1_20220104983423.txt
...
- 369
0
votes
2
answers
2k
views
Script task output to check if condition
From the script task I get an output
{
"resultSetCount": 1,
"recordsAffected": 0,
"resultSets": [
{
"rowCount": 1,
"rows": [
{
"flag": 1
}
]
...
- 87
-2
votes
1
answer
1k
views
Unable to insert data from the JSON in to the SQL server table
I am trying to create a SSIS package that makes a call to the REST API and insert the responses into the Azure SQL server table. For this I am using the script task and ADO.NET connection manager. The ...
- 1,053
1
vote
1
answer
2k
views
Insert the response from the API in to SQL server table through SSIS script task
I am trying to create a SSIS package that makes a call to the REST API and insert the responses into the Azure SQL server table. For this I am using the script task and ADO.NET connection manager. The ...
- 1,053
0
votes
1
answer
2k
views
How to access Azure Key Vault Using SSIS Script Task?
Need to access Azure Key Vault using SSIS Script Task in C#, to assign the Azure SQL Connection String to Connection Manager in SSIS.
- 46
0
votes
2
answers
120
views
XslCompiledTransorm Transform marking Right Single Quotation as Invalid character in Encoding iso-8859-1/UTF-8
I am trying to generate a text file for each XML file from a third party system using SSIS package script task and XSLT. Sometimes few special characters appear in these XML files. One such character ...
- 173
1
vote
1
answer
568
views
Flat file formatting issue in SSIS
We receive a flat file that is delimited from our third-party client.
Row Delimiter = LF;
Column Delimiter = Tab
The file has 8 columns.
The delimited formatting in the file is correct for the most ...
- 21
1
vote
2
answers
2k
views
SSIS - Script Task find a string value in a file name
I have to build a job in SSIS to check if file with today's date exist then load data into targeted table.
My problem is I have different files stored with different dates in this folder with the ...
1
vote
0
answers
831
views
Script Task gives error 'One or more errors occurred.'
Whenever I try to create a Script Task in SSIS, it gives me the following error:
One or more errors occurred.
Even though I haven't done any changes in the script task and added no line of code. I ...
- 342
4
votes
1
answer
849
views
SSIS package fails to process all rows with C# Script task when started with SQL Server Agent
I have a requirement to build a SSIS package that sends HTML formatted emails and then saves the emails as tiff files. I have created a script task that processes the necessary records and then ...
- 61