HomeForum
Welcome, Guest
ETL-Forum
Forum
Advanced ETL Processor

Setting value as flag for success or failure
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Setting value as flag for success or failure

Setting value as flag for success or failure 1 year, 1 month ago #2243

  • Jennifer
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
I need a way to schedule the following into a package. I want to do a select sum on one column in a table. If the value is > 0; I want to set a failure. If the value is 0, I want to set a succeed. This is done in DTS via ActiveX component. How can I accomplish the same thing here?

Thanks,
Jennifer
Reply Quote

Re: Setting value as flag for success or failure 1 year, 1 month ago #2244

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Use SQL data check object

Mike
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Advanced ETL Processor
Powered by Kunena
Time to create page: 0.15 seconds

Testimonials

"Using Visual Importer ETL was a lot easier than we expected it to be, and had a lot more functionality than our other software."

Daniel Boel,
Information Technology Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC

Databases we work with

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top