Doing the same without DTS/SSIS


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!!
 
Ad

Advertisements

M

Mythran

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.

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
 
S

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!!
 
E

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!
 
Ad

Advertisements

M

Mythran

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top