July 21, 2003 at 11:19 am
I have a package that transforms data out to a text file. It works fine, but now that I want to modify the transformations I can't get to them through Designer as normal.
When I click on the Transform Data Task and then Destination, the columns and hence the transforms don't show (The destination file definitely exists - it's re-created fine each time the pkg runs). Apparently Designer doesn't see the file. If I then click on Define Columns, Designer and EM close completely, with no error message. It's not the package - I tried recreating a basic transform from scratch and got the same result.
As it happens, I recently upgraded this server to SP3A. I had delayed because I had heard concerns about SP3 and DTS, so I had previously just installed the Critical Updates.
Maybe it's not SP3, but I just copied the package via structured file over to another server without SP3 and I can now see the columns. So, I might be able to modify my transforms on server2 and then copy it back, but that's a pain.
Any thoughts on how to fix this?
Thanks.
July 21, 2003 at 3:53 pm
Problem solved after reading ghicks1's post re:MS Knowledge Base Article 814113.
Downloaded/installed the fix and now it works.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply