Click here to Skip to main content
15,848,483 members
Home / Discussions / Database
   

Database

 
GeneralRe: Handle to chat room with mysql database Pin
Eddy Vluggen16-Jul-14 9:05
professionalEddy Vluggen16-Jul-14 9:05 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 9:09
Member 1094998616-Jul-14 9:09 
GeneralRe: Handle to chat room with mysql database Pin
Eddy Vluggen16-Jul-14 9:24
professionalEddy Vluggen16-Jul-14 9:24 
AnswerRe: Handle to chat room with mysql database Pin
data modeling guy16-Jul-14 18:42
data modeling guy16-Jul-14 18:42 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 22:28
Member 1094998616-Jul-14 22:28 
GeneralRe: Handle to chat room with mysql database Pin
data modeling guy17-Jul-14 0:52
data modeling guy17-Jul-14 0:52 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998617-Jul-14 2:45
Member 1094998617-Jul-14 2:45 
QuestionSSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
Mangesh678616-Jul-14 3:04
Mangesh678616-Jul-14 3:04 
Hi Experts,

I have a package to import data from Excel to SQL tables. I have created and depolyed the package on production server say "ProdServer". Also I have created job on the same server and it runinng the package successfully. Even I run it manually it is running properly. But problem here is when I am connecting to SQL installed on the production server from my local machine using windows authentication and trying to run the package manually it gives below error.


Executed as user: SERVERNAME\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 7:41:10 AM Error: 2014-07-15 07:41:17.24 Code: 0xC0202009 Source: ImportMasterData Connection manager "PracticeMapping" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2014-07-15 07:41:17.27 Code: 0xC020801C Source: Load Practice Get Practice [69] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "PracticeMapping" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2014-07-15 07:41:17.29 Code: 0xC004701A Source: Load Practice SSIS.Pipeline Description: component "Get Practice" (69) failed the pre-execute phase and returned error code 0xC020801C. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:41:10 AM Finished: 7:41:17 AM Elapsed: 6.692 seconds. The package execution failed. The step failed


So in short when I run the packgae direclty from production server it works fine but from local machine or any other machine by connecting to the SSMS and running manually, it get failed. Please help me guys on this issue. Its very very urgent.

Thanks and Best Regards,
Mangesh
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
Eddy Vluggen16-Jul-14 6:03
professionalEddy Vluggen16-Jul-14 6:03 
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
PIEBALDconsult17-Jul-14 14:39
mvePIEBALDconsult17-Jul-14 14:39 
QuestionExtract Data in Single Record Pin
mrfalk15-Jul-14 14:05
mrfalk15-Jul-14 14:05 
AnswerRe: Extract Data in Single Record Pin
data modeling guy15-Jul-14 20:32
data modeling guy15-Jul-14 20:32 
AnswerRe: Extract Data in Single Record Pin
Richard Deeming16-Jul-14 3:42
mveRichard Deeming16-Jul-14 3:42 
AnswerRe: Extract Data in Single Record Pin
PIEBALDconsult17-Jul-14 14:54
mvePIEBALDconsult17-Jul-14 14:54 
Questionlinked list using CTE Pin
Ali Al Omairi(Abu AlHassan)14-Jul-14 23:29
professionalAli Al Omairi(Abu AlHassan)14-Jul-14 23:29 
AnswerRe: linked list using CTE Pin
Ali Al Omairi(Abu AlHassan)15-Jul-14 0:14
professionalAli Al Omairi(Abu AlHassan)15-Jul-14 0:14 
QuestionOVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 5:44
Ambertje14-Jul-14 5:44 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
PIEBALDconsult14-Jul-14 6:13
mvePIEBALDconsult14-Jul-14 6:13 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 6:15
Ambertje14-Jul-14 6:15 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
Eddy Vluggen14-Jul-14 6:27
professionalEddy Vluggen14-Jul-14 6:27 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
PIEBALDconsult14-Jul-14 6:29
mvePIEBALDconsult14-Jul-14 6:29 
QuestionRe: OVER (PARTITION BY ORDER BY ) Pin
Eddy Vluggen14-Jul-14 8:47
professionalEddy Vluggen14-Jul-14 8:47 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
Jörgen Andersson14-Jul-14 9:33
professionalJörgen Andersson14-Jul-14 9:33 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Mycroft Holmes14-Jul-14 13:54
professionalMycroft Holmes14-Jul-14 13:54 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Jörgen Andersson14-Jul-14 23:20
professionalJörgen Andersson14-Jul-14 23:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.