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.
| Author |
Topic |
|
janetb
Yak Posting Veteran
71 Posts |
 Posted - 2010-03-02 : 11:48:55
|
| I've created a dtsx package that goes to a remote server, pulls records, and appends them to a local server's table. Executing the job works fine with Business Intelligence Studio. But, when I import as a package under Stored Packages, file system, and then run, there's an error in the very first connection to the remote server. But, the DB connection object to the remote server is placed in the connection string and works fine within Business Intelligence Studio. Any help appreciated. |
|
|
janetb
Yak Posting Veteran
71 Posts |
Posted - 2010-03-03 : 08:49:24
|
| Here's the message - but the login works fine within the package?Date 3/3/2010 8:46:45 AMLog Job History myImport1)Step ID 1Server WAHOOJob Name myImport1Step Name step1Duration 00:00:03Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: Domain\Administrator. ....00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:46:45 AM Progress: 2010-03-03 08:46:47.84 Source: Data Flow Task Validating: 0% complete End Progress Error: 2010-03-03 08:46:48.55 Code: 0xC0047062 Source: Data Flow Task Source - Query [1] Description: System.Data.SqlClient.SqlException: Login failed for user 'remote_sup'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTd... The package execution fa... The step failed. |
 |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-03-03 : 12:43:32
|
| check the user credentials to connect to the remote server or not.With RegardsSR |
|
|
|
janetb
Yak Posting Veteran
71 Posts |
Posted - 2010-03-03 : 12:49:43
|
| SR,Not quite sure what you mean - when I execute the package (after placing a userid/password in the remote server connection string object) the step executes fine. But, when I import the package into sql 2005 and try to run, or try to attach to a job to run, it fails. I see where it has the userid, but not the password. I've imported without any encryption and I've imported with a password - same result. |
|
|
|
janetb
Yak Posting Veteran
71 Posts |
Posted - 2010-03-08 : 14:26:46
|
| Not quite sure what was happening - I'm a domain administrator using sa account, but using my local machine to develop a BIDS was NOT working. And, I couldn't install BIDS on the server cause it kept telling me it was already installed. Finally found a post telling me how to get around that. Installed BIDS on the server, did an rdc to the server and used BIDS on the server and everything works fine. |
|
|
|
Reginajosephine
Starting Member
4 Posts |
Posted - 2010-03-18 : 19:13:14
|
| Try this, I had the same problem when I started creating packages. You must save the package to the server to run it as a job and select server storage as indicated below.When you save the package to the server you need to specify Server storage so the package will get the credentials from the server. Go to visual studio and save it to your server and select the last option under Package protection level (Rely on Server Storage and Roles for Protection Level) this should fix it.Regina Beauregard |
|
|
|
|
|
|
|
|
sql 2005 dtsx package error as job