import data

#1

Yes, format will not be an issue. The DAT files contain
valid data for the table I want to create. Say, I have
ten files that I want to loop thru the directory where
they reside and load the table. The article is helpful,
but can you scale this example down to just ten files to
keep it simple?

#2

It will scale from 1 - 100,000.

I have used on a vast array of numbers in between those figures

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

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

Quote:

Yes, format will not be an issue. The DAT files contain
valid data for the table I want to create. Say, I have
ten files that I want to loop thru the directory where
they reside and load the table. The article is helpful,
but can you scale this example down to just ten files to
keep it simple?

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

import data

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

import data - 08-10-2004 , 03:07 PM

Re: import data - 08-10-2004 , 03:35 PM