Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-27 : 08:15:01
|
| yamuna writes "I have a problem in DTS.Well let me explain to you every day we have 2000 import file from different host systems for the reconcillation purpose we have to import to SQL server later we will use Visual basic and generate report in EXCEl Sheet this is the requirement.how to create DTS i.e source to destination in one strecth i should transfer all the 2000 files to 2000 tables in SQL server.how to maintain the different specification for different file format i.e should i create views or tables I really don't knowwhy i need specification to be maintanied why because for today if i get the file i can choose this specification(prediefined format created once)for tomarrow incomming files i can just delete the data and refill the new text data for the table.Can any body help me how to do this as i am in very urgent i.e dead line is nearing.Apart from DTS is there any techinque in Visual basic where the data transfer is fast.Many Many thanks for all of your help.regdsyamuna" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-27 : 19:52:14
|
| There are various articles on the site regarding BCP.You'll want to read those.Also if you still want to go the DTS route check out.www.sqldts.comIf the file format doesn't change then transformations will do the job what about file names will they remain the same everyday.What type of files? text,excel ??Whatever you do don't use VB to do this.If you need examples post a sample of a file and someone will show you how to bcp that into a stagging table.Edited by - ValterBorges on 05/27/2003 19:56:01 |
 |
|
|
|
|
|
DTS