sql command in oledb destination

  • Can anyone please let me know how to use sql command in oledb destination in ssis 2005.

    I need to write insert statement in sql command for the data coming in oledb source.

  • amittheming (3/17/2011)


    Can anyone please let me know how to use sql command in oledb destination in ssis 2005.

    I need to write insert statement in sql command for the data coming in oledb source.

    Not quite sure what you're getting at here. OLEDB destination IS an insert command, just tell it which table/view to aim at and map the columns.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • I am getting column a,b,c from access database in oledb source and now I want to insert this data into oledb destination using sql command mode.

    I have a table create with a,b,c column in sql database.

    how can I used /write sql command in oledb destination?

    Hope this helps...

  • Why would you want to do it in SQL mode?

    If you just select the table name in the destination database together with the fast load option, you can just map the columns and you're set.

    And it will go a heck of a lot faster than a manually written insert statement.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • first of all the out of my curiosity because if option is there then I should be able to use it.

    second I need to append data in same table so if ran the data flow task again it will delete all the old record which do not want.

  • amittheming (3/18/2011)


    first of all the out of my curiosity because if option is there then I should be able to use it.

    There is also an ejection seat in jet fighers, but they mostly don't use it 😉 😀

    I understand your point, but unfortunately I cannot help you with it, as I have never used it myself.

    amittheming (3/18/2011)

    second I need to append data in same table so if ran the data flow task again it will delete all the old record which do not want.

    You can incorporate logic in the dataflow itself to check if rows are already inserted or not. You can use the lookup component and the conditional split for that purpose.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • SQL could be used in OLEDB command transformation inside data flow and at present there are no options for using query in OLEDB Destination component.

  • Apparently Gurusamy is half right. There is an option for SQL Command in the OLE DB Destination, SSIS just doesn't use it:

    http://jessicammoss.blogspot.com/2009/02/ssis-insert-statement-using-ole-db.html

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 8 posts - 1 through 8 (of 8 total)

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