Another question on Data Flow Data Source

Question

I'm retrieving data from a server which is running a 32 bit version of SQL Server 2005 and the ADO.NET Datasource performs much better than OLE DB Data Source did.

I'm using an OLE DB Command to then insert data into a database on a different SQL Server 2005 which is 64 bit.

Does an ADO.NET Data Source work better with a 32 bit version of SQL Server 2005 than OLE DB Datasource, or does this have nothing to do with the performance?

Thanks

Answer 1

Yes OLE DB Datasource performance is good and faster in 64Bit environment.

---

Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

Answer 2

OLE DB works well on 32 and 64 bit servers when Fast-Load option is selected.

Answer 3

Fedor,

Is Fast-Load available when using a SQL Command, or just when using table I can't remember at the moment, but I have to use a SQL Comand.

Thanks

Answer 4

Fedor,

Is Fast-Load available when using a SQL Command, or just when using table I can't remember at the moment, but I have to use a SQL Comand.

Thanks

Only available in Destination:

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 5

Maybe that's why OLE DB Command is working fine on my destination. My destination is 64 bit, but my source is 32 bit.