Doing the same without DTS/SSIS

  • Thread starter Thread starter Enric
  • Start date Start date
E

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!!
 
Enric said:
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.
Click to expand...

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
 
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!!
Click to expand...
 
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!
 
Enric said:
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.
Click to expand...

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
 
Back
Top