Data transfer from ODBC to Sql Server

My Vizai

Hi

Can Anybody tell me the different ways of transfering data from ODBC Layer to SQL Server using C#.

I want to transfer using Threads,means by running 4 threads, I need to transfer 4 tables at a time.

Though we have SQLBulk copy Object in .NET it's not useful in multi threader env.

Can anybody help me in this.

Rafael Salas


are you plannind to use SSIS this is a SSIS forum.

My Vizai

I don't know SSIS can u tell me about that plz

Thanks

vizai

Jamie Thomson

SSIS stands for SQL Server Integration Services. It is a tool for moving data from one place to another.

If you have never heard of it and you don't know what it is, why are you on this forum

-Jamie

My Vizai

Thanks Jamie.

Previsoly in Sql Server 2000 I used the DTS tool to transfer, No problem for me.

To learn abt SSIS I placed this thread in this forum.

Is learning a Crime

Hope you people will encourage us to learn more.

Jamie Thomson

There's nothing wrong with wanting to learn a new technology - I applaud that. I just got a little confused when you said "I don't know SSIS". Perhaps something got lost in translation.

Welcome to the SSIS forum. Lets hope you can solve your problem using this great new technology.

-Jamie

My Vizai

Thanks Jamie.

Yah, sure, I will.

Rafael Salas

As far as you have the right ODBC drivers, it should be straight forward to transfer data to SQL Server. You will need SSIS that is part of SQL Server 2005. If you have that installed, you need to create a project, then a package, then place a data flow task in the control flow. Once inside the data flow, use an Data reader to get data out of an ODBC source an OLE DB Destination to point to the SQL Server destination. BOL maybe a good place to start learning:

http://msdn2.microsoft.com/en-us/library/ms141091.aspx

My Vizai

Thanks Rafael,

But can we execute the package in C# program.

I want to transfer data using C# application(windows forms)

I need to see the status of each table while transfering data. Is it possible. Can u tell how.

Thanks in advacne

Duane Douglas

My Vizai wrote:

Thanks Rafael, But can we execute the package in C# program. I want to transfer data using C# application(windows forms) I need to see the status of each table while transfering data. Is it possible. Can u tell how. Thanks in advacne

I'm not 100% sure about this, but I believe that your C# application would need to handle SQL Server events that are fired while the data is being transfered.

My Vizai

Thanks for the reply Duane .

I'm also looking for that , how to .

Duane Douglas

My Vizai wrote:

Thanks for the reply Duane . I'm also looking for that , how to .

There are probably several ways to do it. One way is to implement a call back when a row is inserted. There would need to be a sql server trigger that fires each time a row is inserted. The call back would notify the client each time the trigger fires. Exactly how you would structure the call back is up to you to decide.

My Vizai

Hi Duane

Thanks alot for the reply.