June 6, 2005 at 10:28 pm
Hi
I am having a typical problem while creating DTS. I am unable to create transformations for the selected columns.
I am getting an error as follows,
DTS Design Error...
To continue, define transformations. You can make changes to the default transformations.
Can any body help me?
thanks in advance.
Vyas
June 8, 2005 at 5:45 pm
Can you give some more detail about what you're trying to do? What's your source and destination? Does the destination exist?
I've only seen that message when I've tried to create a Transform Data Task without defining transformations.
Greg
Greg
February 6, 2006 at 8:26 am
Any solution to this problem yet??? Im having the same problem today, and have had it in the past. This seems to be a "bug". A couple of thing to look at:
1) If using a query, try "shortening" the logic, the problem seems to be cause by too many lines the query window.
2) I can't remember how I did it, but some how I was able to make it work based on the order that I did things.
If you find a solution, post it here I'm watching this problem.
Curtis Smith
SQL Server DBA
Well in worked in Theory ...
February 6, 2006 at 8:38 am
found this is Google groups: someone was having same type of problem and said that SP4 corrected the problem.
814113 - FIX DTS Designer May Generate an Access Violation After You
Install SQL Server 2000 SP3
http://support.microsoft.com/default.aspx?scid=KB;EN-US;814113
--
Here is url for the Google Group Post.
Let me know if this corrects the problem, I cannot download, until tonight.
Curtis Smith
SQL Server DBA
Well in worked in Theory ...
February 6, 2006 at 9:58 am
found a copy of SP4. It fixed this problem.
Curtis Smith
SQL Server DBA
Well in worked in Theory ...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply