Skip to main content

Legacy & Upgrades

-

  • 14 Topics
  • 36 Replies
14 Topics
D
dan.beggsParticipating Frequently
asked in Legacy & Upgrades
Executing SSIS package

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?

01
D
K
keith.williamsNew Participant
asked in Legacy & Upgrades
DW_Batch field value

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.  

01
J
S
satish.padarthiKnown Participant
asked in Legacy & Upgrades
Data Dictionary

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. 

04
T
A
alain.thireNew Participant
asked in Legacy & Upgrades
Executing stored procedure

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  

01
J
P
purnima.ozaNew Participant
asked in Legacy & Upgrades
Can you use temp tables (sql - #tablename) in custom table insert SQL queries? This is for a custom insert table.

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.

14
T
R
rnistalaParticipating Frequently
asked in Legacy & Upgrades
How to convert ValidFrom and ValidTo dates in DiscoveryHub metadata DB

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

39
J
G
greg.laymonNew Participant
asked in Legacy & Upgrades
Seeking Best Approach to Add a Counter to a Table That Resets Based on Another Field

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

22
M
C
chrisNew Participant
asked in Legacy & Upgrades
Creating Script from MDX

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  

00
C
J
janNew Participant
asked in Legacy & Upgrades
Error setting up Multiple Environment Deployment

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?

03
J
J
jnortonNew Participant
asked in Legacy & Upgrades
when to use single quotes in Project Variables

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. 

01
J
M
mchinskyParticipating Frequently
asked in Legacy & Upgrades
Merge projects

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?

03
J
M
martin.dideriksenParticipating Frequently
asked in Legacy & Upgrades
File backup folder as variable

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?

00
M
D
dror.svartzmanNew Participant
asked in Legacy & Upgrades
Import SQL Stored-procedures/ function into ODX

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     

14
J
A
ajiParticipating Frequently
asked in Legacy & Upgrades
Implementing Scalar Function with COALESCE in TX

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

03
A

Badge winners

Show all badges
Terms & ConditionsCookie settings