Click here to Skip to main content
14,847,125 members
Home / Discussions / Database
   

Database

 
AnswerRe: How Commonly used are the dotNet Datatables and Datasets? Pin
Eddy Vluggen28-Sep-17 6:58
professionalEddy Vluggen28-Sep-17 6:58 
AnswerRe: How Commonly used are the dotNet Datatables and Datasets? Pin
Richard MacCutchan28-Sep-17 9:45
mveRichard MacCutchan28-Sep-17 9:45 
AnswerRe: How Commonly used are the dotNet Datatables and Datasets? Pin
Mycroft Holmes28-Sep-17 14:08
professionalMycroft Holmes28-Sep-17 14:08 
Questionhow to get the music database for my website? Pin
Member 1322076227-Sep-17 7:57
MemberMember 1322076227-Sep-17 7:57 
AnswerRe: how to get the music database for my website? Pin
OriginalGriff27-Sep-17 8:00
mveOriginalGriff27-Sep-17 8:00 
GeneralRe: how to get the music database for my website? Pin
Member 1322076224-Nov-17 19:08
MemberMember 1322076224-Nov-17 19:08 
AnswerRe: how to get the music database for my website? Pin
jschell27-Sep-17 9:28
Memberjschell27-Sep-17 9:28 
QuestionSSIS Packages are running on Staging but not on the Production Server - little bit Urgent my friends Pin
indian14326-Sep-17 6:34
Memberindian14326-Sep-17 6:34 
Hi,

I have some SSIS Packages that are getting executed using a .Net Application, when I execute them in Staging Environment they are properly executing and importing the Data, but when I execute them on Production Server they are not importing the Data, I am unable to debug because its a Production Server, I have enabled Logging on the Packages to write into a Table, still the error message is not much useful any help would be greatly helpful. Thanks in advance. The error message I am getting into the ErrorLog Table is:
Execution failed for SSIS Package: BillingDataLoad, Error description: FileFullName: Source Is Db, SSISPackageName: BillingDataLoad.dtsx, Source : Microsoft.SqlServer.Dts.Runtime.TaskHost, InformationCode : 1074041076, Description : Lookup has cached 16 rows. , SubComponent: Lookup [82], HelpFiledtsmsg110.rll, HelpContext0, IdofInterfaceWithError{B6F6D221-FC27-4F71-B5A0-597583986C28}

When I implemented SSIS Logging in my Application, I found that both 32 bit Jet 4.0 and 64 bit Ace 12.0 drivers are not registered on Production Server. But there are 32 bit and 64 bit Ace 14.0 drivers are there, then why Package is not able to execute on Production? Are Ace 14.0 64 bit and Ace 12.0 64 bit drivers not compatible to each other?

Another thing is, even though I have Ace 14.0 drivers on my local machine Data tools 2012 is taking Ace 12.0 64 bit drivers when I Create Data flow task using an xlsx file as data source? Why is it not taking Ace 14.0 drivers instead, I am creating the packages with Visual studio 2012 and .Net 4.0. Why is my Package taking Ace 12.0 drivers by default and expecting it to be registered on the Server.

Is there any solution for me? Can anybody please suggest me, so any change I have to make should have solid ground because I am going to make that change on the Production server. Please help I need some guidance or a link anything. By the way I tried both the .xls and .xlsx files and run Package under both 32 bit and 64 bit modes in both cases its failing, because 32 bit failing for Jet drivers not registered and 64 bit is failing by saying Ace 12.0 not registered when Ace 14.0 is registered there.
Description  {0}Excel Source failed validation and returned error code 0xC020801C.
, HelpContext  {0}0, HelpFile     {0}dtsmsg110.rll, IDOfInterfaceWithError {0}{B6F6D221-FC27-4F71-B5A0-597583986C28}, Source       {0}
Data Flow Task, Subcomponent {0}SSIS.Pipeline, Timestamp    {0}9/27/2017 5:03:34 PM, ErrorCode    {0}-1073450985
Description  {0}SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  
The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209302.  
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
, HelpContext  {0}0, HelpFile     {0}dtsmsg110.rll, IDOfInterfaceWithError {0}{B6F6D221-FC27-4F71-B5A0-597583986C28}, Source       {0}
Data Flow Task, Subcomponent {0}Excel Source [2], Timestamp    {0}9/27/2017 5:03:34 PM, ErrorCode    {0}-1071611876
Description  {0}The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. For more information, 
see http://go.microsoft.com/fwlink/?LinkId=219816
, HelpContext  {0}0, HelpFile     {0}, IDOfInterfaceWithError {0}{AC9502ED-5A99-4CB0-A467-B2AB5A157E70}, Source       {0}
ImportXlsxFiles, Subcomponent {0}Connection manager "Excel Connection Manager", Timestamp    {0}9/27/2017 5:03:34 PM, ErrorCode    {0}-1073676245
Description  {0}The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. 
If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000.
An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  
Description: "Class not registered".
, HelpContext  {0}0, HelpFile     {0}, IDOfInterfaceWithError {0}{AC9502ED-5A99-4CB0-A467-B2AB5A157E70}, 
Source       {0}ImportXlsxFiles, Subcomponent {0}Connection manager "Excel Connection Manager", 
Timestamp    {0}9/27/2017 5:03:34 PM, ErrorCode    {0}-1071607038
Package errors count after running the package:   {0}6

