InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 05:48:37 GMT20http://www.sqlservercentral.com/Forums/Topic1465030-147-1.aspxI want to process my cube daily night so I create a job for that by follow these stepshttp://www.symantec.com/business/support/index?page=content&id=TECH193699But when I run it it gives me following error[b]The job failed. The Job was invoked by User domain\username. The last step to run was step 1 MessageExecuted as user: domain\username. Microsoft.AnalysisServices.Xmla.ConnectionException: A connection cannot be made. Ensure that the server is running. ---> System.ComponentModel.Win32Exception: The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail at Microsoft.AnalysisServices.Xmla.XpressMethodsWrapper.SetDelegates() at Microsoft.AnalysisServices.Xmla.XpressMethodsWrapper.get_XpressWrapper() at Microsoft.AnalysisServices.Xmla.CompressedStream.get_XpressWrapper() at Microsoft.AnalysisServices.Xmla.CompressedStream.InitDecompress() at Microsoft.AnalysisServices.Xmla.CompressedStream.Read(Byte[] buffer, Int32 offset, Int32 size) --- End of inner exception stack trace --- at Microsoft.AnalysisServices.Xmla.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) at Microsoft.SqlServer.Management.Smo.Olap.SoapClient.Connect() at OlapEvent(SCH_STEP* pStep, SUBSYSTEM* pSubSystem, SUBSYSTEMPARAMS* pSubSystemParams, Boolean fQueryFlag). The step failed.[/b]I trying it to by credential and proxy method but results are same.Wed, 19 Jun 2013 03:51:55 GMTarvindharitushttp://www.sqlservercentral.com/Forums/Topic1464164-147-1.aspxHi all.I need a good resource to figure out how to use For Loop Container in SSIS in order to do the following:1) Call up Procedure name from a SQL Table, looping through them one by oneProcedurenameExec proc1Exec proc2exec proc32) By executing them i will be getting result set which i need to insert it in to another tableTable structureThanks,ArunMon, 17 Jun 2013 08:14:06 GMTsignforarunhttp://www.sqlservercentral.com/Forums/Topic1464243-147-1.aspxHi I have a package which will be placed at a shared location and multiple user will execute it with some parameters. As users are non technical, I'll just provide a TQL script where they will specify parameters and execute it.Here is the script I have. The problem here is that I can't give xp_cmdshell permission to all users for security reasons. I have tried putting it in job and then giving permission to run job. I also tried putting it in proc and giving EXEC permission. BUt seems none will work unless I give permission on xp_cmdshell. Is there a work around to this? Declare @cmd varchar(1000) DECLARE @DBName varchar(50)='MyDB1'--Change DB Name here DECLARE @TableToBeLoaded_1 varchar(100)='MyTable'--Specify 1st TableDECLARE @PackagePath varchar(1000)='D:\temp\' DECLARE @MinWeekID int=0 DECLARE @MaxWeekID int=0 SELECT @Cmd = 'DTexec /FILE "' + @PackagePath + 'Package1.dtsx" /MAXCONCURRENT 1 /REPORTING EW /DECRYPT abcd'+' /SET \Package.Variables[User::DatabaseName].Value;"' + CAST(@DBName As varchar(50)) + '"'+' /SET \Package.Variables[User::MinWeekID].Value;"' + CAST(@MinWeekID As varchar(5)) + '"'+' /SET \Package.Variables[User::MaxWeekID].Value;"' + CAST(@MaxWeekID As varchar(5)) + '"'; print @cmdEXEC xp_cmdshell 'DTexec /FILE "D:\temp\Package1.dtsx" /MAXCONCURRENT 1 /REPORTING EW /DECRYPT abcd /SET \Package.Variables[User::DatabaseName].Value;"ProjectDB3" /SET \Package.Variables[User::MinWeekID].Value;"0" /SET \Package.Variables[User::MaxWeekID].Value;"0"';Mon, 17 Jun 2013 10:08:20 GMTS_Kumar_Shttp://www.sqlservercentral.com/Forums/Topic1463688-147-1.aspxDataset 1Name record amountfrank 234 1500Davis 235 10000Dataset 2Location City California San franciscoNew York BronxI am wondering if there is a way to export both datasets to the same file in ssis.File will have both datasetfrank 234 1500Davis 235 10000California San franciscoNew York BronxFri, 14 Jun 2013 10:48:23 GMTf9c882q 61644http://www.sqlservercentral.com/Forums/Topic1458462-147-1.aspxI come from Cognos, and try to understand how users can view and manipulate cubes once they are created? do users need sql licensees to view cubes? Thanks.Thu, 30 May 2013 14:34:35 GMTshanghaigirl-1125377http://www.sqlservercentral.com/Forums/Topic1462650-147-1.aspxHi Friends, i am just trying to load 100,000 recrods into a table. But i have a weird situation where my data is not loading. data flow starts to load but then i don't know what is going on..it seems like got stuck....i waited for more than 30 minutes but it is not loading the data. i even checked for the table lock against the respective database but got nothing. Please help me, friedns. I have attached a screen shot.Wed, 12 Jun 2013 08:06:40 GMTprakashr.r7http://www.sqlservercentral.com/Forums/Topic1463595-147-1.aspxHi AllI need help with SSIS Conditional split. I have attached a create tbl script and test data.I need to split data in multiple columns so that i can use that data in SSRS. The issue is that the data is mixed up and vary in lengthThe column in mind here is "Client_user_agent", the split should have a Browser and Devices column. The first few characters they are terminated with "/" then a number then "(" in here it's either a device or a browser then terminated with ";", so thus far i need dataI hope it will make sense with test dataThanksFri, 14 Jun 2013 08:14:28 GMTsmthembuhttp://www.sqlservercentral.com/Forums/Topic517380-147-1.aspxHi every body, I am trying to get data in SSIS dataflow task from a strore procedure, but strangly i m getting this error"Error at Data Flow Task [OLE DB Source [1]]: There is a data source column with no name. Each data source column must have a name.Exception from HRESULT: 0xC0207016" However i have checked the output of my store proecdure and every column has a name, there isnt any coulmn, with no name, but the SP is complex having some case satatement and column alias...but surely every column has name.I wonder how to resolve this issue, i cant find any solution on web, i wonder wat is the problem and how to resolve this issue.Any help in this connection is highly appreciated.Mon, 16 Jun 2008 01:38:33 GMTrashid nizamhttp://www.sqlservercentral.com/Forums/Topic1458783-147-1.aspxFor some unknown reason, the creator of this file set the naming convention to something I can't begin to fathom... :unsure:The file name is like this: NAME1_NAME2_NAME3_NAME4_NAME5_YYYYMMDD_YYYYMMDDHRMMSS.YYYYMMDDHRMMSS -- Yes, twice...! And the folder continues to grow. So I need to pick up the most recent file...I have figured out ways to pick up a dynamic name that ends in CSV or TXT (*.csv or *.txt), but I have never tried to figure out a dynamic file type before. If it helps, the NAME#'s never change. Only the date/times change. Is there anythign I can do pick up the most recently added file in a folder where the file name and type continually change? Maybe a VB script???Fri, 31 May 2013 10:27:41 GMTSQL_Enthusiasthttp://www.sqlservercentral.com/Forums/Topic1462807-147-1.aspxI am execute package for test environment with new directory path and file name.But when I am trying to set value for package variable giving me error below."DTExec: Could not set C:\Paychex\Paychex\Paychex\Paychex_ClockDataPackage.Variables[User::FilePath].Value value to C:\tlo\."In package I am getting filepath dynamically from source side and loop through foreach loop container.now need to change filepath for test environment without opening package from execute package utility.and also attach screen shot file. Please help me with this ..I really appreciate your help....Wed, 12 Jun 2013 13:46:02 GMTzoom19http://www.sqlservercentral.com/Forums/Topic1462538-147-1.aspxHi ,I have developed SSIS Package in 2008r2 and when i am trying to run the DTSX package in SQL 2012, am getting error like'The component metadata for the script component could not be upgraded to the newer version of the component'. We have to verify this in two ways,one is either it may be proplem with ssis version or else .net version mismatch.i wrote a script component code in .net2.0 version and am trying to run that in .net 4.0 version in SSIS Package.Could you please help me in this problem.Wed, 12 Jun 2013 04:15:05 GMTthirumurugan_888http://www.sqlservercentral.com/Forums/Topic397300-147-1.aspxHiwhen I export report to CSV file through sql reporting, header row is included, but there is no header row in my report, how to suppress the header row when i export using CSV file format.Please let me know if any body knows.Thank you,RegardsVijayFri, 07 Sep 2007 08:24:00 GMTVijji-429978http://www.sqlservercentral.com/Forums/Topic1456764-147-1.aspxHi can anyone tell me how scheduled notification works.I tried to work on it but did not understand polling query and processing query concept behind it.Sat, 25 May 2013 00:22:12 GMTsej2008http://www.sqlservercentral.com/Forums/Topic1458957-147-1.aspxHii all;I deployed my report successfully (SSRS) , but when I click on it in the manager report to display it I receive the following message : [b]This data source is configured to use Windows integrated security, but it is disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)[/b]Please any idea to overcome my problem. THANKS.Sat, 01 Jun 2013 12:38:14 GMTSaturnem31http://www.sqlservercentral.com/Forums/Topic1460988-147-1.aspxI have deployed a report which has DateTime parameter on sharepoint server. The server is located in india. When i try to run the report (from india), i clicked on Calender icon which is beside DateTime Parameter. In the calender today's date is highlited(i.e., 7th June 2013).My client is in US, when he clicked on clender icon, 7th June 2013 date is highlited for him also. But he needs 6th June 2013 date to be lighted because for him current date will be 6th June.Is there any way that for users from different countries, datatime parameter will highlight their system date in calender.Fri, 07 Jun 2013 01:48:28 GMTprasanna-750812http://www.sqlservercentral.com/Forums/Topic435591-147-1.aspxI have created an SSIS package to copy the data from an Oracle database to SQL Server 2005. the package runs sucessfully from VS. When I try yo run the packge from the SQL Agent it starts successfully, but then fails when trying to copy the data from the Oracle database into my SQL Server staging table. The full error I receive is:Date 20/12/2007 12:12:18Log Job History (CODA Database)Step ID 1Server SSINT12\SQLS200564Job Name CODA DatabaseStep Name CODA Database UpdateDuration 00:00:14Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: SSIDEV\SqlServer. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:12:18 Error: 2007-12-20 12:12:32.00 Code: 0xC0202009 Source: OAS_BALANCE Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2007-12-20 12:12:32.01 Code: 0xC020801C Source: Data Flow Task Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2007-12-... The package execution fa... The step failed.I am using the Oracle 10.2.0.3 OLEDB driver for the source connection.I have also saved the package in SQL Server using the Encrypt Sensitive with Password option.Any ideas?Fri, 21 Dec 2007 05:42:28 GMTAndrew Lamberthhttp://www.sqlservercentral.com/Forums/Topic1461078-147-1.aspxhi all,I ave one question...I saw that in BIDS we had a Report Data Model on Visual studio 2008. after to upgrade to VS 2010 we dont have that option can you tell me if theres is another option tu se data model on reports? Thks Fri, 07 Jun 2013 07:38:52 GMTpedro.j.manuelhttp://www.sqlservercentral.com/Forums/Topic1460303-147-1.aspxHi, We have a project of having a kind of premade-standard-retailler-datawarehouse in the Cloud (hosted on a SQL Server somewhere, and with reports on that).We send a little software to different customers having the same source system, lets say SAP. Then, they download it, install it, enter the SAP connexion information, then click "EXTRACT MY DATA". The data is then extracted from the source system and sent over the web to my Cloud Datawarehouse. We may have 10...20..50...500 customers...depending on the strenght of the sales team...I want to have only ONE datawarehouse (ONE fact table and ONE version of each Dims). They will be partitionned over a key that uniquely identify each customers (ranging from 1 to ...).Note : [quote]I was thinking to create one database for each customers (lot of sense), or maybe on schemafor each customers in the same database (less sense),... but then I'll have to maintain 40 versions of everything (fact / dinensions)...not good.[/quote]So my fact table (and every dimensions) have this key (uniqueCustomerKey) to partition the data. One partition for each customer.My questions: [b] Is that make sense? [/b]Each customers wont have a lot of data in the fact table (max 3-4 millions of records each MAX).Do anyone see a major caveat in my solution?The fact table will then be clustered on the partitionKey + the date keyThe dimension tables will be partition also the same way (partitionkey + dimKey)thanks for you lights on that!SimonWed, 05 Jun 2013 09:48:20 GMTsimon 96831http://www.sqlservercentral.com/Forums/Topic1460837-147-1.aspxOK, I'm out of ideas on this one, hoping someone here has seen this before: I can connect to the .mdb file but when I run the task it crashes with an error saying it can't get a connection.Platform is Windows Server 2008 R2 running VS 2005 (yeah, I know but it's a contract job so there's nothing I can do about this). On this platform when I test my connection (OLEDB Jet 4.0 or Office 12) via the connection manager, it is successful. When I configure my OLE DB Source I can see the tables & columns from the MS Access DB. When I run the task or package it immediately crashes with:[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Office12" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. On my development machine (Windows XP, oh-yeah, workin' for the gov'mt here, and VS 2005) I can run this package successfully either as a task or as execute package. I can execute it using a connection via the Jet 4.0 provider. I've verified that I can open the .mdb and make changes directly.I've downloaded the Office 12 drivers. Same error whether I configure my connection via Office 12 or OLEDB Jet 4.0I've verified that the .ldb file can be created by the account executing the SSIS packageHow is it possible that SSIS can connect and show me the tables & columns in the .mdb but then crashes and can't acquire a connection when I execute the task?Thanks for any help with this!Thu, 06 Jun 2013 12:24:42 GMTFly Girlhttp://www.sqlservercentral.com/Forums/Topic1448731-147-1.aspxI want to build a DW and I need to identify records that have changed, and luckily each table in our ERP system has a timestamp/rowversion column, but I cannot see how to easily and efficiently compare the current rowversion value to one I could save to a staging table. I was planning a staging table to contain the unique ID of the table and the rowversion value which will allow me using the unique ID to find records not in staging but it is the edits I am having trouble with, as the rwovdersion needs to handled differently.What is the normal best practice for identifying changed records via a rowversion column rather than checking the values of say the 20 fields I am interested in, or it is best practice to not refer to rowversion at all and instead have something like this.insert into staging(f1,f2,f3,f4,f5)select live.f1, live.f2, live.f3, live.f4, live.5from liveinner join staging on live.uniqueid = staging.uniqueID AND (live.f1 <> staging.f1 OR live.f2 <> staging.f2 OR live.f3 <> staging.f3 OR live.f4 <> staging.f4 OR live.f5 <> staging.f5)There must be an efficient way to copy the rowversion value to the staging table and do an efficient join query, I would have thought.insert into staging(f1,f2,f3,f4,f5)select live.f1, live.f2, live.f3, live.f4, live.5from liveinner join staging on live.uniqueid = staging.uniqueID AND live.timestamp <> staging.timestampThanks in advance.Thu, 02 May 2013 02:50:28 GMTsotnhttp://www.sqlservercentral.com/Forums/Topic1425021-147-1.aspxHi allI have created a SSIS package that contains an OLEDB connection to a database using a SQL login on the server from which the package is running. This all works in Visual Studio 2010.I then scheduled this to run in a SQL job however I am getting an error of: An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E4D Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E4D Description: "Login failed for user 'XXX'.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E4D Description: "Login failed for user 'XXX'.". End Error Error: 2013-02-28 13:14:09.82 Code: 0xC020801C Source: Import XXX OLE DB Destination [2] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "XXX" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2013-02-28 13:14:09.82 Code: 0xC0047017 Source: Import XXX SSIS.Pipeline Description: OLE DB Destination failed validation and returned error code 0xC020801C. End Error Error: 2013-02-28 13:14:09.82 Code: 0xC004700C Source: Import XXX SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2013-02-28 13:14:09.82 Code: 0xC0024107 Source: Import Zetafax1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 13:13:54 Finished: 13:14:09 Elapsed: 15.693 seconds. The package execution failed. The step failed.I had thought his might have been the issue with the job step needing to run under a proxy, but I created a credential under me (I am an SA) and assigned the proxy to the job but I am still getting the same error. The account in question has permissions to the database, so am unsure what is happening?ThanksThu, 28 Feb 2013 06:22:41 GMTKwisatz78http://www.sqlservercentral.com/Forums/Topic1459449-147-1.aspxHi All,I created a SSIS package that check first whether the ID in the file being imported matches to an existing record in the database but I need to provide a second layer of checking based on Name and Address (lookup)because we also get sent existing clients under new ID’s that creates duplicates’ in the database.See example below –Flat file imports sample row below—ID First Last Address Postcode12345 James Peterson 5 Green SW14I use lookup to check that James does not already exist in the database under a different ID number by doing a lookup against the database by using Name, address and postcode to lookup –And If James is already under another ID number (like below) I want to update the new ID number with OLD number in the destination table on the database.Exist in databaseID First Last Address Postcode00001 James Peterson 5 Green SW14I now want the import file to use the database ID to import the data into the destination tableImported into the destination table in sql serverID First Last Address Postcode00001 James Peterson 5 Green SW14I also want to pass the change ID number into the other dataflow import files they also contain the same ID (see picture) with Old ID number so they can also update their destination tables with 00001 not 12345 and audit the changes made to the ID’s.I have been struck on this problem for a while! Any help Greatly Appreciated!!!!Mon, 03 Jun 2013 13:56:25 GMTazdejihttp://www.sqlservercentral.com/Forums/Topic915746-147-1.aspxHello, I have a several .xlsb (MS Excel binary) files with data that I need to import into a SQL db using SSIS. The Data Import wizard / SSIS data flow task is not letting me use the .xlsb files. Is there any way this can be done? I am using Excel 2010 /2007 files and SQL 2008Thanks,mcr132Tue, 04 May 2010 17:40:23 GMTmcr132http://www.sqlservercentral.com/Forums/Topic698464-147-1.aspxHi all,I've a query which is taking 10 to 20 sec when i execute it from SSMS.But when i execute the Report which is developed using the same sql query from report server, is taking 2 min to process.What could be the possible reason for the report server to take long time to execute the same query and why it is not taking that much time in management studio?Please suggest me how to improve the performance of report server..!Regards,RamuThu, 16 Apr 2009 08:03:45 GMTramu.valletihttp://www.sqlservercentral.com/Forums/Topic1457650-147-1.aspxHi every body,I created a report with SSRS without problem, but when I tried to deploy it , I received the following message :"The permissions granted to user 'PC-PC Acer \ Acer-PC' are insufficient for performing this operation."NB; I'm working on my PC acer-pc which is administrator, so I don't understand why i don't have permission.Please help me to overcome this problem which blocks me for a long time.Wed, 29 May 2013 04:23:27 GMTSaturnem31http://www.sqlservercentral.com/Forums/Topic1455932-147-1.aspxhi need your help regarding dynamically importing multiple flat files into different table of sql server database.the format of files are different for different files. its like importing 25 different files from a folder to 25 different tables of the database.thanks in advanceThu, 23 May 2013 04:31:03 GMTlakshyandahttp://www.sqlservercentral.com/Forums/Topic1457205-147-1.aspxHi Guys,I am a newbie and I need to do the following task:I have to process the rows in one table, get the column that has json string. I have to process this string and then enter this data into another table. I managed to do this by means of a script component.But I also need to delete this processed row once I have populated the row in new table. How do I achieve this (how to check whether data was written into the new table before I actually delete the row from old table)?Also, after I achieve this, I need to run a sql stored proc that generates temp tables in the the format that I need to export to excel. I think the 2nd task can be accomplished using "execute sql task" in the control flow section. Can someone point me to some example that makes use of passing parameters to the stored procedure? I have looked at very basic examples that do not help much.TIATue, 28 May 2013 00:51:59 GMTtrailblazerhttp://www.sqlservercentral.com/Forums/Topic1457120-147-1.aspxEstimados.Muy Buenos Dias, mi Pregunta es la siguiente:existe alguna opcion en ssis 2008 que me permita exportar un paquete (dtsx) o todo el proyecto a word,pdf,html o ppt para generar su documentacion?si existiera cual serian los pasos a seguir o de no existir la opcion existe alguna herramienta o programa que me permita generar esta documentacion.De antemano gracias por sus comentarios. :discuss:Mon, 27 May 2013 09:17:06 GMTrcherodhttp://www.sqlservercentral.com/Forums/Topic1455968-147-1.aspxHI,I have lots of SSIS packages and i have to make the column mapping sheet for the SSIS packages . I have tried the reading SSIS (DTSX) file from C# - dot net but i was unable to get the relationship between OLE DB Source and OLE DB Destination (SSIS Package) in Dot net .ISSUE :Let say i have a dts package and that packages have one ole db source and one ole db destination and in that i am transferring the data from source column to destination column so now i want to make the column mapping file like Ole db source A(source column )----------->ole db destination B(destination column) like this for all the column.Please tell me how can i do that using dot net.Regards,Anshuman SainiThu, 23 May 2013 06:07:41 GMTAnshuman Sainihttp://www.sqlservercentral.com/Forums/Topic1456765-147-1.aspxNot understanding the working of aggregation.what actually it does.can any have a an example to make it simple to understand.Thanks in advanceSat, 25 May 2013 00:23:44 GMTsej2008http://www.sqlservercentral.com/Forums/Topic727497-147-1.aspxI have an SSIS package that is trying to pull from an XML Source and into an OLE DB Command. My goal is to read the inputs from the XML file one "record" at a time, and then if the data isn't in the DB - push it in through the OLE DB Command. In my OLE DB Command I have set my SQLCommand property to be: EXEC Title_Change_Process @rowCount = ?, @HRtitle = ?, @currentTitle = ?, @facultyID = ? That's when I get the error: Parameters are not bound. All parameters in the SQL command must be bound to input columns. When I change the SQLCommand property to: EXEC Title_Change_Process @rowCount = 0, @HRtitle = ?, @currentTitle = NULL, @facultyID = ? (because I only need 2 inputs from the file - yet I have 4 variables in the procedure) I get the following error: Columns "Title" and "@HRTitle" cannot convert between unicode and non-unicode string data types. I've tried a bunch of other suggestions while researching this problem - nothing has worked - what can I do to fix this? I've only really just started using SSIS.Tue, 02 Jun 2009 09:14:27 GMThead_contusionhttp://www.sqlservercentral.com/Forums/Topic692785-147-1.aspxHi,Am getting error like "Operation is not valid due to the current state of the object" when i pass the parameters from reportview control.Description: I am passing the report columns and query parameters as parameters form WPF winform to display those columns in SSRS report.If i reselect the parameters from WPF Form and on click of view report button am getting this error "Operation is not valid due to the current state of the object " Plz help me to solve this problem.Wed, 08 Apr 2009 00:49:31 GMTnarihttp://www.sqlservercentral.com/Forums/Topic1453814-147-1.aspxMy case is very simple but I can't resolve the issue using SQL Server 2008R2 BIDS.I need to select out a list of managers from a table. Then use foreach loop container to loop through this list and feed to a stored procedure which takes 3 parameters (manager_name, date, interval) to generate a table, say saleperson's performance records under each manager.I used execute SQL task to get the list of managers first. The variables are: FullResultSet (data type is object), RepDate (Date), ManagerID (nvarchar). I tried both single and full result set. None worked.Next is the foreach loop. Use ADO enumerator, FullResultSet as source variable. Variable mapping both RepDate and ManagerID (with the correct order). Inside the container, I use execute SQL task to execute the stored procedure as myStoreProcedure ?,?,?. Parameters mapped as RepDate, ManagerID and Interval (this is in variable list with a default value).Issue: The foreach container looped the right number of times. However, the stored procedure never got executed. I didn't get any error message. So I don't know what went wrong? The project is due first thing tomorrow morning. If anybody could help, I'd much appreciated.Thu, 16 May 2013 17:21:47 GMTwhlyhttp://www.sqlservercentral.com/Forums/Topic1454208-147-1.aspxHi-I am very new, but ran into an issue with a filter all of a sudden not working. I applied SQL Server 2008 R2 Service Pack 2 and it appears to have causes a few dimensions to be 'unfilterable'-it brings back no results. Where can I start to dig to find my problem??Thank you,JesseFri, 17 May 2013 16:23:34 GMTjbrandenburghttp://www.sqlservercentral.com/Forums/Topic1453349-147-1.aspxWe have a table 'Sales' which is Fully loaded daily. Our target delivery is insert else update, So every time most of the records will be updated which is taking huge time (> 1 hour).We don't have a key in Source to make it incremental load.Multiple Users are using that table from different Location, So we cant truncate and load, also We cant use 'Switch' Option in sql server.We thought of the below approach. 1) Truncate and Load all the data in the 'Sales_Swap' table , This would be much better since it is just bulk insert.2)Begin TransactionLock Table SalesEXEC sp_rename 'Sales', 'Sales_temp';EXEC sp_rename 'Sales_Swap', 'Sales';EXEC sp_rename 'Sales_temp', 'Sales_Swap';End TransactionExperts, Please share your ideas whether the above option is good in ETL Prod environmentThanks in AdvanceThu, 16 May 2013 01:26:33 GMTSelwynRajhttp://www.sqlservercentral.com/Forums/Topic1453823-147-1.aspxI have a report whereone of the column called Cost is of number data type So below is the requirement If there are 4 rows out of which 2 has values and other 2 doesn't have values then it should display as below, remaining rows which doesn't have values should display as 0 Cost 200 900 0 0If for another ID the Cost is total NULL for all the rows without atleast one value then it should display as N/A as below Cost N/A N/A N/A N/ASo if atleast one row has value for that ID then it should diplay as 0 for other values, If none of the rows related to a particular ID has any value then it should display as N/APlease help with the expression in the SSRS report.Thu, 16 May 2013 20:11:50 GMTLucky9http://www.sqlservercentral.com/Forums/Topic1422084-147-1.aspxHi,I have one table called Student. The source for loading the table is StudentHistory.My Scenario is i have a single student having multiple records like single student mapped to several departments.Select distinct student,Department from Student gives 10 records.if i get 11th record from StudentHistory table it should check for student mapped to that department, if no add record to Student table.I applied Left outer join using mergejoin task in SSIS for this scenario. StudentHistory as left source and Student as right, when i am looking for the student & department, for matched rows also my Student table is returning null values.so that all the 11 records are getting inserted into Student table based on condition.What is the reason for retrieving all null values even for matched records?Wed, 20 Feb 2013 07:33:40 GMTdeepthipriya.ravihttp://www.sqlservercentral.com/Forums/Topic1421187-147-1.aspxHi All,I have a requirement like, Identify the out of sync records from two servers. I have Id's to pass from a sql server table, I need to identify the corresponding ID related data for each column in syn or not. If the data is not in syn then I need to maintain that data with column name in another table.Can Any one help me on the above requirement.ThanksMon, 18 Feb 2013 06:50:02 GMTTony1234http://www.sqlservercentral.com/Forums/Topic1453261-147-1.aspxHi, I am using SSAS 2012.I have been asked to see if it is possible to change the measure depending on the dimension being used in the report.For example. If i have two measures in my cube, say "Sales" and "Orders". Is it possible to introduce a third calculated Measure lets call it "Amount" and the value of "Amount" is "Sales" when the dimension is "Customers" but it's "Orders" when the Dimension is "Products".It sounds a bit odd i know, the actual scenario is a bit more complicated but this is the bit i'm not sure about. Any pointers greatly appreciated.ThanksBob.Wed, 15 May 2013 13:43:16 GMTbob pearmanhttp://www.sqlservercentral.com/Forums/Topic1453116-147-1.aspxHi,The source file format in CSV, lets assume it has following dataid name marks1 a 1002 b 90I have created flat file connection manager to read the source file and I have created a table with ID and Marks column and mapped in OLE DB mapping, though when I run the package, it loads id and name values instead of id and marks data.please help? ThanksKJWed, 15 May 2013 08:08:46 GMTvijayakumarkj-602216