SQL Server Integration Services Automation

  • Vijaya Kumar Gulappa

    SSChasing Mays

    Points: 628

    Comments posted to this topic are about the item SQL Server Integration Services Automation

    Blog: Gulappa

  • ferigod

    Old Hand

    Points: 397

    unable to locate the automation file mentioned in the article

  • Nebojsa Ilic

    SSCommitted

    Points: 1733

    Can you put SP OthCalculateNextDate in separate box as ConCheckHoliday just to make it readable?

  • Pyay Nyein

    Mr or Mrs. 500

    Points: 565

    Yes, I can't find automation file mentioned in the article either, pls someone tell me where I can find the zip file.

    Thanks,

    Pyay

  • Christopher West

    Ten Centuries

    Points: 1209

    I don't understand, if this is a monthly process why not just schedule it to run every month?

  • Phil-94129

    SSC-Addicted

    Points: 482

    It appears that the author did not include a link to the "Automation" zip folder that contains the dbscript.sql, SSIS package, and extract files.

    These would be helpfull in order to work through the examples in the article.

    Thanks

  • Vijaya Kumar Gulappa

    SSChasing Mays

    Points: 628

    For all members:

    There are two issues need to be corrected by SSC team.

    1. I had provided automation.zip folder. SSC team has forgotten to upload the same. I will follow-up with SSC team to upload the file now.

    2. I will ask SSC team to store the SP OthCalculateNextDate in a separate box as ConCheckHoliday

    Thank you for your comments

    Blog: Gulappa

  • ferigod

    Old Hand

    Points: 397

    No such thing as a mistake - its called deployment testing....

  • Phil-94129

    SSC-Addicted

    Points: 482

    Thanks for having SSC get the file attached to the article.

  • Vijaya Kumar Gulappa

    SSChasing Mays

    Points: 628

    For all members:

    The enclosed two issued have been resolved by SSC team.

    1. Uploaded automation.zip folder.

    2. Store SP OthCalculateNextDate in a separate box

    You can use the example along with an article now.

    Blog: Gulappa

  • Michael F. Udrow

    SSC Rookie

    Points: 48

    Thank you very much for your post - it coincidentally occurs at the same time as a major project that is very much an analog to it has been handed over to me for maintenance and execution. Your post will be my late night reading for the next few days. Thanks again - it was fortuitous to come across your posting. Mike 🙂

  • Alex Diaz-329446

    SSC Enthusiast

    Points: 153

    Because of this:

    The user requirement is described as follows:

    1. Client gets extracts from five different source systems (.txt, .csv and .xls file) every month on different weekdays.

  • Alex Diaz-329446

    SSC Enthusiast

    Points: 153

    Christopher West (10/30/2007)


    I don't understand, if this is a monthly process why not just schedule it to run every month?

    Because of this:

    The user requirement is described as follows:

    1. Client gets extracts from five different source systems (.txt, .csv and .xls file) every month on different weekdays.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714316

    The issues with the ZIP file were the editor's (my) fault. They have been corrected and my apologies.

  • Jwalant Natvarlal Soneji

    SSC-Addicted

    Points: 481

    It is a great article! :Wow:

    Thanks for sharing a bunch of knowledge.

    On my part, I would like to know that how much time the whole process took you to complete?

    I know that it depends upon many factors, but suppose you are ready with the requirement then what the time will be.

    I liked the way of scheduling, however this is the first time I have come across any job scheduling defined from database.

    Thanks.

Viewing 15 posts - 1 through 15 (of 18 total)

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