dbTalk Databases Forums  

Re: Validating input text file data to SQL Server table

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Re: Validating input text file data to SQL Server table

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


Discuss Re: Validating input text file data to SQL Server table in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Karthik Nagaraj
 
Posts: n/a

Default Re: Validating input text file data to SQL Server table - 07-11-2003 , 08:07 AM





Hello Elgar,

You could perform such checks using the activex script task.

K

"Elgar Esteban" <elgaresteban (AT) microsoft (DOT) com> wrote

Quote:
I have a text file (which comma delimited fields) which
need to be transformed to a specific SQL Table.

How can I validate if the text file rows are correct
(e.g., if the field columns are enclosed in double quotes,
etc) to ensure that the "schema" for that text file
columns is correct during processing.

Please help.

Thanks.



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top