Questions tagged as 'ssis'

Tagged questions
0
answers

How to add sql server integration server to an existing project?

I need to integrate ssis with a project that has already been started, to import excel spreadsheets and stuff like that. All the tutorials I see show creating a ssis as if it were a new project, which is not my case. How to apply SSIS to a...
asked by 06.07.2018 / 14:04
0
answers

Is it possible to create Web Service in SSIS?

Is it possible to create a web service in SSIS? As far as I know, it is only possible to call a web service in SSIS.     
asked by 27.04.2018 / 21:52
0
answers

Execute dtsx package C #

I'm trying to run a dtsx package in C # and there's a need to refer to Microsoft.SqlServer.Management.IntegrationServices; But I'm not finding C: \ Windows \ assembly \ GAC_MSIL \ Microsoft.SqlServer.Management.IntegrationServices \ I have...
asked by 15.03.2018 / 16:31
1
answer

Integration Service does not appear in SSMS instance

I'm trying to install integration service on my server. Apparently it was successfully installed, the service appears in sql configuration manager, but the instance does not appear in sql management studio Does anyone know the solution?...
asked by 20.02.2018 / 19:20
1
answer

Conversion of SSIS data from varchar to int

I'm stuck on a SSIS conversion, scenario: I have a CSV file, which I need to import into a table already created in the database, In this database table I have an already populated column that receives data type INT, I noticed that there are...
asked by 07.03.2017 / 22:31
2
answers

Copy excel extension files from multiple subdirectories with ssis

I'm banging my head at finding the solution to copy excel extension files from multiple subdirectories with ssis. I tried to make the foreach loop container do it but could not, then passed me a code in C # to insert into a ScripTask string...
asked by 21.02.2017 / 20:50
1
answer

SSIS 2012 how to list files contained in UNC share?

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 a corporate windows network. I can list and have access to the files through UNC shares (\ serve...
asked by 10.11.2014 / 13:07
1
answer

Using SSIS to fix extra column error

I'm starting to learn about SSIS, I already know how to import a Flat File into the Bank, however I have a problem, the delimiter used is the Pipe "|", and in one of the columns it is used as value. When importing an extra column is "generate...
asked by 06.07.2017 / 21:26