Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS Transfer Database object task

Author  Topic 

onlyanshul4u
Starting Member

6 Posts

Posted - 2007-09-13 : 10:57:39
Hi everyone
Can any one help me I am using Tranfer databse object task when I am trying to run it its throwing exception can not send null value in login name????

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-13 : 23:18:41
If you choose to transfer db users as well, ensure valid sql login for user exists on target server.
Go to Top of Page

onlyanshul4u
Starting Member

6 Posts

Posted - 2007-09-14 : 03:38:30
No I am just trying to copy sp, view tables and indexs not users and roles still same problem
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-14 : 23:59:45
Who is owner of those objects?
Go to Top of Page

onlyanshul4u
Starting Member

6 Posts

Posted - 2007-09-15 : 08:31:14
sa and also using sa a/c
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-15 : 14:50:31
Checked sql2k5 sp level on server and client?
Go to Top of Page

onlyanshul4u
Starting Member

6 Posts

Posted - 2007-09-17 : 10:47:18
when I am trying to transferdatabase objects its even not working on same server and also not getting any single resource on internet regarding the same...
Go to Top of Page

onlyanshul4u
Starting Member

6 Posts

Posted - 2007-09-17 : 10:48:15
plz try by yourself once than you'll get to know the problem...
plz some one help me...
Go to Top of Page
   

- Advertisement -