Post reply

Running SQL tasks over and over again changing the year parameter each time

  • November 23, 2011 at 5:36 am

    #1412081

    Debbie Edwards (11/23/2011)

    Quick updaet,

    I tried and tried but failed to get it working. I really didnt understand the script stuff onm the last post but I nearly got it sorted using ? against the parameters in the loop.

    Unfortunately I was getting errors I didnt understand so i have had to ask the DBS to add the package 6 times changing the package parameters in the job.

    Thanks for all your help. Hopefully I will get another go at doing it at some point

    Debbie

    If you are going to be using SSIS frequently or if you think it will benefit your daily activities, I would strongly recommend that you get a good book or go for formal training. SSIS is a really powerful tool that can save you a lot of time when used in the right way.

    Getting to know it will take time and effort on your part, but it is definitely worth it.

    Martin.

  • November 23, 2011 at 5:43 am

    #1412082

    Absoloutely,

    Im really wanting to get it sorted but Ive been put on anothe project with a scary deadline so Hopefully that will just be a temporary solution until I can get back into it.

    Im pretty certain I was nearly there. Ill be fuming I didnt sort it until I can get my head in it again!

    🙂

    I will be scouring for some good books that just look at IS!

    Thanks for the advice

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply