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....
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...
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?
...
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...
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 ...
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...