March 17, 2011 at 2:31 pm
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.
March 17, 2011 at 2:36 pm
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.
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
March 17, 2011 at 3:09 pm
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...
March 18, 2011 at 1:23 am
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
March 18, 2011 at 2:54 pm
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.
March 21, 2011 at 1:04 am
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
March 23, 2011 at 12:42 am
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.
March 23, 2011 at 12:58 am
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