Advertisement

11.07.2006 at 06:33AM PST, ID: 22051758
[x]
Attachment Details

HELP! SQL 2005 Integration Services - Transfer SQL Server Objects Task - Cant Connect Using SQL Server Authentication

Asked by kennethscff in MS SQL Server

Tags: sql, server, integration, services, 2005

Hi Experts,

I am using SQL 2005 Integrations Services and am copying data from my SQL 2005 database to a SQL 2000 database using the Transfer SQL Server Objects Task.

However, if I use windows authentication to connect to the 2000 database if works fine. If I use SQL Server Authentication I get the error: -

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

The process can see the database and logon as I get the message: -

[Transfer SQL Server Objects Task] Warning: Table "Internet_Brand_Links" already exists at destination.

But it somehow is messing up somehow along the way.

I am logging on using the SA username and password so it is not a permissions thing.

Any Thoughts?Start Free Trial
[+][-]11.07.2006 at 06:39AM PST, ID: 17889638

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.07.2006 at 06:40AM PST, ID: 17889645

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.07.2006 at 06:45AM PST, ID: 17889688

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.07.2006 at 06:49AM PST, ID: 17889730

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.07.2006 at 06:53AM PST, ID: 17889765

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.07.2006 at 06:56AM PST, ID: 17889792

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.07.2006 at 06:58AM PST, ID: 17889823

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.07.2006 at 07:25AM PST, ID: 17890062

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.06.2007 at 06:30PM PST, ID: 18260312

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]01.11.2007 at 05:42PM PST, ID: 18298275

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: sql, server, integration, services, 2005
Sign Up Now!
Solution Provided By: Computer101
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32