I always encounter problem while making connection from database to file. When I enter the destination tab (file), the window prompts "send error report" after I've pressed "Define Columns". It seems that it cannot map to the file format correctly. How to solve it? Thanks a lot.

Have you recently upgraded to SP3 on SQL Server 2000

http://support.microsoft.com/default...B;EN-US;814113

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"sbox" <anonymous (AT) discussions (DOT) microsoft.com> wrote

report" after I've pressed "Define Columns". It seems that it cannot map to
the file format correctly. How to solve it? Thanks a lot.

I've installed the sp already
I've found that without the select statement in the source tab, the error appears. If I put the select statement in the source tab, the error doesn't occur.