Post reply

dts package opens blank

  • August 25, 2006 at 12:53 pm

    #97426

    I have client tools installed on my pc and I created serveral dts packages and saved them on the sql server.  When I log onto the sql server, and I open the dts package, it opens blank. 

    Thanks for any help!!

  • August 28, 2006 at 7:40 am

    #657046

    if you addressed any of the connections as (local), and you do not have the same database on your local computer, it will not show. The solution would be to change (local) to the computer name or ip address of the server. Obviously make this change while logged on the server.

  • August 28, 2006 at 7:55 am

    #657049

    I have the DTS on BISRV Server using 2 connections to other sql servers..so the connections are not local.  I was able to log onto the BISRV server and open a DTS; but when I opened another it was blank, then I went back to the DTS I was able to open, now that one is blank...when I close EM I got a dialog box to send error..

  • August 28, 2006 at 7:57 am

    #657050

    can you open the dts from the server? what type of connection is it? sql/windows nt?

  • August 28, 2006 at 9:18 am

    #657117

    Also what service pack levels are they?  Is your development machien the same as the server you are trying to open the Packages on etc.? 

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • August 28, 2006 at 9:29 am

    #657119

    I can not open the dts from the server...the connections are sql server.

     

    on my pc, i have 8.00.818 sp3 std edition

    on my server, i have 8.00.760 sp3 std edition

  • August 28, 2006 at 10:18 am

    #657140

    maybe a DNS problem? try using ip addresses instead of named pipes temporarily.

  • August 28, 2006 at 10:29 am

    #657144

    I applied the hotfix 818...so both versions are 8.00.818 and I still have the same problems...some of the dts packages created with user with old domain name...we have recently migrated to a new dowmain name....would this cause issues....

  • August 28, 2006 at 10:34 am

    #657146

    you wouldn't be able to access the file at all if that were the case (I could be wrong)

    you also may want to go to "save-as" and save the DTS to your local computer and see if it opens from there. My guess would be "no."

    Did you try using IP addresses?

  • August 28, 2006 at 10:38 am

    #657148

    I used the ip address and was able to open a dts i had problems with before, and then i opened a new dts and got this message...

     MMC has detected an error in a snap-in.  It is recommneded to shut down and restart MMC.

  • August 28, 2006 at 11:34 am

    #657168

    http://www.google.com

Viewing 11 posts - 1 through 10 (of 10 total)

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