Questions tagged as 'ssis'

Tagged questions
1
answer

SSIS loading entire XML before starting write to SQL Server

I need to load a single large (40GB +) XML file into a SQL Server 2012 table using SSIS. I'm having problems because SSIS seems to be trying to load the entire XML file into memory before loading records into the database, instead of reading and...
asked by 13.12.2013 / 02:51
1
answer

.bat Settings that runs a .dstx

I'm running a .dtsx file using a load bat and I'm trying to make some adjustments: Manually set the file name date. Set in the log file to tell you the name of the .dtsx package that was run Decrease the code to insert date and time into...
asked by 17.02.2017 / 14:49
2
answers

Object Variable type and expressions

I would like to know if there is any way to mount an expression in ssis that returns true or false in a variable of type object: It would basically be something like in sql 12 in (14,25,45,12,54) but expression instead of a list would be some...
asked by 17.11.2014 / 16:42
0
answers

Update table with XML field and on different banks

I have two SQL SERVER 2012 banks installed on server A and server B, I need to insert and then do a Update on the server table B via linkedServer by server A, but in these tables have XML fields, I am not necessarily updating this fie...
asked by 07.12.2017 / 16:23
1
answer

Take month and year

I have a variable containing it an expression that corresponds to a directory of folders. I want to show the year and the previous month: "c: \" + SUBSTRING ((dt_str, 50, 1252) GETDATE (), 1, 4) + "\" + RIGHT ("0" + (DT_STR, 2, 1252) MONTH...
asked by 04.10.2017 / 17:04
1
answer

Import data via SSIS or C #?

Hello I would like to know a more professional way to perform data import (TXT, CSV, XLSX and etc.) since today we do this via C # or by executing the SQL "Bulk Insert" command. If I should use SSIS or some other more efficient way of impo...
asked by 16.09.2016 / 16:34
1
answer

CPF Validation - Integration Services

I'm importing a base with CPFs for my DW but I need to do CPF validation within SSIS. Does anyone have any idea how I can do this? Thank you! edit: I was able to solve it the way I wanted it. I used the script component, I got a...
asked by 23.05.2017 / 22:16
2
answers

Job created in SSIS does not work in SQL SERVER AGENT

I have a job created in SSIS (working perfectly) that does not work in SQL SERVER AGENT. The job extracts some data from an access table, via ODBC, and loads into a sql server local table. The Sql Server and the access database are on different...
asked by 14.01.2016 / 17:03
0
answers

Integration Services does not insert insert with high quantities [closed]

I'm using Integration to load into an identical table in another database on the same instance, but the Integration package does not end the operation when I try to perform an insert with a high number of records (34,000) when the amount of reco...
asked by 02.01.2019 / 11:40
0
answers

Data Flow Task: Processes, but does not write to the Database

I am using SQL Server Integration Services (SSIS) with SQL Server Data Tools (graphical component for Visual Studio 2015). Within my processing package (SSIS) I have streams that, depending on the defined condition, the respective Data Flow T...
asked by 28.11.2017 / 19:45