Doing the same without DTS/SSIS

[Enric]

Hi all of you,
Primary platform is XP and NET 2.0 (VB)
In order to load plain files I've always used dts or ssis packages but now I
have to do that but using classes. Let me know how do I such thing.
It's a big file with loads of fields and as destination, a sql server table.
I know FSO objects but it was VS 6.0
Thanks a lot!!

 

[Mythran]

Hi all of you,
Primary platform is XP and NET 2.0 (VB)
In order to load plain files I've always used dts or ssis packages but now
I
have to do that but using classes. Let me know how do I such thing.
It's a big file with loads of fields and as destination, a sql server
table.
I know FSO objects but it was VS 6.0
Thanks a lot!!

--
This code and information are provided "as is" without warranty of any
kind.
Please post statements as well as any error message in order to understand
better your request.

Sounds like a job for the bcp utility. Can you use command line tools in
your application (of course you can from a development point of view, but
will it fit into your requirements)? If so, look up BCP tool for SQL
Server.

HTH,
Mythran

 

[sheik]

Hi all of you,
Primary platform is XP and NET 2.0 (VB)
In order to load plain files I've always used dts or ssis packages but now I
have to do that but using classes. Let me know how do I such thing.
It's a big file with loads of fields and as destination, a sql server table.
I know FSO objects but it was VS 6.0
Thanks a lot!!

 

[Enric]

Hi Mythran,
No, I can't because end users working in a financing shell and security is
very important and its desktops are totally closed. I'd need do that from the
code.
Thanks again!

 

[Mythran]

Hi all of you,
Primary platform is XP and NET 2.0 (VB)
In order to load plain files I've always used dts or ssis packages but now
I
have to do that but using classes. Let me know how do I such thing.
It's a big file with loads of fields and as destination, a sql server
table.
I know FSO objects but it was VS 6.0
Thanks a lot!!

--
This code and information are provided "as is" without warranty of any
kind.
Please post statements as well as any error message in order to understand
better your request.

Hmm, there is also a way to BULK INSERT (or bulk copy) from a text file
directly into SQL Server using T-SQL passed from your VB.Net application.
Take a look at BULK INSERT hits from Google....

HTH,
Mythran