Automating sql scripts

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  November 23, 2004 at 3:09 pm

  #60447

  Hi,

  I was trying to automate our dataload procedure, so that it will use DTS packages instead of sql scripts. We will load the data every week. We have written some stored procedures for loading the data. One of the stored procedures check whether the data exists for one week. If it is, then it will return zero else it will return some other number. I have to continue loading the data only if the value is zero. how can I achieve this using DTS? One more question is we have several stored procedures(which will contain select statements) which will return data. Based on that data, we will decide whether we need to continue or not. Is there a way to check the data? for example, suppose a select statement returns 10 rows. We need to be able to display the data while running the package and it should have buttons like continue and cancel. and we will get the date when the data was loaded. If it is not what we expected we need to cancel the execution of package else we need to continue. How can I do that?

  Thanks,

  Sridhar!!

• Johan Bijnens

  SSC Guru

  Points: 135314

  More actions

  November 24, 2004 at 12:44 am

  #531345

  check out http://www.sqldts.com.

  There are a number of scenario's that may apply.

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me