Skip to content

Tag: ssis

SSIS data conversion issue of decimal

I have a dtsx package running in SSIS on our SQL server (2016 SP2 CU6), its a lightweight task of importing an Excel (xlsx) worksheet into a table in SQL as-is, no transformations needed at this stage, there is an agent job that does a lot more around it but I can see the fault is occurring in just this

How to fix slow running SSIS package

I am trying to insert large amount of data from one table from PROD DB to table in Archive DB. Tables are with the identical schema and archive table is with drooped indexes and “Identity insert on”. …

Best way to start SSIS catalog or SSIS package remotely

I need to execute an SSIS package or an SSIS catalog remotely. What is the best way to acomplish this? I’m using: Visual Studio 2012 SQL Server 2012 Answer I am almost positive you need an integration server to accomplish this. The package is stored in the MSBD of the integration server and called by jo…

how to cast datetime2 as datetime

I’m trying to convert datetime2 to datetime in order to create a standard between different sources using only SQL or SSIS Take the following SQL query as example: SELECT CAST(offer_start_date AS …