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
-1
votes
1 answer

Add dummy single row into the first row of excel file in SSIS

I receive excel file every week. Suppose it has following columns: Cust_Name(string), Cust_Id(int), Cust_filename(string),description(string/Unicode string/ Unicode text stream), explanation(String/Unicode string/ Unicode text stream)..... I am…
Ichi
  • 1
  • 3
-1
votes
1 answer

How Can You Use JOIN Statement From Excel Source Data To SQL Server Data For New Data Set For Lookup In Data Flow Task of SSIS

I have an Excel Source that connected to a Lookup Transformation that is then connected to an OLE DB Command that holds a stored procedure to Insert my data into SQL Server. The following is the query I want within the Data Flow before the Lookup…
J.S. Orris
  • 4,653
  • 12
  • 49
  • 89
-1
votes
1 answer

SSIS script component. Value comparison then transformation

I'm trying to learn how to use script component. I'm trying to take a value, 'Gender', and then check to see whether it is "M" or "F". If it is M then change value to G and if F then change value to L. My input column is gender and my output…
crack3r
  • 49
  • 1
  • 5
1 2 3
…
11
12