Stack Overflow
Stack Overflow

Questions tagged [script-component]

The Script component hosts a .NET script and enables the SSIS package to include and run custom script code. The Script component provides an easy and quick way to include custom functions in a data flow.

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

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

General Information

SSIS Script component is a prominent strength of SQL Server Integration Services since it allows developers to implement any complex logic and utilize libraries from the powerful .NET framework or third-parties.

Articles

168 questions
0
votes
1 answer

Converting a (XML)String to DT_NTEXT inside a SSIS Script Component

Hey there, I have quite an Issue with an huge string from a Json . I want to write it into a Nvarchar(max) Column using the Script Component. The OutputColumn is set to DT_NTEXT and I am…
smotorious
  • 45
  • 4
0
votes
0 answers

SSIS- Cannot Create user component - Component Entry Point Attribute

I created a Data flow task, with a simple flow inside. The script component type is destination. First I look for some data from my database, then I transform it, and finally insert it to my CRM database. I'am using Microsoft.Xrm sdks. Here is the…
sadzag
  • 73
  • 8
0
votes
0 answers

SSIS - Batch execution in script task

I need to run a particular action in Dynamics 365 for every record that gets created in a entity. i'm able to do it via script component(in C#). The problem is script component opens CRM connection, executes a action and closes the connection for…
Ramu
  • 343
  • 1
  • 6
  • 21
0
votes
1 answer

How modify datatable in C#

I am new beginner in SSIS, I am taking data from excel source. Excel source has columns like A,B,C,D,E,F. I created datatable1 and datatable1 contains columns A,C,D. Now I want to create datatable2 from remaining columns from sheet which are not in…
jackhelsi
  • 149
  • 1
  • 2
  • 10
0
votes
1 answer

Converting DATETIME(Date Time) to Quarter(int) SSIS

I need to convert datetime to Quarter. I have date time as the date type - 2009-01-01 00:00:00.000 how do I convert this 01 to Quarter "1" for example?
user13739771
  • 21
  • 4
0
votes
1 answer

to generate a xml file from csv ussing c# in ssis script component

I have a csv file data of automobile insurance records which i need to convert into a xml file using ssis. Now , when I have unique insurance numbers in csv then i can generate the xml file in the required format but there are multiple occurrences…
Urvi Jain
  • 1
  • 1
  • 1
0
votes
3 answers

SSIS: Remove Empty Row from outputbuffer

I have an error on a data flow task. i have an ado.net source going to an async script component. the problem comes at the very end of the insert from the script component to the destination where it tries to put the empty row it automatically…
Jai
  • 33
  • 2
  • 4
0
votes
0 answers

i want to pass 10 records together as a list as an input to script component in SSIS

In a dataflowtask , i add a source which reads the ID from a Table. then I call a Scrip Component which calls a REST api and processes and the output is sent to a Destination. I want to take 10 records from the source at a time to a script…
user3782554
  • 31
  • 6
0
votes
1 answer

Same filename with different columns on each loop

I have a foreach loop that looks up the same filename but for each pass, the file gets populated differently with different columns. My flatfile source throws an error when it tries to read the new rebuilt file - Im kinda expecting that my recordset…
CodeMonkey217
  • 1
0
votes
0 answers

SSIS Package Flat File destination

Overview: I am running SSIS package to copy data from SQL Server 2016 to Flat file pipe delimited with quoted identifiers and handling escape sequences. I am using Script component in Data flow task as source to write data to flat file as I have to…
BIDeveloper
  • 767
  • 3
  • 14
  • 28
0
votes
1 answer

ssis replace null with empty string

I am using conditional split on SSIS and I am getting errors as some of the rows contain NULL values. I know this can be changed by using the Derived Column and the REPLACENULL function. However, my table has about 200 columns and this would be very…
theJ
  • 395
  • 5
  • 25
0
votes
1 answer

SSIS Script Component Destination- split table data to multiple files

I am using a data flow task to connect to oledb source and run sql code which produces millions of rows. Each row is an xml content there is only one column (nvarchar(max)). I connect this to a script component destination, the reason being when…
sab
  • 338
  • 1
  • 3
  • 21
0
votes
1 answer

SSIS Asynchronous Transformation keep the previous column value and set to the next line

Just encounter an issue when using Asynchronous Transformation in SSIS. For simplifier the question, lets say I just have two outputs, "Name" and "Id". My C# code is: string name = ""; string Id = ""; if(...) // read the first line to get Name…
LONG
  • 4,490
  • 2
  • 17
  • 35
0
votes
2 answers

SSIS Script Component Input0Buffer method no GetName()?

I am looking for a way to obtain my property names in a SSIS data flow task Script Component. I have been searching high and low only finding this. I have been trying to get this code to work, but I am too novice to understand what is happening…
Clint
  • 89
  • 13
0
votes
2 answers

How do I specify EOF in SSIS VBScript?

What is the syntax for reading until the end of file in SSIS VBScript? Dim readFile As FileInfo = New FileInfo(logHourlyName) If readFile.Exists() Then Dim textStream As StreamReader = readFile.OpenText() Dim strLine As String Do While Not…
thursdaysgeek
  • 7,696
  • 20
  • 78
  • 115
1 2 3
…
11 12