March 18, 2011 at 9:35 pm
Have a script in VB, Where a particular folder is looped and most recent updated file is picked up, and now depending on this ( i mean, if a file "X"comes out of a loop) then the next Task in the package should excute otherwise disabled.
Needed help in calling this next task ... for details, this is the way it is mentioned in VB:
Set oPkg = DTSGlobalVariables.Parent
Set aStep = oPkg.Steps("DTSStep_DTSExecuteSQLTask_2")
.(looping folder starts.......... ...........
........................... will set the FoundFile = "Yes ", if i found the file. looping folder ends)
if (FoundFile = "N") Then
aStep.DisableStep = True
else
aStep.DisableStep = False
I don't know how to write this in C#, help needed plz
March 21, 2011 at 9:10 am
If you don't know how to write C# code then why do you want to convert this code to C#?
If you are serious about using C# as your chosen .NET language then it's time to hit the books. This is a basic script that you'll be able to easily handle after reading Chapter 1 of any C# programming book.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 21, 2011 at 9:19 am
I agree with all that, except that this looks like an ActiveX DTS script - is that correct? If it is, a straight rewrite in C# is a waste of time, because this logic probably won't work in SSIS.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 21, 2011 at 9:27 am
c# is not going to work in SSIS 2005.
March 21, 2011 at 9:30 am
In the SSIS you can't enable or disable a package like what we used to do using the vb script.you need to take a variable and assign the appropriate value and then use the control flow to execute the next task or not
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply