Search results for query: *

Hello, I have 2 SSIS packages. Basicaly they do the same thing except Package_1 is using configuration file and Package_2 doesn't. Configuration file has 3 variables, Extract_Start_date, Extract_End_date, and Historical_load, depending on Historical_load value StartDate and EndDate get value...

Hi All, I have a SSIS package reads 5 tables from another server. I am using Temp Tables to load the 5 tables then update the first temp table with other 4 temp tables before I load the final table . It loads the temp tables but doesn't work when I try to update the first temp table with...

Hello, How to convert string DD-MMM-YY date to YYYY-MM-DD Date format in SQL? Sample '17-Jun-49' --> 1949-06-17 Thanks for the help.

Hello All, I need to read data from one server and load the data another server by using SSIS and TempTable. There is no link server between the servers. I need to load the data into the temptable from server1 table(s) and update the same temptable from another tables in server1 then load the...

Hi All, I have dimension table as you see in the picture. District_Key is the key joining the fact table. But I like to create a hierarchy with New_DVP column and summarize the measure based on the New_DVP. Can anyone help me for this? Thanks...

Hi All, I have a .csv file (, separated) which I read into the SQL server, but there is a value like "Manitoulin, Unorganized, West Part". Because of the ,s in the value SSIS put each word into next field. Is there any way to put whole value into the one field? Thanks

Hello, How can I convert Null or empty datetime value to default datetime value ("1900-01-01") using SSIS derived column transformation in SSIS? I need to check both empty or Null date values. Thanks

Hello, There is a key in my fact table which I don't want to show them in the cube. I mean I redirect some values as a -1 key (N/A) in fact table. In dimension table -1--> N/A. I am trying to hide those N/A values in the dimension to not to show them to the user. Any suggestion? Thanks...

Hello, I need to increase a counter for each changed rows in SQL query . I have a column holds values 0 or 1. Id like to create a new column based on the column C which holds 0 or 1. If the value is 0 then my new value will be 0 if it is 1 then my new column value at the first 1 then for the...

Hello, Can anyone help me in my MDX query? I am working on a calculated members in the cube. I need to round up the result to the next integer value. Please see the samples below : If my calculation result is 34.2 then round up to 35 If my calculation result is 34.6 then round up to 35 again...

Hello, I have a table holding values as below: (also I attached the table picture as well) rownum Id UserID DecisionTypeDetailDate RushTypeKey ExpectedRushType 1 35428225 System 2014-04-22 22:38:19 8 8 2 35428225 RECALL 2014-04-26 15:05:00 8 8 3 35428225 System...

Hello, i am trying to search a number 1-5 in a long text field. I am using PATINDEX function and regular expression. here is my example: Declare @mystr varchar (50) set @mystr = 'closing in 5 days' Select substring(@mystr,patindex ('%[1-5]%'),@mystr),1) =' ' if text like 'closing in 5days' or...

Hello, Is there a easy way to use regular expression in SQL query or SSIS package(with example please)? Thanks for the help...

Hello I have a MDX query which uses by one of our reports. The query calculates current year and previous year YTD values. the [YTD Prev Year Unique Product Submissions] based on the Fiscal Day. The problem is previous year calculation of the Feb 29. Because there is no Feb 29 previous year...

Hi All, Is it possible to catch username and record it in a table in Crystal Report? I just want to know who, when used the reports. Any help is greatly appreciated, Thanks Burakcan

Hello, I have a crosstab report(Please see attached report file) that shows daily jobs run status. "P" Means Pass, "F" means Failed. I have also empty cells that means that job did not run that day. I would like to put "N" (Not run) instead of showing empty cell and change the background color...

Hi, I have 3 parameters. I’d like to show only first one to user selects first value in first parameter. I should not show the other 2 parameters. I need to show second or third parameter depends on first parameter’s value. Is this possible in Crystal report 11? Appreciate your help...