My table source: num_facture TYPE actif date 1 1 1 2010-01-31 00:00:00.000 2 2 1 2011-01-31 00:00:00.000 3 3 2 2012-01-31 00:00:00.000 4 4 2 2013-01-31 00:00:00.000 The Column data types are: Column Data Type TYPE tinyint Actif tinyint date datetime I’m working with SSIS to load my destination table. So…
Tag: etl
Why is the SSIS variable not passing the milliseconds part into the query?
DB SETUP: SSIS: Execute SQL task: The task has an output parameter (say Param1) of data type DT_DBTIMESTAMP. The SSIS variable data type is DateTime. Then in a subsequent Data Flow Task (say TASK2), I have an OLE DB source SQL command text: The above variable is used as an input parameter. In the SQL profiler…
SSIS Script Task throws Object reference not set to an instance of an object
I am trying to query the database and send the content in the body of the email. When I try to run the package it throws deadlock error. Can anyone please suggest what is that I am missing Script is like below Below is the And the package looks like below.. For every user I need to get all the
Valid_from Valid_to from a full loaded table
There is a source table which loads the data full and monthly. The table looks like below example. Source table: pk code_paym code_terms etl_id 1 2 3 2020-08-01 1 2 3 2020-09-01 1 2 4 2020-10-01 1 2 4 2020-11-01 1 2 4 2020-12-01 1 2 4 2021-01-01 1 2 3 2021-02-01 1 2 3 2021-03-01 1 2 3 2021-04-01
ETL – Update Tables with potentially new records or updated records
I am trying to accomplish the following table update via an insert for an etl process: Add in a new records that did not exists Update any records that had updates Keep all the records in place that did not change On the table I have a unique_id and an updated_date field when the record was updated ( or could
Use SSIS expresion to break up Full Name in to Seperate fields, Last First Middle
I have a full name field that has data in the format of Last Name First Name Middle Name some of the data doesn’t have a Middle Name where as it will be just Last Name First Name also some of the data has 2 spaces between the Last Name and First Name where as it comes to be Last
Conditional Data Validation In SSIS
I have a situation where table has two main columns DataFieldName & DataFieldValue along with some identifier such as OrderNumber. Now in DataFieldName there is value named as “OrderDate”…
Using Identity or sequence in data warehouse
I’m new to data warehouse, So I try to follow the best practice, mimicking some implementation details from the Microsoft Demo DB WideWorldImportersDW, One of the things that I have noticed is using Sequence as default value for PK over Identity. Could I ask, If it’s preferable to use Sequence ove…
Using Surrogate Keys in Data Warehouse Pros and Cons
A surrogate key is a mechanism that exists in our books for years and I hate for bringing into discussion again. Everyone is talking about the benefits of using a surrogate key instead of a business key. Even Microsoft Analysis Services Tabular and Microsoft PowerBI Tabular Models are working with the surroga…
SSIS Looping with Return Value from Stored Procedure
I am trying to create a SSIS Package that loops based on the return value of a stored procedure run in the loop. I keep getting a super NOT helpful error of: “Error: 0xC002F210 at Load Order, …