I am experiencing a very odd DTS problem. Below is my sample DTS code:
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:
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200