And another thing I found is, when I saw the Server it is showing the Ace 12.0 drivers in the drivers list, is it corrupted or over written or I need to re register it, etc are my questions.

The above is the error message I am getting, I am not getting any error messages for the .csv and .text files only for the excel files. So is there any way I can resolve this issue.
And another thing I found is, when I saw the Server it is showing the Ace 12.0 drivers in the drivers list, is it corrupted or over written or I need to re register it, etc are my questions. If I can resolve this issue without much change in the Server like re-registering the Ace 12.0 Drivers etc it would be nice to do that, since those drivers are showing up in the Drivers list.
Another thing I did was I installed SSDT 2017 to check if that takes Ace 14.0 drivers by default because I thought the new Versions of Office might have over written the Ace 12.0 drivers but no SSIS still is looking only Ace 12.0 drivers for 64 bit Excel files? I am not sure is it because of the SQL Server Version or SSIS Engine Version or Visual Studio Version or do SSDT always takes only Ace 12.0 drivers for Excel I am not sure, it would be a great help for me if somebody can help me with some guidance or any link etc, any thing helps my friends. I am also searching and applying different options, if somebody has gone through the same and resolved it, it would be a great help.

I am not trying to re-post or cross post this in hope of somebody might have gone through the same and can give me the valuable suggestions - Thanks in advance my friends.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

-- modified 2-Oct-17 13:41pm.
AnswerRe: SSIS Packages are running on Staging but not on the Production Server Pin
Eddy Vluggen27-Sep-17 3:35
professionalEddy Vluggen27-Sep-17 3:35 
AnswerRe: SSIS Packages are running on Staging but not on the Production Server Pin
jschell27-Sep-17 9:31
Memberjschell27-Sep-17 9:31 
QuestionNeed to find out what drivers are missing on the Production Server Pin
indian14321-Sep-17 7:32
Memberindian14321-Sep-17 7:32 
AnswerRe: Need to find out what drivers are missing on the Production Server Pin
Eddy Vluggen21-Sep-17 23:23
professionalEddy Vluggen21-Sep-17 23:23 
Questionreference in DB design Pin
a_yosef19-Sep-17 0:01
Membera_yosef19-Sep-17 0:01 
AnswerRe: reference in DB design Pin
Richard MacCutchan19-Sep-17 0:28
mveRichard MacCutchan19-Sep-17 0:28 
AnswerRe: reference in DB design Pin
Eddy Vluggen19-Sep-17 1:11
professionalEddy Vluggen19-Sep-17 1:11 
QuestionName for Sql Table Pin
King Fisher8-Sep-17 0:08
professionalKing Fisher8-Sep-17 0:08 
AnswerRe: Name for Sql Table Pin
Jochen Arndt8-Sep-17 0:20
professionalJochen Arndt8-Sep-17 0:20 
GeneralRe: Name for Sql Table Pin
King Fisher8-Sep-17 0:22
professionalKing Fisher8-Sep-17 0:22 
GeneralRe: Name for Sql Table Pin
Jochen Arndt8-Sep-17 0:28
professionalJochen Arndt8-Sep-17 0:28 
GeneralRe: Name for Sql Table Pin
King Fisher8-Sep-17 0:38
professionalKing Fisher8-Sep-17 0:38 
GeneralRe: Name for Sql Table Pin
King Fisher8-Sep-17 0:28
professionalKing Fisher8-Sep-17 0:28 
GeneralRe: Name for Sql Table Pin
Jochen Arndt8-Sep-17 0:36
professionalJochen Arndt8-Sep-17 0:36 
AnswerRe: Name for Sql Table Pin
Eddy Vluggen8-Sep-17 1:02
professionalEddy Vluggen8-Sep-17 1:02 
AnswerRe: Name for Sql Table Pin
Richard MacCutchan8-Sep-17 5:21
mveRichard MacCutchan8-Sep-17 5:21 
AnswerRe: Name for Sql Table Pin
jschell8-Sep-17 8:21
Memberjschell8-Sep-17 8:21 

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.