Post reply

Automation

  • October 26, 2010 at 11:22 am

    #147395

    I am moving data from svrA.db.dbo.tabname to svrB.db.dbo.tabname and using the data pump with ole db source to old db destination. It works great, but basically I need to go thru and do this for many tables.

    How can you automate with SSIS? I'm used to DTS where you could save it out in VB? What are the different ways you can do this with SSIS?

    I'm getting tired of unhooking the OLE Destination object and inserting a new table, remapping, etc.

    Thx...

  • October 26, 2010 at 11:40 am

    #1242468

    In the control flow, there's a task for copying database objects. That might be a better option for you.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 26, 2010 at 12:11 pm

    #1242489

    I need to be able to control batch and commti size as these are massive tables. If I know what you're talking about, these don't have that capability.

    I think I might be able to use parameters? I am about to read on that...

  • October 26, 2010 at 12:15 pm

    #1242491

    Whisper9999 (10/26/2010)

    I need to be able to control batch and commti size as these are massive tables. ...

    Looks like you'll have to use a data flow for each tables. You cannot dynamically reconfigure the data flow for each table.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 26, 2010 at 12:30 pm

    #1242496

    I want my refund.

    Just kidding...

  • October 26, 2010 at 12:33 pm

    #1242499

    Whisper9999 (10/26/2010)

    I want my refund.

    Just kidding...

    Got a Paypal account? 😛


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 26, 2010 at 10:09 pm

    #1242643

    You may also implement a ST using SMO

    Raunak J

  • October 26, 2010 at 10:55 pm

    #1242653

    Raunak Jhawar (10/26/2010)

    You may also implement a ST using SMO

    Sorry - what's an ST?

    Remember I need to do a bulk operation, i.e. I need to be able to send things in small batches as these tables are between 20 and 60 G each.

  • October 27, 2010 at 4:33 am

    #1242754

    ST=Script Task

    You owe me 50 bucks...just kidding;-)

    Raunak J

  • October 27, 2010 at 8:28 am

    #1242929

    Thanks - much appreciated - and I'll check it out...

Viewing 10 posts - 1 through 9 (of 9 total)

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