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
0 answers

Runtime error in script task

We have a fully running database server, say serverA, whose data are refreshed daily. We want to duplicate this database on a different server, says serverB, so that we have a test environment. The databases has been restored to serverB. Like…
Krish
  • 319
  • 4
  • 19
0
votes
1 answer

Appending letters to Member ID filter

I'm pretty new to .net code. I was using C# code inside script task-SSIS I'm using bulk copy task to pull data from oracle to sql db based on MemberID. I have got member id column in table which is having all integer values.. Member ID ex:…
Koti Raavi
  • 300
  • 2
  • 13
0
votes
1 answer

rename excel sheet in SSIS using EPPlus

I have been trying to get the following simple code work, but it raises and exception on using (var excelPackage = new ExcelPackage(finfo)) string filepath = Convert.ToString(Dts.Variables["User::FileFullPath"].Value); if…
Phani
  • 796
  • 7
  • 21
0
votes
2 answers

Using SSIS Script task to read XML from variable object LoadXml fails

I have a SQL statement (SQL server 2014) that builds out XML formatted data. I am pulling this into an SSIS (2013) object variable. If I put the SQL into a data flow task to go into a text file, it works. BUT, no encoding header. Because of the size…
tracer
  • 45
  • 3
  • 12
0
votes
1 answer

C# DownloadFileTaskAsync not downloading nested zip file

Please help to a C# newbie, I'm trying to download zipped files from HTTPS site with Script task in SSIS. Each "external" zip file contains "internal" zip file, that contains 3 txt files. After extensive search, i've enhanced the…
Nadya
  • 21
  • 2
0
votes
1 answer

Adding a reference assembly to script task and deploying

I'm working on an SSIS project which contains a single script task. The job of the script task is to upload a text file to a SharePoint site library. I'm using Microsft.SharePoint.Client and Microsoft.SharePoint.Runtime to achieve this. The code is…
bala
  • 436
  • 1
  • 4
  • 19
0
votes
1 answer

SSIS Script task storing DateTime in variable

I'm not sure why this happens, but my script task is not storing a DateTime-Value in a variable. This is the (till now) very basic code I've written: [Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute] public partial class…
R-Style
  • 25
  • 1
  • 5
0
votes
1 answer

SSIS ScriptTask Not Executing

I'm seeing some very strange behaviour when building and running a SSIS Package in Visual Studio: I have a Script Task that only executes when the containing DataFlow has no Predecessor or I have a break point in my script. If, the Script Task is…
TheJoeIaut
  • 1,522
  • 2
  • 26
  • 59
0
votes
1 answer

SSIS - DTS Script Task has encountered an exception in user code

I've had about 10 packages that have been running pretty much flawlessly for months. These packages utilize the same script task that I've basically copied across all the packages. All this script task does is send an email. I came in to work on…
Jon
  • 239
  • 4
  • 15
0
votes
0 answers

Add windows authentication functionality in C#

I am currently uploading document on sharepoint using ssis script task. Also I have a table where I am having user name and password from where the script task is fetching the same to login on sharepoint. My question is how to replace this with…
Ankit
  • 126
  • 1
  • 2
  • 8
0
votes
1 answer

How to stretch background image on Script task HTML Email (c#, HTML, CSS)

I have a script task that creates an HTML email and I can add a background image but I am having trouble getting the image to stretch to size. Everything I have read suggests using CSS but I am not very versed at HTML/CSS and even less sure of how…
user3486773
  • 1,174
  • 3
  • 25
  • 50
0
votes
1 answer

Converted c# datatable to HTML... how to add grid around the cells in HTML table?

So using the answer found on this link: Creating HTML from a DataTable using C# I successfully converted by datatable to HTML and it shows as a table in my email... I know there must be a place to put the style for adding grid lines around the cells…
user3486773
  • 1,174
  • 3
  • 25
  • 50
0
votes
1 answer

SSIS 2012 C# script task data source - No data for Rows

i am having an issue when trying to use a c# script task as a data source for a data flow task in SSIS 2012. I have a much larger query I am going to run, but for now I just wanted to prove out that this would work, but so far it won't. Below is the…
user3494110
  • 417
  • 2
  • 9
  • 25
0
votes
1 answer

After Deployment SQL Server does not allow folder / file creation within SSIS Script Task

I designed a SSIS package that ensures .CSV file generation into a destination folder using a Script Task component. Everything is ok when I run from the Visual Studio solution but the problems starts to appear right after deployment in SQL Server.…
0
votes
0 answers

How to read a specific string from a text file as output variable in SSIS?

I am downloading a webpage as a text file in order to read a specific string to assign it as a variable/parameter in order to create an output file name. I would like to know how would I be able to look for a specific string and output as another…
Julaayi
  • 403
  • 2
  • 8
  • 23