MS SQL Server, ------*********$$$$$$$ SQL Text IMPORT HELP !!!! $$$$$$*******------------

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

Author	Message
Humberto Ramire #1 / 2	------*******$$$$$$$ 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

John Bel #2 / 2	------*******$$$$$$$ 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

Page 1 of 1

[ 2 post ]