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 - 2004-01-06 : 08:20:00
|
| H writes "Have a DTS package that finds the next file to process in a directory. File to import is TEXT TAB DELIMITED, target is a SQL stage table. File has two different types of records; R1 will have columns 1 thru 7; R2 has columns 1 thru 20.If a straight transformation task is created, and the file has only R1 records, the package fails because it can't find the remaining columns/data elements. If the file has a mix (R1 & R2), the R1 records load fine. All columns in the stage table are NULLable, but that isn't the problem, as it the error says it can't find the source column; not problems with storing...Very critical process, and I can't get this "thang" to work; any advice?" |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-01-06 : 09:50:48
|
| DTS is very strict. You must figure out which file type it is, R2 or R1 and import accordingly.If you cannot do this, import each line as an undelimited row of text, then do the parsing inside SQL. |
 |
|
|
|
|
|
DTS Import - Variable Length Records