------*********$$$$$$$ SQL Text IMPORT HELP !!!! $$$$$$*******------------ 
Author Message
 ------*********$$$$$$$ SQL Text IMPORT HELP !!!! $$$$$$*******------------

I was wondering if you could give some advice with this:
I periodically receive a text file, with fixed length
columns. There are no delimiters. I need to insert this
data into a database, performing several minor
modifications such as changing adding dashes to some
fields, date formats, etc., on-the-fly.

We are currently using SQL 2000 desktop edition
How do I set up a DTS or bpc package/T-SQL storedproc/VB
app that will
dynamically import this text file into a SQL Server table ?

This import must also be selective, I need setup a index
that includes 3 or 4 fields and only import new data that
is not on the table, when those 3 or 4 fields do not match.

I remember in FoxPro I can create a index of multiple
fields (index on field_a+field_b+field_c to IndexName)
can something like this be accomplished on SQL to ? I'm
sure, but I don't know how. Please help.

Thanks in advance

.



Tue, 27 Sep 2005 14:12:56 GMT
 ------*********$$$$$$$ SQL Text IMPORT HELP !!!! $$$$$$*******------------

Hi

Check out the following to use DTS
http://www.sqldts.com/default.aspx?6,107,276,7,1, there are other examples
on the site of how to modify the transformation so that they can be
formatted during the import. An alternative way would be to load this file
into a staging table and the use SQL to update a live table formatting the
data in the insert statement.

John


Quote:
> I was wondering if you could give some advice with this:
> I periodically receive a text file, with fixed length
> columns. There are no delimiters. I need to insert this
> data into a database, performing several minor
> modifications such as changing adding dashes to some
> fields, date formats, etc., on-the-fly.

> We are currently using SQL 2000 desktop edition
> How do I set up a DTS or bpc package/T-SQL storedproc/VB
> app that will
> dynamically import this text file into a SQL Server table ?

> This import must also be selective, I need setup a index
> that includes 3 or 4 fields and only import new data that
> is not on the table, when those 3 or 4 fields do not match.

> I remember in FoxPro I can create a index of multiple
> fields (index on field_a+field_b+field_c to IndexName)
> can something like this be accomplished on SQL to ? I'm
> sure, but I don't know how. Please help.

> Thanks in advance

> .



Thu, 29 Sep 2005 03:17:56 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ------*********$$$$$$$ SQL Text IMPORT HELP !!!! $$$$$$*******------------

2. ------*********$$$$$$$ SQL Text IMPORT HELP !!!! $$$$$$*******------------

3. Importing text from Text file- Help needed

4. Importing text files into SQL Server 2000 Database using DTS Import/Export Wizard

5. Help! Importing Text Data into SQL Server 7.0

6. Help importing text files into SQL tables

7. Help--Control DTS import text file to SQL Server 7

8. Import text file in SQL Server 6.5 via SQL in Visual Basic

9. Import text file in SQL Server 6.5 via SQL in Visual Basic

10. Import text file in SQL Server 6.5 via SQL in Visual Basic

11. DTS Import Error When Importing Text File

12. Help with DTS and ActiveX Script to import text file to a table


 
Powered by phpBB® Forum Software