Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with etl
Search options answers only
not deleted
user 2131
'Extract, Transform and Load': Data load processing, normally in the context of data warehouse systems.
5
votes
Accepted
SSIS Multicast performance question
All* the downstream components use the same memory address to do their part of the ETL, which allows for parallelization. …
- 16k
1
vote
Accepted
SSIS Transaction Problem
Yes. You will need to configure all the servers involved with your process to be of DTC.
When you use the native SSIS transaction capability, if the connection managers are entirely self contained, t …
- 16k
2
votes
Accepted
Running scheduled SSIS pkg with SQL Server 2012 Web Edition
When you attempt to run the package from dtexec, you can test this yourself, you're going to get an error that basically says you failed the licensing check and it's not going to run the packages outs …
- 16k
1
vote
Query or ETL process to insert data into fact tables in SSMS
While you don't specify the specific problem related to loading your fact table, I'm going to assume the question approximates "how do I translate AppName to an AppKey so I can store that ID into my f …
- 16k
2
votes
Accepted
decrypt data in column before load into destination
When calls to decrypt methods return NULL, either the column is NULL or the account that is using the methods doesn't have access to the key.
From BOL
Permissions
Requires VIEW DEFINITION pe …
- 16k
3
votes
Load New Foreign Key in Facts Table, When Update Dimension with SCD Type 2
No, you wouldn't update the fact table.
The fact record is tied to the version of the customer which existed between 2018-04-02 11:52:47.040 and 2018-04-02 22:29:05.243 in which they had a 1.99 tppe …
- 16k
0
votes
SSIS: Can't save "parallel load" option in Oracle destination with Attunity driver, how to s...
Guessing as I don't Oracle.
SSIS is a metadata driven technology. During development and execution, SSIS will attempt to compare known metadata state to the currently available. Delay Validation is a …
- 16k
2
votes
Inserting rows into other table whilst preserving IDENTITY
After a quick test, but I could not alter a column to remove the identity property. I assumed this would work but it does not appear to be the case.
ALTER TABLE dbo.FOO
ALTER COLUMN myId int;
You …
- 16k
2
votes
Accepted
What are the minimum requirements for running a dtsx package on a PC?
I'm fond of my ETL file processing pattern but go with whatever works best for you and your client.
That addresses getting the package so it can run with the right input. …
- 16k
14
votes
Accepted
ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
I wouldn't want to have 200 data flows in a single package. The time it'd take just to open up and validate would make you old before your time.
EzAPI is fun but if you're new to .NET and SSIS, oh he …
- 16k