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 |
|
sardinka
Posting Yak Master
142 Posts |
 Posted - 2005-06-08 : 12:03:57
|
| Is it possible in my DTS... before I am loading the file into my db to check if file is in correct format? I have a fixed file.Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-06-08 : 12:14:32
|
| What do you mean correct?What are the file specs?here's an idea...bcp the entire thing into a single varchar(8000) column...then use SUBSTRING to parse out the data to check it.Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
sardinka
Posting Yak Master
142 Posts |
Posted - 2005-06-08 : 14:56:29
|
| One day I have the perfect file and the next day I may have corrupted file. It is not under my control since the file provided by client. So before I run my DTS process I wanted to make sure that the file is right.Please let me know if my explanation is helps. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
sardinka
Posting Yak Master
142 Posts |
Posted - 2005-06-09 : 09:22:53
|
| I don't know what is the source.I just get a file. |
|
|
|
|
|
|
fixed width File error