SEO

#1 (**permalink**) 02-28-2008, 07:43 PM

I have created a DTS that imports a text file to by data table. I get
errors when ever I run this since there are fields in the table that
are numeric. I understand that I need to create an activeX script to
import those fields. DOes anyone have any guidance?

#2 (**permalink**) 02-28-2008, 07:43 PM

Service,
My suggestion is not to import data directly into a production table.
Instead, import it into a temp table, which is made up of all varchar
fields. Then, call a stored procedure (as the next step in your DTS
package) to massage the data, do error checking on the data, and then do
inserts into your production data. You get much more control this way.
And, if your DTS package fails on the import, you haven't compromised your
production data.
Also, you may want to take a look at our videos on DTS packages as
www.TechnicalVideos.net. There is an example in there that does just that,
plus lots of performance and optimization tweaks for SQL Server 2000.
Hope this helps.
Best regards,
Chuck Conover
www.TechnicalVideos.net

"Service Tech" <naughtonservice@yahoo.com> wrote in message
news:b37bc818.0401270721.6d425d57@posting.google.c om...
> I have created a DTS that imports a text file to by data table. I get
> errors when ever I run this since there are fields in the table that
> are numeric. I understand that I need to create an activeX script to
> import those fields. DOes anyone have any guidance?

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

SEO

DTS Import of a text file