Tag Info

Hot answers tagged

4

SSIS gets its power by being an in-memory transformation engine. The base unit of work within a data flow task is the buffer. If you ever wonder why SSIS is so persnickety about data types, it's because it calculates the cost for a row and then allocates memory for N rows. All* the downstream components use the same memory address to do their part of the ...


1

There's no answer that applies in all cases. In general, however... If the lookup list is small and you can cache it(or use a cache data source), there's not much performance penalty to doing it in SSIS. If you want crossref a list of 50 location codes to names of cities, go for it. It's nice to see all the process on-screen in one place, rather than buried ...


1

In that unpleasant case, I think the best strategy is to compartmentalize it away from SSIS. Either move that out to a linked server with an altering view or use some other etl tool like a powershell script to get it out of the dancing schema into a table with a fixed one. If you have any history you should be able to guess a reasonable value for the upper ...


1

That's a filesystem concern, not an SSIS one. Any file that SSIS creates will be owned by the user SSIS runs as. The best solution would be to set the ACL on the target folder to be what you want; when SSIS creates the file it will get those permissions by default. If you can't do that for some operational reason, you can manipulate the file after creation ...


1

Since you're working with SQL Server 2008, you can take delete first approach as I outlined on this SO answer http://stackoverflow.com/a/15508174/181965 A option, that might sound stupid but it works, is to delete first and use the OUTPUT clause. I created a simple control flow that populates a table for me. IF EXISTS ( SELECT 1 FROM sys.tables AS T ...


1

The issue here is that the Locale settings of the file connection in SSIS are different to the language settings in SQL Server. In SSIS, go to the Properties window for your File Connection (Right-click->Properties). There should be a setting for LocaleID that will need to be set to match SQL Server (or to English). Further information can be found in the ...


1

A derived column won't be able to add a row number. Well, it can add a column called RowNum but the expression language doesn't support the ability to update a value on the fly. Instead, you'll need a Script Component. You can search for "SSIS generate surrogate key" and find plenty of reference implementations. I'm going to borrow from ...


1

I experienced this problem, and was able to resolve it by disabling a DDL trigger on the SSISDB database for DDL_DATABASE_LEVEL_EVENTS. The trigger was trying to write info into another Database.



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