Stack Overflow
Stack Overflow

Questions tagged [script-task]

The Script task provides code to perform functions that are not available in the built-in tasks and transformations that SQL Server Integration Services provides. The Script task can also combine functions in one script instead of using multiple tasks and transformations. You use the Script task for work that must be done once in a package (or once per enumerated object), instead than once per data row.

Do not use this tag for the SSIS Script Component, instead use .

Check the following article for more information: SSIS Script task vs. Script Component

Based on the official SSIS documentation, SSIS tasks are categorized as the following: Data Flow Task, data preparation tasks, workflow tasks, SQL Server tasks, Analysis Services tasks, maintenance tasks, custom tasks, and scripting tasks.

The SSIS Script Task extends the package functionality by using scripts. It performs functions that are not provided by the standard Integration services tasks.

363 questions
0
votes
1 answer

SSIS connection Manager property SetValue

I'm trying to use a script task to set the username/password of a httpConnection connection, but I can't figure out how to do this. Current attempt: httpClient.Properties["ServerUserName"].SetValue(httpClient.Properties["ServerUserName"],…
Tsaukpaetra
  • 579
  • 5
  • 26
0
votes
0 answers

Access DTS Variable outside Main() in SSIS

I have a variable assigned in my SSIS task. I want to access that variable inside a public static DataSet getDataSet() method in my Scriptmain.cs. basically the variable has a connection string for my sql server and i need to get some values from a…
Karthik Venkatraman
  • 1,619
  • 4
  • 25
  • 55
0
votes
1 answer

Load XML data without XSL into sql table using ssis script task

I have a xml data that do not have xslt associated with it. Its an auto generated xml provided by my client. below is the sample of the xml document. HTTP/1.1 200 OK Content-Length: 47033212 Content-Type: application/xml; charset=utf-8 Server:…
Karthik Venkatraman
  • 1,619
  • 4
  • 25
  • 55
0
votes
1 answer

Modifying an ArrayList in Javascript results in serialization failure in Camunda

I created a BPMN Collaboration model with a Script-Task of type Javascript in it. Then I instantiated a process instance with a process variable like so: Variable name: arr Object type name: java.util.ArrayList Serialization Data Format:…
Mehran
  • 15,593
  • 27
  • 122
  • 221
0
votes
1 answer

How to work with serialized variables in a Javascript Script-Task in Camunda

Consider having a process variable like this: Object type name: java.util.ArrayList Serialization Data Format: application/x-java-serialized-object Value: [{"id": 1, "name": "John"}, {"id": 2, "name": "Jane"] I'm trying to write a Javascript within…
Mehran
  • 15,593
  • 27
  • 122
  • 221
0
votes
1 answer

ssis script task dropping records

A tale of two cities almost...I have 17,000 rows of data that come in as a pair of strings in 2 columns. There are always 5 item numbers and 5 Item Unit counts per row (unit counts are always 4 characters). They have to match up unit and item or…
Tate Antrim
  • 9
  • 4
0
votes
1 answer

SSIS FTP file name and file sizes list

We use the FTP task in SSIS to download about 500 files from an FTP server, with the biggest file about 2 Gigabytes in size. The download fails 50% of the time. We would like to implement a step in our SSIS package that would retrieve the list of…
John W. Mnisi
  • 845
  • 2
  • 11
  • 16
0
votes
0 answers

Copy and Rename File VB Script Not Working For SSIS Script Task

I am dynamically creating reports using an Excel Template for an SSIS Package. I am attempting to copy the Excel template and rename it using VB 2010 in Script Task object. The following is my code: Public Sub Main() Dim sourcePath As String…
J.S. Orris
  • 4,653
  • 12
  • 49
  • 89
0
votes
1 answer

Logging the list of files from Script Task to SQL table

I have a list of files from a local folder in a SSIS Script task and I need to log it to a SQL table. Is there any way that I can do it directly from the script task or may be put the results in a object variable and then populate that to a SQL…
Prakazz
  • 421
  • 1
  • 8
  • 21
0
votes
0 answers

FTP Connection from SSIS Script task

I am trying to download files from an FTP server using a SSIS Script task, I am using the class 'ftpClientConnection' class and in it tried using the 'ReceiveFiles' method to download files from the FTP location to my local folder. But I am getting…
Prakazz
  • 421
  • 1
  • 8
  • 21
0
votes
0 answers

inserting data from REST webservice into database using SSIS

I want to pull JSON data from REST webservice and insert it into SQL Server database using Script task in SQL Server Integration Services. Anyone knows a step by step tutorials or where to start looking to achieve this task. Thanks in advance.
Mo T
  • 440
  • 2
  • 9
  • 30
0
votes
0 answers

Enable non-signed references in SSIS Task Script

As far as i Know SSIS references has to be strong name (signed). The question is: Can I change SSIS preferences to allow using references to unsigned assembly ? Regards, Tom
Tomasz
  • 23
  • 3
0
votes
0 answers

SSIS: Try/Catch not working in Script Transformation

I have spent last few hours to figure out whats wrong with my script transformation. I have SSIS that is used to load data from flat files to db. this data is very messy, variable column count, from time to time there is e.g. blank line. So I have…
bazinac
  • 668
  • 5
  • 22
0
votes
1 answer

Cannot connect to data source SSIS script task

I cannot seem to connect to the database connection i have set up in the SSIS package inside a script task. Here is my code it is a OleDB connection. public void Main() { // TODO: Add your code here OleDbConnection…
psycho
  • 1,539
  • 4
  • 20
  • 36
0
votes
1 answer

unable to send images using html email in script task in ssis

I have a package where I send out email with a picture inline. I am using html formatting for that inside the script task in the package. The problem is, when I put my alias as the recipient, I am getting the expected email. With image and font.…
karun_r
  • 183
  • 1
  • 2
  • 14
1 2 3
…
24 25