20. September 2006

Integration Services Microsoft and Flat files

I had a strange experience yesterday: I tried to get a flatfile into a database. I used dts on sql server 2000 before and i am forced to use the new platform 2005 now. So, learning new things can be a challenge and is basically good.

But one annoying thing to learn was, that a flatfile on integration services determines now the width of the columns, even in a delimited file. If columns exceed the presetted widths, errors occor. This would be no problem, if the message would have brought me near to the problem...

Keine Kommentare: