Questions tagged as 'ssis'

Tagged questions
0
answers

Problem from dtexec running an SSIS with a KingswaySoft source for Salesforce

I have developed a package in SQL Server 2017 with TargetVersion 2012 , where the data source is a component for SalesWalk of KingsWaySoft and the destination is my SQL server. If I launch the package from Visual Studio, it works pe...
asked by 13.08.2018 / 13:30
0
answers

Script task parallels using common variables

I'm modifying an SSIS (SQL Server 2008 R2), which originally had a Script Task that did two different things, which I divided into two Script Task. Both have some common variables and when they execute they return the following error: A deadlo...
asked by 10.07.2018 / 09:31
0
answers

Configure the display of rows in integration service

I have a very specific question, As you can do to configure the integration service environment and I see the numbers of rows in the flow I can not get where that is done , thanks     
asked by 20.05.2018 / 19:37
0
answers

Load dynamic excel using Integration Service

What I need help is to be able to file with dynamic names using integration service, for example I have 5 files in a folder using a loop for each achievement to upload the 5 to a target table in SQL, my problems is that I would like the next loa...
asked by 18.05.2018 / 18:31
1
answer

Error inserting in Mysql from Sql Server2014 with SSIS

I am using an Integration Services with VS 2013 and Sql Server 2014 I want to export data from a Sql Server table to Mysql but it gives me an error and I will export to another database in Sql Server and also to execel 2016 and I will not no pro...
asked by 12.03.2018 / 20:01
0
answers

SSIS error when I want to see the execution report

I get this error when I want to see the job log of an SSIS package.    "Error: failed to convert parameter value from to string to datetime -> string was not recognized as to valid datetime" I enclose the photo with the error. In the p...
asked by 06.03.2018 / 12:42
0
answers

Error accessing a web service with SSIS

I am trying to access a Web Service for a project but I can not connect. I am using the tool "Web Service Task", I configure the connection (HttpConnection) to the wsdl, I enter the local file (WSDLFile) and I put the Overwrite section to True....
asked by 11.12.2017 / 11:00
0
answers

SSIS does not generate Excel working with a large number of records

I'm having a problem with an SSIS, which basically retrieves the data from a table and exports it to an Excel. The problem is that when I work with a limited number of records (1000 records) Excel generates me without problems, but when I remove...
asked by 09.08.2017 / 15:01
1
answer

SSIS: OleDB to Excel problem in a varchar column (1000)

When exporting from a SQL database to Excel in SSIS, I have a problem in a column in SQL that is VARCHAR(1000) , I tried to pass it to Unicode_Ntext , but I get the error:    [Excel Destination [84]] Error: An error occurred while...
asked by 22.02.2017 / 22:31
1
answer

Unable to run an SSIS package from vb6

I'm trying to execute a paquete SSIS from vb6 . From c# I can run the package if I use the following App.config: <?xml version="1.0"?> <configuration> <startup> <supportedRuntime version="v4.0...
asked by 25.08.2016 / 02:49