All,

i have a folder which i need to import each files seperatley and then run
some administrative tasks / reports on each table.

my question is how can i use DTS import each file into thier own table?

any links or advise would be greatful.

Simon

What is a file? A text file or a DB2 file (aka Table)?

You can adapt either of these by referring to the following articles.

Looping, Importing and Archiving
(http://www.sqldts.com/Default.aspx?246)

How to loop through a global variable Rowset
(http://www.sqldts.com/Default.aspx?298)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"simon whale" <simon (AT) nospam (DOT) ukdatait.co.uk> wrote

Allan,

thank you for the links, i have tried to setup a test on this, so that i can
also understand what it is doing, but when i run the package i get the
following error on the DefinetheGVs ActiveX script.

Eror Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: ActiveX xomponent can't create object:
'scripting.FileSystemObject'

Error on line 26

this is from using the Looping, Importing and Archiving link from below.

i have looked this through on MSDN and the support site and all i found was
to do with the global variables, but the script is written in the way that
the resolution says.

Many thanks
Simon
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Somebody else had this problem in a previous thread unrelated to any
article.

What OS are you running ?

Try installing the latest version

http://www.microsoft.com/downloads/d...DisplayLang=en

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"simon whale" <simon (AT) nospam (DOT) ukdatait.co.uk> wrote

Allan,

thanks that seems to have solved that problem. now i get that there is a
bad directory location, but i see there is no reference to a directory
location. so my question is how do i assign a value to that global
variable?

many thanks
Simon

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Sorry Allan,

Have found where to input the global variables, many thanks for your time

Simon
"simon whale" <simon (AT) nospam (DOT) ukdatait.co.uk> wrote