I am experiencing a very odd DTS problem. Below is my sample DTS code:

1-New DTS
2-Create a SQL connection
3-Create a Text destination
4-Create a Transformation to move a table from SQL to Text – no transforms
5-On the source select an existing table
6-On the text file destination – I define c:\mytest.txt
7-Populate Columns from Source – hit execute (this is when it should show me what columns will be available) – sometimes won’t map columns

Here is the problem – on some of the developers machines – it will show the destinations columns and allow you to map the source and destination columns as it should – but on others the destination columns do not appear and therefore will not allow us to map them.

It seems to have different results on different machines indicating a possible service pack issue – but that’s not the case. We all have SQL2k, SP3 and our machines are same model Dell’s.

Since we can’t put pictures here – I put some screen shots together at:
http://northwestservices.biz/dtsproblem/index.htm

_________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200

__________________
_________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200

is your destination file created before hand? also check the account your using has the proper permission to the local or network drive.

This is the name of the M$ patch that corrected this problem:
SQL2000-KB815495-8.00.0818-ENU.exe


_________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200