Export SQL Data To OLEDB Destination

[Skittle]

I was quite surprised to find there is no OLEDB Destination connection option in SQL server 2005 data flows.
I can therfore read data from an external data source ( eg. Iseries/AS400 ) into SQL Server but I can't write it out.

I can code it in a VB.Net program but i would have expected BIDS to have this option.
I am missing an optiin somewhere?

Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.

 

[SQLScholar]

Yeah - i think you are missing something. I have just checked and i have an OLE DB Destination.

Also its on MSDN:

http://technet.microsoft.com/en-us/library/ms141237(v=sql.90).aspx

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[SQLScholar]

Sorry i meant BOL rather then MSDN.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[Skittle]

Yea its wierd. It just doesn't appear in the toolbox destinations.
On another server that is running SQL server 2012 with Visual Studio 2008 it exists as an option.


Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.