Questions tagged as 'ssis'

Tagged questions
0
answers

SSIS - Errors when executing a .dtsx package

I'm running a package that has 2 variables to run a date filter and when it runs it works correctly, but it pops up the following errors: -> Error: Attempt to parse the expression "@[$Package::CARGA_ST_SQLFolder]" failed and returned error...
asked by 03.04.2017 / 16:00
0
answers

Error in Execute SQLTask Result

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,5,3,6,7,9,6,4| and I'm putting thi...
asked by 21.11.2014 / 15:36
1
answer

Integration Services Components - SSIS - Data Flow [closed]

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 Data Flow. I tried to find something about th...
asked by 15.05.2017 / 21:22
1
answer

Create form and gridView dynamically with VB6

I need to create a form dynamically by code and add a gridView and a button to that form, can anyone help me?     
asked by 05.05.2016 / 16:58
1
answer

Batch 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 squeeze it through Visual Studio it follows the process to the end normally. But when I call a batch it does not allow authentica...
asked by 04.04.2014 / 16:18
0
answers

Data Flow Task Generates Blank Excel File - SQL Server Integration Services

I have a process in SSIS that takes information from a table and exports to an xlsx file. It happens that when running the Job through SQL Server Agent, the file is often generated in white, even though it has content in the table (this is not a...
asked by 11.12.2018 / 14:43
0
answers

(SSIS) For Each Loop Container can not find file

Hello. I need to mount a task in SSIS that finds a CSV file in a folder on the network and imports that file into a table. It looks very simple, but the detail is that the directory changes name every day, with the mask Z: \ Folder \ Year \ Mont...
asked by 23.10.2018 / 17:15
1
answer

File import into SSIS with columns in different positions each day

I have the following situation: I import a Flat File from a * .CSV file into a table in the database. Using SSIS in Visual Studio. However, each day the file I receive has the order of the columns changed. Thus, the "e-mail" field, for example,...
asked by 15.10.2018 / 17:12
1
answer

I can not assign expression return in the SSIS variable

Task to enter Value in Variable by select result MyintentionwiththislogicistopassacalculatedcolumnfromoneexcelfiletoanotherusingastageareawhereIjustwanttomodifyacolumninthedatabasetableandtheninsertitintotheexcelfile.SoIamusingvariablet...
asked by 16.10.2018 / 17:11
0
answers

Business Intelligence - How and where to group school results?

Good people, I am developing a small project of Business Intelligence (BI) / Data Mining (DM) , with link to ambiente educacional (the data comes from a specific university discipline). Home The modelo multidimensional is as...
asked by 16.09.2018 / 23:00