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 |
|
lousueyesh
Starting Member
9 Posts |
 Posted - 2004-10-13 : 10:05:11
|
| Hi,I am using Winsol flat files in my database and I need to import the flat files into my MS SQL server to work with the data. I am currently using Providex 32-bit ODBC v3.02 as the driver but I cannot schedule for automatic imports because the DTS Import/Export Wizard fails when I schedule for automatic import of the flat files. I can successfully schedule for automatic import into MS Access using the providex driver, however, but not import into MS SQL server???I wonder if this is a driver issue? and How can I resolve that?Does anyone know a good driver to use in converting flat files to MS SQL tables???I hope someone can help me on that!!!Thanks,lousueyesh :confused: |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-10-13 : 11:04:30
|
| I don't suppose there is any way you could change the output so that it is comma delimited? (.csv)What kind of error's are you getting from the scheduled DTS?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
lousueyesh
Starting Member
9 Posts |
Posted - 2004-10-13 : 11:48:21
|
Hi Wanderer,Thank you for replying my post!Actually when I schedule the DTS for daily import of (Winsol) flat file, the import starts as scheduled but it doesn't stop and continues in executing mode for months even though the tables have been imported. This way, the daily scheduling function doesn't work and it will not update again the next day since its status continues to be 'Executing Job Step...' !!!I think the driver might not be the right one or does MS SQL server able to support flat file imports ???Do you or anyone know what other drivers out there (preferrably free) I can use to import and schedule for flat file imports???Thanks,lousueyeshquote:
Originally posted by Wanderer
I don't suppose there is any way you could change the output so that it is comma delimited? (.csv)What kind of error's are you getting from the scheduled DTS?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here!
|
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-10-13 : 12:13:44
|
| Hi lousueyesh,Well, DTS has access several drivers installed in the SQL install, amongst which there is one called "text file". You can then use the next page of the DTS wizard to define how to "read" your text file (fixed width, delimiter, etc.).To get back to your original problem - you say it "never ends". How many rows are you trying to insert. Are you trying to insert into a highly transacted table? Does you DTS package properly flow - perhaps some logic is leaving it "open" ?Is your DTS package a simple:1) Connect to text data source2) Transform text data into 3) SQL table?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
tuenty
Constraint Violating Yak Guru
278 Posts |
Posted - 2004-10-13 : 12:59:47
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=41250*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*A candle loses nothing by lighting another candle |
|
|
|
|
|
|
|
|
Importing Winsol (flat file) to MS SQL server