Legacy & Upgrades

We currently execute an SSIS package via Execute External SSIS Package.  We want to start using SSIS environments to better manage dev/prod values and passwords.  The problem with the Execute External SSIS Package is that we are not able to call the SSIS package using an SSIS Environment.  To get around this, we created a Script Action that executes the SSIS package with an SSIS Environment, and then set this script action as a Post Script on a table that is executed in our Execution Package.  The problem I am facing is that calling the SSIS package in this manor calls it asynchronously.  Is there a way to synchronously call an SSIS package with an SSIS Environment?

How can I update the value of the DW_Batch field? I know it's a project based value but I can't find the correct table.  

Did anyone have a data dictionary that has been pulled from timextender system database. The ideal one I am looking at is either a search option on a html where you can look for a table with all the columns, descriptions and data mapping(source).  Or if anyone did similar one on an excel document will equally help me. 

How can I execute a stored procedure once a load of a table is done. I know it should be possible. I just don't know where I should configure it  

I am trying to replicate some code from SQL, and need to create a custom table insert... my SQL query uses a temp table #ELL.  When I try to deploy & execute, it does not understand the temp table.  Can temp tables be used here?  IE. #ELL.. I just need to have it hold some info that later in the query will populate the new custom table in TimeXtender.

Hi , We have a need to identify the objects modified in last few days to deploy as part of differential deployment to various environments. To do this, we were looking at DiscoveryHub metadata database, which contains various tables like DataTables, DataColumns, Transformations etc.  However, to identify the delta, we have two columns ValidFrom and ValidTo which are stored as integers. We need a way to identify the data, either by converting these to dates or based on a range of dates. Please help

I have a table and I need to have a counter that restarts based on another field on the table.  In my case I have a JournalBatchNumber field.  For each new batch, I need to generate a LineNumber restarting with 1 for each record of the same batch.  Is this available in TX natively, or do I need to write a post processing script using rownumber ().    Thanks, Greg

This may sound a little silly, but I can't quite figure out how to create a script from the MDX Below: WithMember [Measures].[CustCount] AsCount(Filter(Existing {[Sell-to Customer].[Customer].Members},([Measures].[Sales Amount] >0)) * {[Measures].[Sales Amount]}, EXCLUDEEMPTY)SELECT{([Measures].[CustCount])} On Columns,{[Sell-to Customer].[by Country by City].[Country].Members} On RowsFrom[Sales]   It should be simple, but i'm missing something! Any assistance would be helpful regards Chris  

When setting up the global database for the DWH, I get this error: "Databricks direct write requires SQL Server Authentication" However, my environment properties  are straightforward and I can't find anything "databricks" related in the settings. It's a recent (2019) version. Anyone knows what this error could allude to?

what is the right scenario for using single quotes to wrap project variables?    Let's say i have a data constraint added to a field and i am using a dynamic project variable like, so in this scenario, i am comparing a data to another date, and i have the variable encased in single quotes. I always assumed the single quotes was how Discovery Hub "renders" the underlying variable, but i recently found that my assumption was untrue.  is the single quotes only to be used when evaluating a character string? or are there some rules to apply wrapping in single quotes.   Note: the variable above is a dynamic -> select max({datefield}) from {table} statement, under the covers. 

We are providing clients with a preconfigured data warehouse for an ERP system.  We will continue to make enhancements and improvements.The client will eventually add additional fields and user defined fields for their own needs.What's the easiest way to merge in our improvements to the changes they have already made to an older version?

I have been able to create a project variable containing the filepath from a text-file data source, and pass that forward to a SSIS-package. But I have not been able to locate the Backup-folder attribute. Any hints on where I should look for this?

Hi,  In my scenario, i rely on a stored-procedure in the source (external) database to create the table which will be used in TX. The stored-procedure might have various table/view/functions dependencies.  Is it possible to import stored procedure/scalar functions into ODX layer?  I know it's possible to recreate (internal) stored-procedure, however I have no access to the underline script in the stored-procedure Kind regards. Dror     

Hi TX Support, I wanna know how to implementing scalar function with COALESCE in TX ? Here i attach the function, could you please tell me how to do that ?   USE [QAD_DATA]GO/****** Object: UserDefinedFunction [dbo].[GetAliasesByWo1] Script Date: 03/20/2018 16:15:04 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[GetAliasesByWo1]( @item nvarchar(max), @length float, @catego nvarchar(max), @opt nvarchar(max))RETURNS varchar(max)ASBEGIN declare @output varchar(max) select @output = COALESCE(@output + ', ', '') + wo_lot + '=' + convert(nvarchar, wo_qty_ord) FROM wo_mstr_data where wo_part = @item and wo__dec01 = @length and wo__chr01 = @catego and RIGHT(wo_rmks,1) = @opt and wo_status = 'R' and SUBSTRING(wo_routing,1,6) = 'REWORK' return @outputEND