Recent content by burakcan

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...

Thanks Olaf/Greg/Borislav/Skip. It works now. :)

Yes there is no birthdates in your table from 1900 through 1917.

Thanks Borislav As I mentioned this is the birth date field. If we get someone birtdate in after 2000. Date will be something like 15-Jan-01. then this approach wont work :-(

Thanks Greg but My date year is 1949 not the 2049 (This is birth date field)

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...

Hi Olaf, Thank you very much for your help. I am using below script and it seems working :) ;with cte as (SELECT a.[ApplicationID] , a.[DecisionTypeDetailDate] , SUM(ConVert(Int,b.[ResubmitTOD])) AS ResubFreqTOD , SUM(ConVert(Int,b.[ResubmitTOS])) AS...

:( Thanks Olaf. Still I need to find a another way.

Hi Olaf, The compatibility_level is 100.