python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - ssis

Duplicate reference key values for SSIS lookup cause package to hang

I have a package that is used to load a slowly changing dimension in a data warehouse. The package loads 0-20 new rows of data on the nightly process. When testing the full load capability, which wo...
test-img

Dave

ssis

Votes: 0

Answers: 0

SSIS: flagging ALL the Data Quality issues in each row with Conditional Split

I have been tasked with performing Data Quality checks on data from a SQL table, whereby I export problem rows into a separate SQL table. So far I've used a main Conditional Split that goes into deriv...
test-img

Andrew Lilley

visual-studio

ssis

Votes: 0

Answers: 1

Latest Answer

Assuming I understand your problem, I would structure this as a series of columns added to the data flow via Derived Column transformation. Assume I have inbound like this SELECT col1, col2, col3, col...
test-img

billinkc

How to remove particular columns in SSIS package while doing transformation?

I want to remove a few columns from my flat file as I want to load in SQL server Data Warehouse using SSIS, How I can achieve this transformation using SSIS, see attachment for description. For e.g. I...
test-img

Dhananjay Tawar

sql-server

csv

ssis

etl

flat-file

Votes: 0

Answers: 2

Latest Answer

You can follow the below steps: Create Data Flow Task Define Flat File Source and create new connection manager and point to source file. Create empty flat file with the headers you want. Define Flat...
test-img

Venkataraman R

Why is TIMESTAMP fractional seconds off by .001 when exported from DB2 to MSSQL data type DATE, DATETIME, TIMESTAMP not as VARCHAR()

When I export TIMESTAMP data type from DB2 to SQL Server data types DATE, DATETIME or TIMESTAMP the fractional time is off by .001. If I export as data type VARCHAR() I get the correct data. Is there ...
test-img

CPHILLIPS1234

sql-server

ssis

db2

pentaho-spoon

Votes: 0

Answers: 1

Latest Answer

The result you have is completely expected. datetime is accurate to 1/300th of a second. The closest you can get to 2021-10-20-21.31.41.138000 in a datetime is 2021-10-20T21:31:41.136666666666~ which ...
test-img

Thom A

Posts

Questions

Blogs

Jobs