InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 11:31:50 GMT20http://www.sqlservercentral.com/Forums/Topic1300862-147-1.aspxDoes anyone know what algorithm the ssis fuzzy grouping component uses to produce a confidence score?I've been able to calculate the similarity score and produce a subset of data from a lookup table but I need to produce a confidence score for each result in the subset of data returned.My ultimate aim is to produce a fuzzy grouping ssis custom component. I know one already exists but this component only comes with SQL Server 2012 Enterprise edition hence my need to develop the component.I've searched the internet for the last few days now to no end. Any help is greatly appreciated. Wed, 16 May 2012 02:55:16 GMTlynnsay.piperhttp://www.sqlservercentral.com/Forums/Topic1304902-147-1.aspxWhat is the difference between Merge And Merge Join Transformations in SSIS??Wed, 23 May 2012 06:48:03 GMTksambireddy07http://www.sqlservercentral.com/Forums/Topic1303907-147-1.aspxHi,We are having 3 different source system(Oracle, Webservice and Dataservice) and SQL server 2008 as the destination. We have 3 different packages pointing these source systems.In the existing senario we have scheduled the packages to run in SQL server agent to run daily at say 8.00 AM. But now, the packages should run as soon as the data is available from the source system(package run should be dyanamic and not static at 8.00 AM).Based on these source systems, I request you thoughts on how to implement the same. Please let me know if you need more details.ThanksRegardsJimTue, 22 May 2012 01:03:13 GMTJim1234http://www.sqlservercentral.com/Forums/Topic1300734-147-1.aspx[font="Courier New"]Hi All,How can we use PATINDEX to find multiple occurrences of a string in a column?I'm struck up with extracting a particular string from a column in a real-time scenario. Here's a brief overview:I've a SQL table with 4 columns in it. One is SUBCAT, REF_FROM, REF_TO and CASE_HISTORY.There are different subcategories in the SUBCAT column - Of which i only need to look for a particular subcategory (called CORPORATE_NEW) for which i need to extract the emp. code based on specific conditions. For CORPORATE_NEW subcategory, i need to extract the 5 or 6 digit emp. codeFor other subcategories, i need to extract the 10 digit emp. codeThe columns REF_FROM and REF_TO will have 4 different types employee codes (alphanumeric strings of length 5, 6, 9 or 10) and will have the latest emp. codes for a particular record in the whole table.AGFC45824 - 9 digit emp. codeS1572 or S15802 - 5 or 6 digit emp. codeCSKW758104 - 10 digit emp. codeThe CASE_HISTORY column contains the following (there are multiple rows - one sample row as below):[code="sql"]Case moved from Q of [AFDC15820]s to Q of [ADFV15870]s ...Case moved from to Q of [ADFV15870]s to Q of [S13572]s ... Case moved from Q of [S13572]s to [CSKW10072]s... Case moved from Q of [CSKW10072]s to Q of [S13572]s.. Case moved from Q of [S13572]s to Q of [ADFV15876]s ... [/code]I need to extract the ids found in the above column (for each record in my table) based on the conditions below.1. The employee code needs to searched and populated in this order only - REF_TO column, then REF_FROM column and finally CASE_HISTORY - The REF_TO, REF_FROM columns will have the latest owners (emp.code) of the record in his queue.2. In case, if any of the columns (in the above order) if the emp. code is S10353 (the system automatically pushes case from one user to another using this id), then i need to check the CASE_HISTORY column and extract the last owners REF_FROM and REF_TO.3. Also, if either of the columns REF_FROM, REF_TO contains the 9 digit emp. code, i need to ignore their values and pick out the last owners from CASE_HISTORY based on condition 2 above.If no employee code could be found, then populate it as emptyI've coded these conditions using CASE .. WHEN block and PATINDEX, but i'm a bit struck-up and getting lost. :crazy:Can someone help me out to extract the correct employee codes?Will try posting the code that i've built shortly. I would need to scan & extract the employee code from this table, so i prefer this code to be built using a cursor.Hope Paul White takes a look at this post.. :w00t:RegardsSarang[/font]Tue, 15 May 2012 20:21:18 GMTrangamailshttp://www.sqlservercentral.com/Forums/Topic1298090-147-1.aspxI need to create an interactive word document and have attached a wireframe/sketch image to clarify goal. At the top are two fields where a team lead can enter (1) the name of a project they’re working on eg. MobileAppABC and (2) the name of the current build 10.20.3333.5342. Once entered, a report and graph is generated which displays the number of bugs executed, passed, failed, etc. for that project/build. In summary, parameters are passed from Word to a TSQL query which generates a report and chart in Excel format that is passed back and rendered from within the Word document. I would like to know:(a) If anyone on this forum has ever created a Word Add-In OR a document specific Office Business Application that compiles a script that calls a stored procedure that executes a query that returns a report and passes it back to Word, formatted as an excel pivot table and chart. (b) What scripting language was used. (c) If you think this is possible. (d) Any suggestions you have at all (spot-on specific links, tack-on relevant book titles).Thu, 10 May 2012 12:13:22 GMTpolkadothttp://www.sqlservercentral.com/Forums/Topic1301500-147-1.aspxHi All, I need some recommendations on How to load csv file using BULK option with OPENROWSET, Please Let me knowThanks,BBThu, 17 May 2012 00:17:48 GMTBeginnerBachihttp://www.sqlservercentral.com/Forums/Topic1301507-147-1.aspxI need some suggestions from you, We have a cube with 13 dimensions and 2 Measure Groups which have 33 partions each. As applied PROCESS UPDATE for Dimensions and PROCESS FULL for cube taking around 12 hrs to finish processing. Im planning to reduce the processing time for this im planning to apply process incremental for cube. PROCESS UPDATE for Dimensions PROCESS FULL for Recent Partions PROCESS INDEX for rest of Partions. This will surely reduce processing time but if we apply process index then if we get any of the updated data for those transctions it wont reflect the changes. There is a chance of getting updates of those trancsctions with latest extract.So it wont work Anyone suggest me the best approach for this process. Please let me know if you need more info. My Lead suggest me ( write a process which finds which partion will be impacted with the new loaded transctions and refresh only those partions) Ex: If Cube was refreshed on 10th may we need to check the trancsctions loaded after that date and which partion effected those transctions and refresh only those partions)Is it possible to do this approach.....Thu, 17 May 2012 00:33:25 GMTniha.736http://www.sqlservercentral.com/Forums/Topic1300162-147-1.aspxi have 2 multi value parameters NO and NAME for these parameters i set value as 1 and 2 respectively in available values based on the input selection i have to hide respective columns,for this i used the below expression for respective columns.=IIF(Parameters!p.Value(0)= "1",true,false)=IIF(Parameters!p.Value(0)= "2",true,false)its working fine when i select any one parameter,if i select both parameters its not workingTue, 15 May 2012 06:16:27 GMTyudy.varmahttp://www.sqlservercentral.com/Forums/Topic1300069-147-1.aspxWe've come to add a new data source to our warehouse which presents us with a challenge.The transactional system the data are coming from can't provide us an indicator of which data has been added, updated or deleted. I appreciate this is fairly common but my concern is that the data will run to millions of rows, which feels like a lot to process each day.The first thing we are required to do is to stage the data before modeling it into the data warehouse. We also need to keep as light a touch as possible on the source system. Luckily the source system maintains PK's on all tables.My thoughts so far are:1. Truncate the staging tables and reload all data each night.2. Generate a hash value to compare against the one previously generated, replacing each record where it's different.Both these methods feel like I need to process an awful lot of data.I'd like to hear peoples own experiences of this as I’m sure it's quite common.MartyRoccoTue, 15 May 2012 01:41:42 GMTMartyRoccohttp://www.sqlservercentral.com/Forums/Topic1301434-147-1.aspxI get error when connecting to a cube from a spreadsheet in Excel 2010:"Errors in the OLE DB provider. An error occurred while loading the connection dialog box component for prompting".Please help,Alexander.Wed, 16 May 2012 17:10:44 GMTShurkadzehttp://www.sqlservercentral.com/Forums/Topic1298247-147-1.aspxThis is a known bug that to my knowledge has not been fixed. I have a table inside of a matrix, and when exporting to excel, the data within the tables are ignored. I feel like what I'm trying to accomplish is NOT that difficult, but I'm having a hard time working around this without doing what I would consider silly. So I'm looking for some ideas, or someone to point out why I'm being a bit of a bone head ;-)Essentially I'm trying to create a 12 Month Rolling report for a set of metrics, with months across the top, metric labels down the left hand side, and the data inside the matrix. I chose a matrix because the columns need to be dynamic based on whatever month I'm runnin this for. There is no other grouping necessary other than by month. So what I did was put a table inside the row group and hardcoded the metric lables that I wanted into a set of rows in that table. I then put another table inside the data region, and put my metric values (sum(x)..). It works perfectly, however I'm running into this bug where I can't render it in Excel.3 month rolling sample made up below of what I'm trying to do..[font="Courier New"]__________|Jan 2012|Feb 2012|Mar 2012|$Sales....|300.....|400.....|500.....|Unit Sold.|30......|13......|23......|Turnover..|12%.....|14%.....|20%.....|[/font]I realize that what I could do is accomplish this with a table and large set of subqueries to paramaterize what each column would be, but I consider this silly. Suggestions welcome! I'll even take someone sarcastically pointing out why what I did wasn't very smart! (including my ascii table, that was a pain to line up :-P)Thu, 10 May 2012 16:15:59 GMTBad_Karmahttp://www.sqlservercentral.com/Forums/Topic1301310-147-1.aspxDoes someone know how to..I have been asked to take the matrix report that shows our Duration over a group of months.. what they have asked for is at the end of these month columns to show the Percent change over that period... so if we have a row where the Avg Duration was 1.2 in March, 1.0 in Apr, and 1.1 in May the the weighted change would be -8%.Formula (add all Avg_Dur)/(count of Columns)/(first Avg Duration)So is that even possible? (if so .. how?)Wed, 16 May 2012 13:11:18 GMTdwilliscphttp://www.sqlservercentral.com/Forums/Topic1301077-147-1.aspxThe Application Update report has a status for each job step.. now I would like to summerize these up into a grouping, on the report (with drill down). For each grouping how would I create the expression to only show 'Succeeded' if each step had 'Succeeded' in this field.. otherwise it would show 'Failure' if any of the steps 'failed'...next 'Canceled' if any of the steps had 'Canceled'.. and last 'Retry' if any of the steps had 'Retry'(my guess is the same format would be used at each level of the grouping: Application, Sub-Application)Wed, 16 May 2012 08:24:16 GMTdwilliscphttp://www.sqlservercentral.com/Forums/Topic1298402-147-1.aspxHiI am in need of help. I had Sql server 2008 R2 installed before. I project I got demanded that I removed R2 and installed 2008 instead. Easy? Hell no.I made uninstall on R2, but I see that there are some stuff left. I tried to remove All leftover that involves 2008 r2. I now installed 2008. But SSRS could not be installed.I got this message:[i]Details Product: SQL Server ID: 50000 Source: setup.rll Version: 10.0 Component: SQL Server Native Client Message: A network error occurred while attempting to read from the file '%.*ls'. Explanation An attempt was made to install (or update) SQL Server Native Client on a computer where SQL Server Native Client is already installed, and where the existing installation was from an MSI file that was not named sqlncli.msi. User Action To resolve this error, uninstall the existing version of SQL Server Native Client. To prevent this error, do not install SQL Server Native Client from an MSI file that is not named sqlncli.msi. [/i]I have searched and searched with google, but have not found a solution that works. Please help me out. Best RegardsSamuelFri, 11 May 2012 02:10:39 GMTsamueldhedinhttp://www.sqlservercentral.com/Forums/Topic1299403-147-1.aspxscenario: Below query used in a procedures and takes 4 miniuts to execute it, when we replace "inner hash join" with "inner join" it will excecute in 1 sec , I have tested it in a UAT server.Question : Can I replace "inner hash join" with "inner join" should it effect on data manupulation ?? Where to use inner hash join?? select rnt_tran_syscode from DTL_transactions transinner hash join HDR_customer_master tmpcm on trans.client_syscode = tmpcm.cust_syscodeinner hash join TEMP_rnt_trans tmptr on tmptr.foliono = trans.folio_no And ( tmptr.tran_status = 'A' or tmptr.TRAN_STATUS is null)Here DTL_transactions is a transaction table having 17444912 recordsalso index on key values like client_syscode, ..HDR_customer_master is a master table having 137567also index on key values like cust_syscode, ..and TEMP_rnt_trans is temporary table having 315984 index on tran_status but not index on "foliono"Mon, 14 May 2012 01:53:58 GMTjitendra.gupta1 89520http://www.sqlservercentral.com/Forums/Topic1298700-147-1.aspxI've a DB with multiple tables. A SSIS Package to be developed to move table data from src server to destination server.I'm using script component as source and destination. How to create output columns in src dynamically like an array of output columns, rather than defining them beforehand.Note: Pls don't suggest workarounds. I can do this using Import Export wizard/ Execute SQL Task.Thanks.Fri, 11 May 2012 09:35:31 GMTsqlbi.vvamsihttp://www.sqlservercentral.com/Forums/Topic1298545-147-1.aspxSomething that's bothering me and I hope someone can help.I have a report that has a number of parameters. I set a default value for each of those parameters. When I open the report it automatically runs with the default values. I actually don't want it to run in this circumstance. The defaults are there because they're the most commonly used values but the users will want to change at least one most of the time. Having the report run automatically just holds them up.Is there any way I can override this behaviour so that, even with default values for all parameters, the report doesn't run until the user clicks "View Report"Fri, 11 May 2012 06:47:07 GMTFunkyDexterhttp://www.sqlservercentral.com/Forums/Topic1294252-147-1.aspxHello Folks,I have an excel file placed in a shared folder. The Columns of this file are variable(may be 2 or 3 or 5). I need an idea how to develop an SSIS package to write the data to a table. ThxWed, 02 May 2012 16:19:12 GMTsqlbi.vvamsihttp://www.sqlservercentral.com/Forums/Topic1224033-147-1.aspxHi,There is a table in SSRS report that can have up to N columns. Some of those columns can have insignificant data that I do not want to show, so I am hiding such depending on an expression, and that creates a "white space" to the right of the tableIs there any way to be setting a width of the report dynamically?Thanks in advance!Mon, 19 Dec 2011 13:12:03 GMTbtio_3000http://www.sqlservercentral.com/Forums/Topic1294458-147-1.aspxHi, I have an issue that I cannot understand anymore... I have a server A (Windows Server 2003) hosting a database. I have developed a DTS to save in this database some data for other databases from other servers. This DTS is runned each morning with MS SQL Server (automatic execution). I don't understand why every day, the run duration is random. Sometimes, the job spends 15 minutes to be done, sometimes, it spends 30 minutes... Do you know please how I can begin me research to solve this problem? Thans you in advance, ElaelianThu, 03 May 2012 04:16:46 GMTelaelian.prelanihttp://www.sqlservercentral.com/Forums/Topic1297842-147-1.aspxWe've released an in-house dimensional modeling tool we've been using for the past few into the community. It's the type of thing you take with you into a modelling workshop with users, they get to see the visual representatinof the model evolve through the workshop, and you leave with a robust kimball-style star schema model set all ready for tying up to source systems for data lineage.Available here: [url=http://www.dimensionalmodeler.com]www.dimensionalmodeler.com[/url]It's free.. and you get what you pay for. Enjoy ;-)Stuart[url=http://www.dimensionalmodeler.com]www.dimensionalmodeler.com[/url]Thu, 10 May 2012 07:05:06 GMTstuart 12290http://www.sqlservercentral.com/Forums/Topic570748-147-1.aspxIf there are more than one way to have the dynamic columns in the report if so than what are those and which one is the best to use.Tue, 16 Sep 2008 23:47:07 GMTpuneet.pandeyhttp://www.sqlservercentral.com/Forums/Topic1297095-147-1.aspxI have a report in which the user can change selectioncriteria by ticking boxes in a combobox. This Reporting Services report is presented to the user on a web page in a ReportViewer control. This works fine for all users apart from one. the moment he tries to change the criteria by clicking another option in the combobox, he gets an error "Invalid operation because of current view of the object".If I bring the database from the production server to my development pc, run the application with the account of the user, open the report and change the selection: no problem.I've uploaded the report again to the RS of the productionserver and checked all the settings.Because the report has many pages for this user, I've changed the web.config of the Report Manager by adding in the section appSetting: "<add key="aspnet:MaxHttpCollectionKeys" value="50000" />". The server is restarted.But the problem remains. Anyone has an idea as to how to solve this?Wed, 09 May 2012 07:35:57 GMTEllen Heijmanshttp://www.sqlservercentral.com/Forums/Topic1297041-147-1.aspxHi All,Hope i am not asking very basic thing !!!!I have a dimension Product with parent child hierarchy, User dimension is related to this dimension by measure group [User Product Count]. So a user can have multiple product levels.I have executed the below query-WITH MEMBER [Measures].[ParameterCaption] AS iif(IsEmpty([Measures].[User Product Count]), null, [Product].[Parent Product Hierarchy Key].CURRENTMEMBER.MEMBER_CAPTION ) MEMBER ParameterValue AS iif(IsEmpty([Measures].[User Product Count]), null, [Product].[Parent Product Hierarchy Key].CURRENTMEMBER.UNIQUENAME) MEMBER [Measures].[ParameterLevel] AS iif(IsEmpty([Measures].[User Product Count]), null, [Product].[Parent Product Hierarchy Key].CURRENTMEMBER.LEVEL.ORDINAL) SELECT non empty {[Measures].[ParameterCaption] , ParameterValue , [Measures].[ParameterLevel]} ON COLUMNS , non empty (filter(except([Product].[Parent Product Hierarchy Key].allmembers ,[Product].[Parent Product Hierarchy Key].DEFAULTMEMBER) ,not [Product].[Parent Product Hierarchy Key].CURRENTMEMBER.IS_DATAMEMBER) ) ON ROWS FROM ( SELECT ( STRTOSET('[Dim User].[User Id].&[1]', CONSTRAINED) ) ON COLUMNS FROM [RetailerSales]) which gives me the resultParameterCaption ParameterValue ParameterLevel10-CP [Product].[Parent Product Hierarchy Key].&[1] 1P2-LOREAL PARIS [Product].[Parent Product Hierarchy Key].&[2] 2P4-GARNIER [Product].[Parent Product Hierarchy Key].&[3] 2P5-MAYBELLINE [Product].[Parent Product Hierarchy Key].&[4] 2But i want only the records having maximum parameterlevel value i.e 2 in this case.Any help would highly be appreciatedWed, 09 May 2012 05:53:32 GMTsandeep yadavhttp://www.sqlservercentral.com/Forums/Topic1296819-147-1.aspxAn Error has occured during report processingQuery Execution failed for dataset 'dataset name'The server principal 'user/role' is not able to access the database 'dbname' under the current security contextTue, 08 May 2012 17:43:22 GMTndevrhttp://www.sqlservercentral.com/Forums/Topic1295133-147-1.aspxWe have a need to provide a portal for certain external customers to access data. We believe SQL reporting services can provide the range of reports required but with this being www facing we need to make sure it is secure. Any suggestions as to what to use ?Fri, 04 May 2012 04:49:24 GMTPaul Farnellhttp://www.sqlservercentral.com/Forums/Topic410666-147-1.aspxIn sql 2005 Business Intelligence Studio I created a Report Model Project and defined the data source, data source view and a report model. I can preview the data in the BI studio. I selected 3 tables, defined relationsships and added a "named" query. Build succeeded as did deploy. Report builder finds the report model but reports "selected data source does not have any content available"Sun, 14 Oct 2007 19:08:35 GMTIndianrockhttp://www.sqlservercentral.com/Forums/Topic1295999-147-1.aspxTrying to find out if this is possible...Can a SQL Server 2012 machine acting as a SSIS App Server (running the SQL Job that does the execution) connect to a HA\DR environment where the actual package and table configurations are stored and be able to run the package/get the configuration information?What about if the SSIS App Server were the 2008 R2 machine and the HA\DR environment was running SQL Server 2012? Could this work?Thanks for any and all responses. I myself will continue to research.ThanksMon, 07 May 2012 10:55:49 GMTGBeezyhttp://www.sqlservercentral.com/Forums/Topic409502-147-1.aspxI would like to create a database to house all info of a server. Is there a software that can do this task or do I have to go to all servers and capture all info by hand.Thanks,PeteThu, 11 Oct 2007 07:03:31 GMTAstigdawhttp://www.sqlservercentral.com/Forums/Topic1288591-147-1.aspxI am trying to use SSIS to load data from Flat files into an Oracle Destination. What installations and configrations are required for SSIS to connect to Oracle destination? Mon, 23 Apr 2012 18:08:57 GMTrkahttp://www.sqlservercentral.com/Forums/Topic1283494-147-1.aspxI have requirements where I need to create optional parameters. When users run the report they can choose the parameter or they can leave it blank. I am new to SSRS any help would really appreciate it.Main SQL:WhereAgreementGroups.AgreementGroupName =@AgreementGroupName Or @AgreementGroupName is not nullParameter SQL:SELECT distinct AgreementGroupNameFROM AgreementGroupsWHERE AgreementGroupName IS NOT NULLUNION SELECT '(NULL)'ORDER BY AgreementGroupNameFri, 13 Apr 2012 15:11:54 GMTfahadmirza12http://www.sqlservercentral.com/Forums/Topic1290617-147-1.aspxExperts,Am new to SSAS and SSRS.I have been asked to create a report with data source as cube (They want data source as Cube only). The report format is something like below.[b] ProdutName Manufacturer Unit (Kg, Ltr etc;) SalesPerson Obsolete [/b]Only these 5 fields are necessary, nothing else.Ofcourse I have the following tables,Product ManufaturerUnit SalespersonAs far as I understand, I don't see a Fact table and measure here and confused how to define the cube. Can anyone pls guide me to create this simple cube and report ?.I have gone through some of the notes and have created some of teh cubes and reports.Deployed and using the same. Also I am aware that the above report can easily be created using a simple query. But the requirement is it must be based on cube.Thanks in advance,Smith.Thu, 26 Apr 2012 06:27:51 GMTJoy Smith Sanhttp://www.sqlservercentral.com/Forums/Topic1290512-147-1.aspxHi Friends i have small doubt in loading data .suppose i have a folder that folder contains 3 excel sheets data and 5 flat files data. all sheets data like id,name,sal so how to load flatfiles and excel sheets data dynamicaly in ssis .iam trying to useing foreach enumrator but some error occurs. plz tell me how to use foreac enumrator while loading flat files and excel sheet dynamicaly. plz tell me the process. is it possible or not to loading dataThu, 26 Apr 2012 03:54:02 GMTasrananthahttp://www.sqlservercentral.com/Forums/Topic1290799-147-1.aspxI have a feeling I already know the answer to this but it's not the answer I want so I'm hoping that asking the question here will somehow change reality to fit my requirement:-)I have a line chart that shows actual overtime cost by month for a year. I have 2 additional lines: YTD average and a moving 4 month average. I've calculated the YTD average using a RunningValue expression: =RunningValue(Fields!Amount_signed.Value,sum, nothing)/Fields!FiscalPeriod.Value. I'm using a Calculated Series to display the moving 4 month average. All that's fine and producing the right result.The thing is, I'd like the order in the legend to be:-ActualYTD Average4 Month AverageBut the 4 Month Average always appears immediately after the Actual, presumably because it's calculated from the actual whereas the YTD average is a data element in it's own right. I've read up and found that they display in the order they appear in the data fields area but, of course, calculated series don't appear in that area.Is there any way I can achieve this?Thanks in advance (but only if you're able to bend reality to my whim)Thu, 26 Apr 2012 08:39:41 GMTFunkyDexterhttp://www.sqlservercentral.com/Forums/Topic1287812-147-1.aspxHi FriendsI have one requirement, I'm pulling data from OLEDB source and need to place in excel file, as you know this is simple but what I need is for each time when I execute the package I need to place the data to different path. I have tried the below steps:1)I have created the excel connection manager.2)Created a package level variable and gave the path and file name same as the one created in the excel connection manager ( say c:\Folder1\Myfile.xls)3) Executed the package I got the result in this path.4) Before my 2nd execution of the package I have changed the path to c:\Folder2\Myfile.xlsBut the problem is I'm getting the error as the file is not existing there, even though I have made the delay validation true Im getting this error. Any way to resolve this?Sun, 22 Apr 2012 12:14:48 GMTonly4mithunchttp://www.sqlservercentral.com/Forums/Topic1290590-147-1.aspxI wish to make a change to MsDtsSrvr.ini.xml in order to add another directory for the "File System" packages. However, whenever I go to save the file after making the change, I get an "Access is denied." error. I have tried stopping the Integration Service, but that still does not allow me to save the updated MsDtsSrvr.ini.xml file. Please advise...Thu, 26 Apr 2012 05:58:00 GMTzthamiltonhttp://www.sqlservercentral.com/Forums/Topic1288540-147-1.aspxThanks in advance for your suggestion!!My Question is i need to load the data from one table to my destination table regularly and i need only to add the newly added rows at source to my destination regularly ..so i like to hear from u all with any advice ..on this topic ..Mon, 23 Apr 2012 15:17:26 GMTRamStevehttp://www.sqlservercentral.com/Forums/Topic1289537-147-1.aspxHow to run sql server agent job by using ssis package, means which ssis task have to use.Tue, 24 Apr 2012 22:38:48 GMTkishore.sqlbihttp://www.sqlservercentral.com/Forums/Topic1288073-147-1.aspxHi Friends, User ABC has a login in SSRS with name(Domain\ABC), later his loginname was changed to employee code (like Domain\512334), But still some meta-data columns like(Modified by,Created by) show old login name(Domain\ABC) rather than new one (Domain\512334).I suspect this might be due to cache, so I restarted the Reporting server , still no luck.I have also made changes to the login name in dbo.users table in Reporting Services database.Could you please help me on this.Mon, 23 Apr 2012 05:16:48 GMTvino5786http://www.sqlservercentral.com/Forums/Topic1287897-147-1.aspxHello friends, clarify me one thing, Unified Dimensional Model is either physical layer or virtual layer between data sources n client tools,what are the roles of UDM?thanks in advance friendsNiharikaSun, 22 Apr 2012 23:18:32 GMTniha.736