script-component

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 EOF <--- what goes here? curLine = textStream.ReadLine() Loop textStream....

Reading System Variable from Script Component

What is the best way to read system variables from Script Component. Tried as below: Works fine when is User variable base.PreExecute(); IDTSVariables100 variables = null; VariableDispenser.LockForRead("System::ContainerStartTime"); VariableDispenser.GetVariables(out variables); auditTimeStamp = Convert.ToDateTime(v...

How to add rows using SSIS 2008 Script Component during transform?

I have a SSIS 2008 script component which is setup as a transform (so it has an input and output), and what I want to do is take 1 row in an input and optionally output multiple rows. In 2005 there was the AddRow and CreateNewOutputRows methods but those seem not to be available in 2008. So how do I add rows during the transformation? ...

Executing Stored Procedure for each InputRow + SSIS Script Component.

Hello, In my Script Component, am trying to execute Stored Procedure => which return multiple rows => of which need to generate output rows. Code as below: /* Microsoft SQL Server Integration Services Script Component * Write scripts using Microsoft Visual C# 2008. * ScriptMain is the entry point class of the script.*/ usin...

SSIS Lookup with Lookup Component Vs Script Component.

Hello, I need to load Dimensions from EDW Tables (which does maintain historical records) and is of type Key-Value-Parameter. My scenario is ok if got a record in EDW as below Key1 Key2 Code Value EffectiveDate EndDate CurrentFlag 100 555 01 AAA 2010-01-01 11.00.00 9999-12-31 ...

Abort processing of Row in ProcessInputRow method?

Is it possible to abort the processing of a row in the ProcessInputRow method? I'm doing some data validations with the incoming CSV data in this function. I'm setting the row values in a sub. If an error occurs i'll catch it in the ProcessInputRow and start writing the data into a staging table for a later approval. Everthing works fine...