×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

DTS Pkg Designer Locks on Edit

DTS Pkg Designer Locks on Edit

DTS Pkg Designer Locks on Edit

(OP)
I have several legacy DTS packages which I am managing through the Package Designer add-in with SQL Server Management Studio.  I am able to edit Properties in these packages EXCEPT for the Properties of the main workflow step.  Attempting to do so causes the Package Designer to lock up, with my having to end the app through Windows Task Manager.

I have been unable to find any reference to this issue or a workaround.

Any thoughts or ideas as to the cause or solution would be greatly appreciated.

< M!ke >
I can say nothing, which is cowardly, I can lie, which is immoral, or I can tell the truth, which will upset people.  - Tiki Barber

RE: DTS Pkg Designer Locks on Edit

Hey Mike,

What do you mean by 'Main Workflow Step'?

I'm feeling dumber than usual today sad

Good Luck!

Alex

----signature below----
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom

RE: DTS Pkg Designer Locks on Edit

(OP)
Hi, Alex.  So you're feeling a bit Mike-ish?  Arrr!  Sorry to hear that.  winky smile

I can edit the Connection Properties for the Source database and the Connection Properties for the Destination database, but I can't edit the Transform Data Task Properties.  Data structure from the Source has changed and I need to change the mapping, but when I right click the Step and select Properties from the pop-up menu, the Package Designer locks up.  I'm not having that problem with all DTS packages on that server, just a couple (critical, of course).

Make sense?

< M!ke >
I can say nothing, which is cowardly, I can lie, which is immoral, or I can tell the truth, which will upset people.  - Tiki Barber

RE: DTS Pkg Designer Locks on Edit

Yarr, that be bad news indeed!

I've never come across this problem before.  

Ye might be needin to find a computer with that old dog Enterprise Manglarrrrrr still installed (and seaworthy as well, as mine sinks the second I leave the dock) and edit yarr package on thar (or at least copy the mapping information).

If the mapping is not terribly complex, ye might be better off to delete the step and build a new one.  If it be complex as me treasure maps, ye'll find yourself in some rough seas, to be sure!

you picked the wrong day to be sayin' arrrr in a post, matey!

Hope this helps,

Alex

----signature below----
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom

RE: DTS Pkg Designer Locks on Edit

(OP)
Thanks fer takin' time t' reply. Nay that 't helped at all, Alex! Ya lily livered scurvy dog!

What else ye got? An' be quick about it, I be shippin' out to OPSP soon!

Arrr, as fer the rest o' ye:  ye be wantin' t' go to sea an' ye don't be wantin' t' end up in Davy Jones' Locker! Best be learnin' t' be talkin' like a buccaneer on this day!

 

< M!ke >
I can say nothing, which is cowardly, I can lie, which is immoral, or I can tell the truth, which will upset people.  - Tiki Barber

RE: DTS Pkg Designer Locks on Edit

I only be shipping to RPSP (Reasonably Priced Sea Port), thank you very much!  OPSP is what the east india company uses!


I've never seen this problem before, but I'll bet ten dubloons that it's something Cap'n Bill missed in the first release of the DTS components.  What be yer service pack level?

On the client tools, not the servarrrrr!

If they be matching already, ye might be havin ta walk the plank or recreate your mapping.

----signature below----
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom

RE: DTS Pkg Designer Locks on Edit

(OP)
Ah! That be a good guess, but they match. I'll take "Walkin' th' Plank" fer $100, Alex, and thank ye very much fer yer time, ya scallywag!

< M!ke >
I can say nothing, which is cowardly, I can lie, which is immoral, or I can tell the truth, which will upset people.  - Tiki Barber

RE: DTS Pkg Designer Locks on Edit

And what service pack be they havin?

Could be an issue that were fixed in a later one.  Of course, waitin for that yella dba to apply the service pack on yar server could be a fate worse'n davy jones locker!

Best o' luck on yer voyage, Matey!

----signature below----
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close