SSIS Packages are running on Staging but not on the Production Server - little bit Urgent my friends - Database Discussion Boards

Quite often, even though I personally rarely use them; you'll find them in a lot of brownfields, as it is quite easy to load a datatable using a reader. Those are also common examples in most tutorials, making it quite accessible Smile | :)

I prefer to fetch the raw values from said reader, as I rarely need the overhead a table-class introduces.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Use them most of the time as they are easy and do all the hard work.

As soon as I get the data from the database I move it into a model/object so I never work with the dataset/table object. In future I will move the datatable to a Json string on the server and let the client move it into a model/object.

Never underestimate the power of human stupidity
RAH

I am trying to make a website like SONGS STORE where people can download there favorite song of their artists.So for this I want a songs collection database.Where can i get this kind of database?

Since most music is under copyright, your "obtaining" a database of music to download would be illegal, and we do not get involved in that at all.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

thank you .for your reply mate.

I would suppose any of the existing sites would allow you to relabel to your brand for enough money.

Otherwise you would need to do it like they did, go to the artists/companies and get their permission (contract agreement) to allow you to host their music.

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.

So, after the crossposting, we try reposting. Make an image of your production server, load the image in a VM, and debug.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Following certainly suggests that more information is available.

DtsError.IDOfInterfaceWithError Property (Microsoft.SqlServer.Dts.Runtime)[^]

Hi all,

I have a .Net application which is executing SSIS packages, when I run that application on the Staging Server, it runs fine, but when I run the same App on Production server it doesn't import the Data into Tables from Excel files.

When I caught the errors and warnings I get only this Warning, which doesn't help me a lot. Anybody if can suggest me something what to do? it would be great help. I doubt that there maybe drivers missing on the Production Server but until I knew perfectly I can't install anything on Production Server, any advice or a link or even code anything helps me, thanks in advance friends.

FileFullName: \\xxxxxxxxxxxxxxx\xxxxxx\Prod\MemberMaint092017.xlsx, SSISPackageName: SgLgReporting_SLMemberMaint_New.dtsx, 
Source : Microsoft.SqlServer.Dts.Runtime.Package, WarningCode : -2147381246, Description : SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  
The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); 
resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. 
Change the MaximumErrorCount or fix the errors.
, SubComponent: , HelpFile, HelpContext-2147381246, IdofInterfaceWithError{9744DAE0-F87A-45FC-B444-89E65C74BBF6}

Thanks,

Abdul Aleem

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

What you could do is stop crossposting[^]. Tips are here[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Where can i get a good reference in database design (typical steps of database desining)

Probably on the internet (www.google.com[^]) or in a reference library.

The steps to normalize a relational database-design are described on the Wikipedia. I'd recommend to normalize at least up to BCNF[^]. The wikipedia holds explanation on each rule, and why it is important. Start here[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Can you please suggest any meaningful name for new table.

Purpose:

Table will be used to store the email/sms template details like title, messagecontent,etc.
This template title will be displayed in a dropdown list, users can choose templates from dropdown and send it.

Roll eyes | :rolleyes:

நெஞ்சு பொறுக்கு திலையே-இந்த
நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

Why do you want to use the database table name as title for a dropdown list?

Just name the table something like message_template. The list title belongs to the GUI and using the database table name makes no sense when you have to support multiple languages. Choose a title descriptive enough to be understand by the users.

No, I'll not display the table name in dropdown,only the title column from the table.

நெஞ்சு பொறுக்கு திலையே-இந்த
நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

OK. But that is a value stored in the database and usually entered by the user (there would be no need to store that if it is a fixed title).

yeah, but there is a UI for user to create their own templates with template title, So, later when they want to send email/sms they will choose accordingly.

நெஞ்சு பொறுக்கு திலையே-இந்த
நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

Can you suggest few more names which is more suitable for my table please ?

நெஞ்சு பொறுக்கு திலையே-இந்த
நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

Only you know what the table is storing and what would be a suitable name.

Because the database design is usually not public, only the developers will use it. So I suggest to use the general rules for database names (and also variables and function names in programming languages):
Use one that describes it, may be not confused with similar names in the same context (e.g. multiple tables containing some kind of templates), but is not too long.

"Annie".

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

"Templates"

notification_template

'notification' because it applies to email and sms.
'template' because although the are properties the group actual serves as a template for what the notification will be.
Underscore to separate the two nouns.
Should not be 'templates' plural because by definition a table is already a set. And there are cases where one wants a table to contain more than one row/record as a 'set'. In those cases the table might be better named with the plural.