python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - script-task

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...
test-img

user4912134

c#

sql-server

ssis

sqlcommand

script-task

Votes: 0

Answers: 1

Latest Answer

Your primary issues is an extra comma in the SQL, which is a syntax error. It's probably easier to just pass the whole JSON to SQL Server and shred it using OPENJSON var result = await response.Conten...
test-img

Charlieface

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...
test-img

user4912134

c#

sql-server

ssis

script-task

Votes: 0

Answers: 1

Latest Answer

You can iterate res_JSON as below snippet sample code: dynamic res_JSON = JsonConvert.DeserializeObject(result); foreach (var jsonObj in res_JSON) { //Clear Parameter of sqlCmd sqlCmd.CommandT...
test-img

Aria

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.
test-img

arvind gova

azure

ssis

azure-keyvault

ssis-2012

script-task

Votes: 0

Answers: 1

Latest Answer

To Achieve the above requirements , You may refer the below workaround. Create an application ASP.NET MVC application. Create Azure keyvault secret for the database connection string. And give permi...
test-img

AjayKumarGhose

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 ...
test-img

ninja_md

xml

xslt

ssis

script-task

Votes: 0

Answers: 2

Latest Answer

Please try the following c#. It guaranties that XSLT's OutputSettings are taken into account. c# void Main() { const string SOURCEXMLFILE = @"e:\Temp\input.xml"; const string XSLTFILE ...
test-img

miriamka

Posts

Questions

Blogs

Jobs