Most voted "ssis" questions
Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-grade data integration and data transformation solutions.
Learn more…30 questions
Sort by count of
-
8
votes2
answers439
viewsSettings . bat running a . dstx
I am running a file . dtsx using a load bat and I am wanting to make some adjustments: Legibly mount the file name date. Adjust in log file to tell which package name . dtsx was executed Decrease…
-
7
votes1
answer860
viewsSSIS loading entire XML before you start writing to SQL Server
I need to load a single large XML file (40GB+) into an 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…
-
3
votes2
answers106
viewsObject Variable type and Expressions
I wonder if you have any way to mount an Xpression on ssis that returns true or false on a variable of type Object : basically would be something like in sql 12 in (14,25,45,12,54) but in Expression…
-
2
votes2
answers462
viewsCopy excel extension files from various subdirectories with ssis
I To head banging on finding the solution to copy excel extension files from multiple subdirectories with ssis. I tried to get the foreach loop container to do it but I couldn’t, then they passed me…
-
2
votes1
answer34
viewsTaking month and year
I have a variable containing it an expression that corresponds to a directory of folders. I want the year and the month before: "c: " + SUBSTRING( (dt_str, 50, 1252)GETDATE(), 1, 4 ) + " " +…
-
2
votes0
answers63
viewsUpdate table with XML field and in different databases
I have two banks SQL SERVER 2012 installed on server A and server B, I need to insert and then make a Update in the server table B via linkedServer by the A server, but these tables have fields XML,…
-
2
votes0
answers155
viewsSSIS error: Cannot load script for Execution
Executing the data load generates the following error: "Cannot load script for Execution". The data load executes a Script Task. In this Script find a CSV file, in which it takes the date of the…
-
1
votes0
answers96
viewsError in Sqltask Run Output
I am developing a project where in one of my execute sql task has a query, select stuff((select ',' + campo from tabela FOR XML PATH(''))1,1,'') as resultado this query returns so | resultado |…
-
1
votes2
answers1051
viewsJob created on SSIS does not work on 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 it into a sql server location table. Sql…
-
1
votes1
answer161
views -
1
votes1
answer424
viewsCPF Validation - Integration Services
I am importing a base with Cpfs for my DW but need to do CPF validation inside SSIS. Does anyone have any idea how I can do that? Thank you! Edit: I got it done the way I wanted it. I used the…
-
1
votes0
answers335
viewsSSIS - Errors when running a package . dtsx
I am running a package that has 2 variables to run a date filter and when running it it works properly, but it bursts the following errors: -> Error: Attempt to parse the expression…
ssisasked 7 years, 2 months ago Andrey Hartung 1,763 -
1
votes1
answer188
viewsData 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…
-
1
votes0
answers143
viewsHow to add rows of data in a column in SQL Server?
I’m importing data from the Rais (ME). The state is Acre. I created two columns: Uf1 and Ano1. In Uf1 goes the information AC and in Ano1 receives the information 2014. Note that insert, in the…
-
1
votes0
answers22
viewsProblem with SSIS and Rest API
I have a unique problem and need help as soon as possible. The deal is this: I developed a SSIS application using Visual Studio 2019, but now discovered I need to make a connection using API. How do…
-
0
votes1
answer124
viewsBatch calling "dtsx" does not connect to Avaya CMS
I created a service in dtsx that needs to connect to CMS Avaya. It turns out that when I run it through Visual Studio it follows the process until the end normally. But when I call one batch it does…
-
0
votes1
answer139
viewsSSIS 2012 how to list files contained in UNC sharing?
I have multiple files stored in a "Hitachi Data Ingestor" (HDI) solution that serves as File Server. This solution is managed by linux system within an enterprise windows network. I can list and…
-
0
votes1
answer80
viewsCreate form and gridView dynamically with VB6
I need to create a form dynamically by code and add a gridView and a boot to that form, someone can help me?
-
0
votes1
answer591
viewsConvert SSIS data from varchar to int
I’m locked into a conversion by SSIS, scenario: I have a CSV file, which I need to import into a table already created in the database, In this table of the database I have a column already…
-
0
votes1
answer52
viewsIs it possible to create Web Service in SSIS?
It is possible create a web service in SSIS? As far as I know it is only possible to call a web service in SSIS.
-
0
votes0
answers43
viewsHow to add sql server Integration server to an existing project?
I am needing to integrate ssis to a project that has already been started, for importing excel spreadsheets and things like. All the tutorials I see shows creating a ssis as if it were a new…
ssisasked 5 years, 11 months ago gabrielfalieri 1,231 -
0
votes0
answers77
viewsData Flow Task generates blank Excel file - SQL Server Integration Services
I have a process in SSIS that takes information from a table and exports it to an xlsx file. It happens that, when running Job by SQL Server Agent, often the file is generated blank, even if it has…
-
0
votes1
answer31
viewsUpload data to Azure
Does anyone know if there is a possibility of uploading data from a file to a Datalake in Azure? For example, a Datatools service would run and it would access a repository within a user machine,…
-
0
votes1
answer389
viewsNewtonsoft JSON Deserialize List
I’m tantalizing to deserialize a JSON file, may I’m having this error "Newtonsoft.Json.Jsonserializationexception: 'Cannot deserialize the Current JSON Object (e.g. {"name":"value"}) into type…
-
0
votes0
answers13
viewsAccess the SSIS catalogue via SSIS
I need to create a process on SSIS SQL Server Integration Services that can extract from each project which tables are being used. The end result is to get a table that is automatically fed with two…
-
0
votes0
answers19
viewsVisual Studio in English, but SSIS in Portuguese. How to change?
I need a little help, I have Visual Studio 2019 installed in the English language, but when I open an Integration Service project, Toolbox options appear in Portuguese. I tried to go to Tools >…
-
-1
votes1
answer148
viewsComponents for Integration Services - SSIS - Data Flow
Hello! I have a need to develop a component for Integration Services (SSIS) -> Data Flow. I already have components developed for the Control Flow area, but I have never developed anything for…
-
-1
votes1
answer399
viewsImport SSIS file with columns at different positions each day
I have the following situation: I make a Flat File (Simple File) import from a *.CSV file to a table in the database. Using SSIS in Visual Studio. However, each day the file I receive has the order…
-
-1
votes1
answer262
viewsI cannot assign return of the expression in the SSIS variable
Task to insert Variable Value by select result My intention with this logic is to pass a column calculated from one excel file to another using an area of Stage where I just want to modify a column…
-
-1
votes1
answer44
views