Search results for query: *

Hi, I importing multiple txt files in SSIS using a Multiflatfile connection with wildcard. Everything works fine as the number of files could vary at run time as files are each from a different source systems. Now what i need to do is each time a file is processed, read the filename so I can...

Hello, I am trying to make a HTML Item set a parameter value directly (saving user input) and then run the report again. Using what I have the report refreshes but the parameter value does not change. Im Using.. <input type="BUTTON" class="clsPromptButton" onClick=promptButtonFinish()...

Hey, Using SQL 2008 I have created a copy of a table but with a different set of indexes on and then inserted all data from the original into the copy. Doing a right click on the tables and selecting Propeties, Storage shows that both tables have the same number of rows (a touch over 20...

Hey SQL Guru's My new approach to working out NETSALES uses a VAT table rather than CASE statements and is based on a BETWEEN operator with an INNER JOIN to match transaction dates to the correct VATRATE. It will be the first time I have used a BETWEEN operator with an INNER JOIN so I wanted...

Hello All, I am trying to populate variables in a new SSIS package using the Execute SQL Task but I am having an issue to get the actual values to update! Steps I have completed.... Created Variables with Package wide scope Added an Execute SQL task. Pointed connection to Server Edited (&...

Hi, Not critical as I have a work around so this is just to help me learn/improve my code... I would like to know if you can you set a variable when using CASE? I tried various ways but with no luck..I needed to add either 0 or 12 hours to a date based on whether the StartDate and EndDate...

Hi, I want to dynamically create DTS Global Variables in VBScript rather than create them up front because I do not know how many I will need each time. If I create a global variable using the following it works fine. e.g. DTSGlobalVariables("GV_Name").Value = "AnyValue" but if I try to do...

Hi, I am creating a DTS package that loops through and imports 2 types of text files (5 of Type 1 and then 5 of type 2) to the same staging table using a single data pump but hit problems when I reach the 2nd file type as 4 of the source column names are not the same as the first file type. I...

Hi, I am trying to automate e-mail sending of two sets of figures in the same Outlook mail but I am having problems. I am having Excel save 2 spreadsheets to HTML and then combining them in Outlook using: 'Read first file Set fs = CreateObject("Scripting.FileSystemObject") Set f =...

Hi, I am trying to change a DTS package so that it uses global variables rather than 'hardcoded' dates but the step that deletes the data from the tables does not work. The way the pkg works is that it deletes the last 15 days worth of data & then goes and re-retrieves it again. I want to be...

Hi, I have 3 tables which between them hold sales summary data, cost prices data and then dates/session info. I need to pull everything from the sales table + work the actual cost of each sale (Summ.Volume * cost.CostPrice) *but* using the cost price that was applicable on the date the sale was...

Hi, I need to update a table using data from 2 different tables but I am not sure where to start. T1 contains ALL products and their cost and T2 contains some products but with more up to date costs. [Products in T2 also exist in T1]. Both tables have Prod_Code & Prod_Cost and I need to...

I have an Excel table which contains 2 rows per person showing the latest score and then below it the avg for the year (See example below). I need a formula that will lookup the ID and then return the yearly avg (2nd row) for each person so that when I use filldown only the YearAvg score is...

Is possible to extract a list of all items [cubes, reports etc] published to Upfront? Would like to make this available to key users to see what can be removed. Note: Because our server is dying we need to migrate ASAP so do not really have time to set up auditing and wait for meaningful...

Hi, I am trying to work out how to pass parameters from an execute process task to a vb .exe and then return a code so that the package knows if that step worked. Everything I have found so far is geared towards executing packages from within VB and we want to execute a vb app from the DTS...

We have scheduled DTS jobs that have run error free for ages but the ones that use batch files to build cubes in Transformer have stopped running when scheduled. It is not specific to this program as I am unable to schedule a DTS package to run *any* .exe [or a .bat which launches an app]. An...