Post reply

Unable to open DTS package from client

  • March 10, 2006 at 7:08 am

    #168618

    I moved some DTS packages from one server to another. One of the developers that have dbo privileges is unable to open the package from his client. I can open the package from the database server with his login, but if I try to open it from my client I get an unspecified error. I moved multiple packages during this time and the strange thing is one of them can be opened, but the other two fail with unspecified error. Any idea on what the problem could be?

  • March 13, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • March 15, 2006 at 10:40 am

    #626854

    only thing I could think of is if the connection references the server "(local)" and the database doesn't exist on the workstation you are opening the package from.

  • March 16, 2006 at 8:13 am

    #627033

    In my experience, the "(local)" references won't prevent you opening the package, they'll just prevent you opening/editing certain objects on the package (actually, trying to edit those things, usually your DTS transforms, will result in the transform sort of getting cleared out... but I digress).

    I wonder if these packages rely on some sort of non-standard DTS objects added after the installation of SQL Server.  There's a process for adding objects to DTS and if you don't also have these objects on the PC where you're trying to open.  I forget the process and proper terminology for this - I make this sort of change only very seldom.

    In Books-on-Line, you could look for "Custom Tasks" subjects with topics like "Building a Custom Task" and "Registering a Custom Task."

  • March 16, 2006 at 8:32 am

    #627050

    Thank you both for your replies and suggestions. Actually the problem was related to a File Transfer Protocol task that was in the packages. Once I replaced that with an Execute Process task to xcopy a file instead of FTP the package can now be opened from client software. The packages worked with the File Transfer Protocol task before they were moved to our Europe environment, I think they stopped working there because now they are trying to communicate across domains. That's my theory anyway.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply