System DSN

#1

Hi all,
I ll make a DTS pacakge. My package delete my table, then copy an excel file in it.
When I try to make the samething with a System DNS (because i must manupulate lots of excel files), it s wrong and i ve got error 0x80040e4e. Someone can help me?

#2

Hi

You should not need a DSN to access an excel file!

The file name for the connection can be changed as in:
http://www.sqldts.com/default.aspx?200

And you can loop around all files in a directory such as:
http://www.sqldts.com/default.aspx?246

John

"Manuel" <Manuel (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi all,
I ll make a DTS pacakge. My package delete my table, then copy an excel
file in it.
When I try to make the samething with a System DNS (because i must
manupulate lots of excel files), it s wrong and i ve got error 0x80040e4e.

Someone can help me?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

System DSN

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

System DSN - 06-22-2004 , 04:52 AM

Re: System DSN - 06-22-2004 , 05:07 AM