Error In Executing Transfer SQL Server Objects Task - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » Error In Executing Transfer SQL Server Objects Task

Error In Executing Transfer SQL Server Objects Task

Options

Previous Topic · Next Topic

raaz

Posted: Wednesday, August 01, 2007 12:25:43 AM

Rank: Junior DBA

Joined: 5/17/2007
Posts: 59
Points: 189
Location: India

Hi

Getting the following error while exectuing Transfer SQL Server Objects Task.

I tried with SQL SERVER login.

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

Got the following error when used the Window Authentication

[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. ".

Any body can help on this?

Thanks In Advance..

Scott Whigham

Posted: Thursday, August 02, 2007 9:08:54 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Is this perhaps related to the 9.0.00.1399 to SP2 issue?

raaz

Posted: Monday, August 06, 2007 4:50:31 AM

Rank: Junior DBA

Joined: 5/17/2007
Posts: 59
Points: 189
Location: India

This is still not working for me.

actually, i am still trying. though package has not given any errors.

Scott Whigham

Posted: Tuesday, August 07, 2007 11:55:28 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Is this a "fresh" SQL 2005 SSIS package (i.e., one that you created from scratch) or a migrated package? I've never seen that error Frown

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.