I am having this question in my mind from when I started using SSIS.. In a package I have an OleDB source and a flat file destination. and I hook up the source to destination in SSIS and run the package.. it works .. fine.. but internally what is done does SSIS performs BCP out
SSIS Doubts
Hot Topic
- Execute a SSIS master package through an ASP.NET web app
- How can I get Transactional Republishing to work?
- Show multiple order records in single row
- XML Source Error
- Chart Colours
- Complex query involving multiple tables
- How can I assign a value to a textbox programmatically in a report?
- Using Service Broker for reliably transmitting events to consuming applications
- INNER JOIN Question
- schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportservices
SQL Server
- Connecting to hosted / remote database
- SSIS Script Component
- Help with Web Sync sql 2005 to sql express
- Problems running SQL Agent Jobs & SSIS Packages
- Setting Passwords In Connections Using Script Task
- Control of Parameter Field Layout
- New To Databasing
- Add a DateLoaded column to input data
- SqlServerSamples - SampleKey.snk
- Unable to read local eventlog (the parameter is incorrect)
SSIS Doubts
Swapna.N
fireparser
Going from OleDb to flat file it just reads the data. There is no Bulk option for reading data out of SQL, because it doesn't have to worry about page allocations, changes to indexes, triggers etc. Its just reading pages from memory/disk.
Going the other way it uses the BULK load operations as Jamie mentions. FYI these are available to developers in ADO.net 2.0
Wes Linz
Whoops. I misread the original question. Thanks for picking this up Simon!!
-Jamie
APFCClyde2
Because you get the power of transformation in the pipeline.
I forgot to say before, BULK LOAD is used if the fast-load option is selected in the OLE DB Destination.
-Jamie
krv5
It performs a BULK INSERT.
-Jamie