How to see destination columns in DTS package ?
Posted on 2008-10-14
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.