I copied existing DTS package , DB from production server to local machine to add some columns in the table . I change the columns and i imported data into .csv file. I gave newly created file as destination. Then i change the database connection in the existing package and also change the destination path too. And when i open the transfermation task , it shows source columns but it is not showing any destination column.So i can't map. If i click define column button , my sql server is closed automatically.
Please let me know how to fix this issue.
In SQL 2000 DTS, the destination columns should be the 2nd of 5 tabs of the transformation task.