Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS Script to read table

Author  Topic 

ldsanders2807
Starting Member

1 Post

Posted - 2011-04-27 : 09:52:56
I realize this will be a simple process, but have been unable to find an example to do this.

Using an SSIS script component, what is the code (including required references) to do the following:

1. Retrieve a single column from an SQL table.
2. Set ScriptResults.Failure if column value is != 0;
3. Set ScriptResults.Success if column value is = 0;

Thanks!

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-04-27 : 10:17:54
As an approach:
http://wannabesoftwareengineer.blogspot.com/2009/04/decision-making-in-ssis-depending-on.html

Otherwise you can search for "SSIS decision" and you will find much more answers.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -