SSIS - trasfer table from remote sql2005 to DASP sql 2005

Discussion in 'Databases' started by jyjohnson, Sep 17, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. jyjohnson

    jyjohnson

    I'm having all kinds of problems using the Transfer Objects command. All I want to do is copy/create a table from one server to my DASP db (using my local PC)...

    I keep getting "source object does not exist"??!!

    Anybody know how I can resolve this or a workaround?

    Thanks!!
     
    jyjohnson, Sep 17, 2006
    #1
  2. wisemx

    wisemx

    With both SQL Server 2000 and 2005 here I've used the managers in both local engines to create or manage what I need and then have been able to successfully use the Import/Export tools to move everything to the DASP SQL Servers, both 2000 and 2005.

    I can create a Video for the transfer steps if it will help.
     
    wisemx, Sep 17, 2006
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    The Import / Export feature between SQL 2k and 2k5 is rather different.


    How are you doing it currently to get this error?


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Sep 21, 2006
    #3
  4. jyjohnson

    jyjohnson

    The source SQL server and DASP SQL server are SQL 2005. I'm not sure which version the source is using.


    My local PC has SQL 2005 + SP1 (not sure of the sp version).


    I think I read somewhere that SSIS does not support SQL IDs... Not sure if that is correct. There is a DASP KB article that says SSIS is not supported (don't know if that means what I'm trying to do is not supported).


    I've had Ok results using SQL Management Studio to load in an excel file into the DASP (and remote) servers. However, I can't get an actual SSIS package to work...
     
    jyjohnson, Sep 21, 2006
    #4
  5. JorgeR

    JorgeR DiscountASP.NET Staff

    jyjohnson,

    If you are trying to run SSIS on the DASP server, it will failed as the service is not supported. What are the steps that you are taking to transfer objects data to the dasp server. Are you using UDF's? have you check the referential integrity of the objects that you are transferring. I mean, you might of created a colum with (UDDT) that has not yet been created


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Sep 21, 2006
    #5
  6. trickshotsb

    trickshotsb

    I am having the same issue. I have several db objects on my local sql server 2005that I want to copy to the DASP sql server 2005. When I try to use the "Copy Database..." wizard, it throws a permissions error (I am using the default user created by DASP).


    EXECUTE permission denied on object 'sp_enum_sqlagent_subsystems', database 'msdb', schema 'dbo'.


    This function was easy in SQL server 2000. How can I accomplish this in 2005?
     
    trickshotsb, Oct 9, 2006
    #6
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page