Active x Script for data copy from source to destination -- sql server dts

desperate
1/30/2004 10:53:48 AM

Hello,
I'm dumping data into the database by
1. FTP the text files from unix server to windows.

2. Load the data into the temp table and wrote the vb
script (if .. else..) to convert the dates and logical
values and numbers.

3. Load the data to the base table from the temp table
within sql server.

4. Loading about 2 million records with about 200 fields.

5. This is taking about 10 hours for each table.

SQL Gurus!! Could you please suggest me what can I do so
this would run much faster.
The step which does the active x script to dump data to
temp table takes long time.

Allan Mitchell
1/31/2004 7:38:26 AM

Point 1 is OK
BULK INSERT the files into temp table
Use TSQL CASE statement to do the maniuplation if you can. This will be
faster then the VBScript version

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

sql server dts : Active x Script for data copy from source to destination