dbTalk Databases Forums  

SSIS Transfer Objects task - "Cannot apply value null to property Login" blues...

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS Transfer Objects task - "Cannot apply value null to property Login" blues... in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ziga Jakhel
 
Posts: n/a

Default SSIS Transfer Objects task - "Cannot apply value null to property Login" blues... - 11-10-2005 , 01:20 PM






Hi, everybody.

I am trying to transfer a database from one server to another using SSIS
Transfer Object task.

The package runs, but crashes with a quizzical error:

Error: 0xC002F325 at Transfer SQL Server Objects Task, Transfer SQL Server
Objects Task: Execution failed with the following error: "Cannot apply value
null to property Login: Value cannot be null..".

I am NOT transferring any logins or users, and the databases already exist
on the destination server.

Anybody know what this error is about? It's been driving me nuts for about
an hour, as I can't make any sense of it.

Regards,

Ziga Jakhel



Reply With Quote
  #2  
Old   
EH
 
Posts: n/a

Default Re: SSIS Transfer Objects task - "Cannot apply value null to property Login" blues... - 11-14-2005 , 05:10 AM






Are you running with SQL security?

If yes, try Windows/Integrated authentification...

Ernst



"Ziga Jakhel" <Ziga.Jakhel(a)nospam(dot)rrc(dot)si> wrote

Quote:
Hi, everybody.

I am trying to transfer a database from one server to another using
SSIS Transfer Object task.

The package runs, but crashes with a quizzical error:

Error: 0xC002F325 at Transfer SQL Server Objects Task, Transfer SQL
Server Objects Task: Execution failed with the following error:
"Cannot apply value null to property Login: Value cannot be null..".

I am NOT transferring any logins or users, and the databases already
exist on the destination server.

Anybody know what this error is about? It's been driving me nuts for
about an hour, as I can't make any sense of it.

Regards,

Ziga Jakhel




Reply With Quote
  #3  
Old   
Ziga Jakhel
 
Posts: n/a

Default Re: SSIS Transfer Objects task - "Cannot apply value null to property Login" blues... - 11-16-2005 , 04:19 AM



Yes, I was, on the target server. Will retest sometime this week, more
urgent problems to solve right now.

But a question - why should the security model be an issue?

Regards,

Ziga

"EH" <beta (AT) mailinator (DOT) com> wrote

Quote:
Are you running with SQL security?

If yes, try Windows/Integrated authentification...

Ernst



"Ziga Jakhel" <Ziga.Jakhel(a)nospam(dot)rrc(dot)si> wrote in message
news:%23YbaCvi5FHA.3312 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
Hi, everybody.

I am trying to transfer a database from one server to another using SSIS
Transfer Object task.

The package runs, but crashes with a quizzical error:

Error: 0xC002F325 at Transfer SQL Server Objects Task, Transfer SQL
Server Objects Task: Execution failed with the following error: "Cannot
apply value null to property Login: Value cannot be null..".

I am NOT transferring any logins or users, and the databases already
exist on the destination server.

Anybody know what this error is about? It's been driving me nuts for
about an hour, as I can't make any sense of it.

Regards,

Ziga Jakhel






Reply With Quote
  #4  
Old   
EH
 
Posts: n/a

Default Re: SSIS Transfer Objects task - "Cannot apply value null to property Login" blues... - 11-16-2005 , 05:16 AM



we run in a similiar problem
problem went away after switching to integrated security

someone from MS Support is investigating this already...

Ernst




"Ziga Jakhel" <ziga(dot)jakhel(at)rrc.si> wrote

Quote:
Yes, I was, on the target server. Will retest sometime this week,
more urgent problems to solve right now.

But a question - why should the security model be an issue?

Regards,

Ziga

"EH" <beta (AT) mailinator (DOT) com> wrote in message
news:eqrKZwQ6FHA.3136 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Are you running with SQL security?

If yes, try Windows/Integrated authentification...

Ernst



"Ziga Jakhel" <Ziga.Jakhel(a)nospam(dot)rrc(dot)si> wrote in
message news:%23YbaCvi5FHA.3312 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
Hi, everybody.

I am trying to transfer a database from one server to another
using SSIS Transfer Object task.

The package runs, but crashes with a quizzical error:

Error: 0xC002F325 at Transfer SQL Server Objects Task, Transfer
SQL Server Objects Task: Execution failed with the following
error: "Cannot apply value null to property Login: Value cannot be
null..".

I am NOT transferring any logins or users, and the databases
already exist on the destination server.

Anybody know what this error is about? It's been driving me nuts
for about an hour, as I can't make any sense of it.

Regards,

Ziga Jakhel








Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.