Tag Info

Hot answers tagged

6

(From the screenshot) I see an unusual configuration where you have SQL Server's Min and Max memory set the same. Leave min memory as default. See my answer to SQL Server Min Server Memory. To determine ideal memory, refer - How to determine ideal memory for instance? and SQL Server Maximum and Minimum memory configuration We have SSIS running packages on ...


3

How much memory does SSIS need? (The real answer is: It depends.) However, Jonathan Kehayias has a formula that is pretty good, or so I think, since it works great for me. https://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/ The simple formula for reserving space for needs other than SQL Server in Windows is: ...


3

Please use Database Mail instead of SQL Mail. SQL Mail had security issues on several layers and in SQL 2005 SP2 had 'inbound emails' removed. They then further removed support for it and it is now in the depreciation list. Database Mail is the solution you are looking for. It passes audits easily, has lots of documentation, and is fully supported by ...


3

The main strengths of SSIS as I see it are 1) the ability to do things across servers which aren't otherwise linked (eg via linked servers) and 2) the ability to do things in parallel (eg multiple Execute SQL tasks operating concurrently). If you are using traditional SQL then you probably don't need 1), but you might need 2). Your ETL must be running in ...


2

The only actions that will cause the values in your configuration table to be updated within SSIS will be when you are in the Configuration editor menu. Clicking OK there will cause the values to be written to the table. Now, if you have an Execute SQL Task that has UPDATE statement in it, that would obviously change the values in the table but those would ...


2

Here is a link on SQL Server 2014 for you to Grant Permissions to Integration Services Service https://msdn.microsoft.com/en-us/library/Hh213130(v=sql.120).aspx The first step is: Run Dcomcnfg.exe. Dcomcnfg.exe provides a user interface for modifying certain settings in the registry. The following link for DCOM settings were last reviewed in 2006, but ...


2

If I get rid of the data representing 95 % of the table, I should have no further trouble filtering the rest of the data. In that case, separating that 95% of the data is way to go. If you want to stay with SSIS, the obvious solution is to redirect those records to a another flat file (can also be a separate db) during import. Specifying this flat file ...


1

Have you considered using a Data Flow Task with a Script Component acting as a source? You could just do an AddRow for each row you consume out of the file, and let SSIS handle the batches.


1

You should calculate this during your ETL process or create a calculated column on your fact table. Then, aggregations will be easier and queries will be somewhat faster than calculating the values at runtime.


1

How do I check to see if the record is not in .CSV file but it exists in SQL database? Have a staging table (e.g. dbo.tmp_DOCTORS or whatever naming convention that you follow) that will first truncate (everytime you load a CSV, make sure to truncate the staging table) and then import the entire CSV. Then you can update the main table by checking if a ...


1

Since this seems to be a data warehouse, is / can the recovery model be bulk logged (or simple)? That in addition with using TABLOCK hint on table_b could help a lot since the inserts could be minimally logged. I found a blog post by Itzik Ben-Gan on minimally logged inserts that could help.


1

Problem has been fixed. So I'll try to decribe solution to this problem and maybe for someone it'll be useful and save time. In the beginning we have an error message from wizard: "Failed to deploy the project. Try again later. (Microsoft SQL Server, Error: 27118)" Let's see detailed error, to do this just need to click on "Show technical details ...


1

From BOL If a package that is not configured to support transactions includes a Sequence container that uses the Required option, the Sequence container would start its own transaction. If the package were configured to use the Required option, the Sequence container would join the package transaction. If I have a sequence container and it is marked ...


1

I found an article about that, the version is to HANA 4.1. To move data from SQL Server to HANA, you can use SAP BODS in version 4.1 SP1 brings improved migrate with an assistant. Other methods such as: Sybase replication server.



Only top voted, non community-wiki answers of a minimum length are eligible