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