Questions tagged as 'ssis'

Tagged questions
1
answer

ETL package (ssis) does not load excel of 179 thousand records

I have built an ETL package which loads data from an excel 2010 (179 thousand records) to a table in a database (simple construction, direct loading). In my work there are three environments (Development, Quality and Production), my construct...
asked by 26.02.2018 / 16:25
2
answers

How to get all the jobs in separate scripts sql server ssis?

When it is necessary to generate the drop and create scripts of the jobs in SQL Server separately, it is not possible through the SQL Server Management Studio, you can only go one by one to do this ... The problem with this is when you...
asked by 16.06.2017 / 15:28
2
answers

Open DTS files in Sql Server 2012

I want to migrate several Integration Services packages from sql 2000 that have a .DTS extension to DTSX. I currently have Sql Server 2012 and I can not pass them to DTSX. Is there a direct way to migrate them, without needing to convert t...
asked by 31.01.2017 / 16:28
1
answer

Validations within the SSIS

I currently have the following flow in an SSIS My question is, is there any way to put an OLE DB, which allows me to insert information into a table called errors if the Excel Source comes to fail, in a few words, if the Excel file does...
asked by 02.05.2018 / 23:42
1
answer

SSIS: Problems with data types DT_TEXT in Script Task

I have a Script to read the data on a sheet Excel . There are 78 columns and the first 10 are of type varchar(max) , so I had to put the data% Script to the outputs of DT_TEXT . The script is as follows:...
asked by 16.01.2018 / 17:23
1
answer

JOB failed to run SSIS package

I have created a JOB to execute an SSIS package but it gives me several errors. If I execute the package manually, it does not fail but through the JOB if. Next, you can see a screenshot with the errors. Does anyone know what may be hap...
asked by 23.11.2016 / 09:31
1
answer

Use variable data source SSIS data flow

In SSIS, I have a variable that takes the value of a query defined in a component "Execute SQL Task". The value of the variable is assigned correctly. What I want to do next is within a "Data Flow", using an "ADO origin", where the query is defi...
asked by 29.09.2016 / 07:34
0
answers

SSIS: Could you help me to know how an input parameter of integration service is inserted in an excel field?

In the red boxes I would like to enter the start and end date, these data are the parameters I use to consult and export in Excel In the red boxes I would like to enter the start and end date, these data are the parameters I use to cons...
asked by 13.07.2018 / 09:39
1
answer

Connecting to different OLE DB origins in SSIS

For several days now I am trying to make a connection to the BDD through the OLE DB wizard in Sql Server Integration Services. What I need is to be able to connect to different servers to be able to do the same query but in all the servers at th...
asked by 24.08.2017 / 14:55
1
answer

How to upload CSV file to SQL Server with SSIS

Hello dear, I hope you can help me. I am developing a workflow in SSIS to load Excel 2010 files into a table in SQL Server 2008-R2, many of the fields in Excel have text of more than 255 characters and are sometimes truncated in that value,...
asked by 06.11.2018 / 23:32