Tag Info

Hot answers tagged

5

You can't, ish, is the short answer. You have 3 ish components in a data flow task that can modify data. OLE DB/ADO.NET Destination, OLE DB Command and a Script Component. I'm ignoring Script Component for this answer as it's the swiss army knife of components. If you want to do something badly enough, the Script Component will allow you to. Whether ...


4

I decided to see what happens when you actually click Create catalog in SSMS. There are a host of steps that are performed but the basic premise is that a backup exists at C:\Program Files\Microsoft SQL Server\120\DTS\Binn\SSISDBBackup.bak and as part of the catalog creation, that backup is restored to make the SSISDB. The pathway under Program Files is ...


3

SSIS will use as much memory as it needs. If there is not enough physical DRAM on the box, it will take it from the page file (which generally results in a big slowdown) The memory for running SSIS does not come out of the SQL Server memory space, it comes out of the memory that is left on the box after SQL Server has taken what it wants. In your case, this ...


2

Something has happened such that the source column doesn't exist any more and the mapping is broken. In the bottom drop down, "spaltzenzuodnungsoption..." there should be 3? options. You want the one that says delete. This will remove all the mappings so you can start over.


2

From SQL 2012 onwards, there is the WITH RESULT SETS option, which makes it easy to use the output from the OUTPUT clause with no sticky issues in SSIS not understanding the metadata for the resultset, eg you can use the output from an OUTPUT clause in SSIS Source components, eg OLE DB Source. I set up a simple example using a stored procedure with MERGE ...


1

If you're going to use SSIS, may I suggest you use it? ;) What I believe you are attempting to do is insert some data that doesn't already exist in the target. You have identified what data needs to go using your min/max logic and you attempted to do a similar operation for the target. For starters, the OLE DB Command is something you should use sparingly. ...


1

I took a different approach and well, mine's going to be a bit easier to maintain. ;) I have created a Variable named SourceDate. I'm going to run a query against my Source A table and derived the maximum date in there. Due to data type quirkiness, even though I used a date datatype, SSIS 2008 freaks out and thinks I'm changing data type so I explicitly ...



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