Post reply

SSIS database copy with SSMS

  • May 31, 2011 at 1:57 pm

    #240561

    I've been trying to setup a SSIS package thru SSMS that uses the copy feature to send the databases to a new server and attaches them.

    For some reason when I try to use my package it fails, there really is no indication on what went wrong.

    I'm trying to move from SQL Server 2008 SP1 to SQL Server 2008 R2.

    It also wants me to specify a share name for some reason, I'm not sure why?

  • June 2, 2011 at 8:33 am

    #1333139

    No ideas?

  • June 2, 2011 at 12:50 pm

    #1333311

    Ok I got it working the issue was with UAC and the fact that I didn't create a user on both SQL servers.

    If you use this feature remember to right click and run as administrator.

Viewing 3 posts - 1 through 2 (of 2 total)

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