Answer Questions

• PolkaDance No column was specified to allow the component to advance through the file.

  Hello, I apologize in advance if this seems like a relative easy answer, however, I can't find it anywhere, and I can't figure it out personally, I am relatively new to SSIS and C#. I am attempting to write in C# a simple program, where I am taking a table from an OLE DB Source and transfering it to a comma delimited flat file. I have been trying to work through samples and other methods of help, but I continue to get stuck, and this is my latest problem. When trying to excecute I get the error: No column was sepcified to allow the component to advance through the file, for my flat file destination. I know what this means, I just do not know how to fix it. Below is my code so far. I highly doubt my code is the best it can ...Show All

• Eswans2000 Can I Use Non-empty Behavior for These Calculated Members?

  I still find myself extremely confused about using the non-empty behavior for calculated members. We have a series of calculated members that we refer to as "Velocity", such as "Velocity Sales". The basic definition for these velocity measures is to get the total from the previous 63 business days and then annualize that total (i.e. multiply by 4), with the 63rd business day belonging to the previous month. For example, Velocity Sales for any day in September 2006 would be totaling the sales $ for the business days in the range of 06/05/2006 through 08/31/2006, and then multiplying it by 4. Perhaps not surprisingly, these measures result in extremely poor performance. Since I'm confused on the non-empty behavior, this p ...Show All

• GaboG RS 2005 - Report model using Analysis Services?

  Hi, Does anyone know if its possible to create a Report Model that can use Analysis Services as a datasource Im using RS 2005, connecting to AS 2005. I've looked into creating a report model, which requires a Data Source View. It seems that you cannot create a Data Source View based on an Analysis Services connection - as far as I can tell. Does anyone know if AS data can be used in a model Many thanks Jeremy Thanks for the replies. I have finally found a way to do this. You can: 1.Go into SQL Server Management Studio 2.Right click on the Models folder and create a new Analysis Services datasouce 3.Then you can right click on the new AS data source and select 'Generate Model'. ...Show All

• Bill Baker Definition of Object Has Changed Since it was last compiles

  All I'm having a weird problem.. I have 2 stored procedures that run 98% of the time without any issue but inconsistenly through the following error. 'The definition of object 'proc name goes here' has changed since it was compiled' We have adding 'with recompile' to the proc but we still get this error - but not consistently. The stored proc is not changing nor is the table structure of any of the objects that are being used in the sp. Any idea to trace down the why this is happening or what objecte it thinks is changing Let me know your thoughts. Ken We've started experiencing this, except: - It's occurring 100% of the time on SQL 2K5, for a particular data set, but not for another data set ...Show All

• Polar Bear Executing a whole container in one transaction

  Hello all, I am trying to build a package running a container that includes several tasks: 2 Execute SQL tasks and a data flow task. I would like to execute this container in a single transaction, which means that if any of the tasks fail, no changes are been made by the container execution. To achieve this, I have followed the instructions of how to configure the DTC on the server and locally, and set the container's TransactionOption Property to "Required". The problem I encounters is that when using a dataflow task in the container, the running process runs OK until it reaches the dataflow task, then it just gets stuck (marking the task in yellow). When removing the dataflow task, left with only Execute SQL ...Show All

• ZZia CASE When Then returns unexpected result

  My View needs to return a field called Process_Failure based on a number of conditions related to: TED.Duration, PU1.PU_Desc, TEF.TEFault_Name, ER1.Event_Reason_Name TED.Duration = 720 PU1.PU_Desc = 'MHFN-300-004-030: Stretch Wrapper 4' TEF.TEFault_Name = 'Stretch Wrapper Mtr OL' ER1.Event_Reason_Name = NULL Returns a value of 0, and I don't understand why. Any help would be most appreciated. From my View: CASE WHEN TED.Duration < 10 THEN 0 WHEN TED.Duration > 10 AND PU1.PU_Desc like 'Sch%' THEN 0 WHEN TED.Duration > 10 AND rtrim(ltrim(PU1.PU_Desc)) like '%Speed' THEN 0 WHEN TED.Duration > 10 AND rtrim(ltrim(PU1.PU_Desc)) like '%Tracking' THEN 0 WHEN TED.Duration > 10 AND rtrim ...Show All

• Tony Hild how do i strip the time portion from the getdate() value?

  the ssis expression language getdate() function returns the current date with the current time. i only need to get the current date, without the current time. for example: 9/1/2006 how would i construct the proper expression to return this value thanks in advance. (DT_WSTR,2)DATEPART("dd",getdate()) + "/" + (DT_WSTR,2)DATEPART("mm",getdate()) + "/" + (DT_WSTR,4)DATEPART("yyyy",getdate()) use convert(varchar(10),getdate(),101) ...Show All

• le_sash Problem On Store Report Parameter in Subscription ( by custom UI)

  I wrote a interface on my website about create/update subscription . when I get the parameter back by using GetReportParameters () the value was swap for example: I have 8 reportparameter: tcust, fcust, fdnnum, tdnnum, fdept, tdept, fairline, tairline. all of them are string when I create the subscription by: tcust 1 fcust 2 fdnnum 3 tdnnum 4 fdept 5 tdept 6 fairline 7 tairline 8 then I get back that subscription the value will be : tcust 2 fcust 3 fdnnum 8 tdnnum 5 fdept 1 tdept 7 fairline 4 tairline 6 are there any order for storing the ReportParameter[] thank you You should not rely on order. ReportParameter has property Name which can be used to identify the parameter. See sample code ...Show All

• Joos Refresh cube after data changed?

  After I created a cube in BI Studio, I added more data to the fact table, modified dimension table, and refreshed DSV. I got Refresh Data Source View message ‘No changes have been found’, but I didn’t see the data that I just added in from cube browser. (Database connecting and database structure didn’t change) My questions: Is refresh DSV only for database structure change Which step I was missing for refreshing cube data Thanks in advance. Yes, refreshing is to pull database structure changes into the DSV. To get the new data, "Process" the cube. You'll find that MSAS provides a rich set of capabilities and abilities to update the data ...Show All

• Psycho Potato PAGE_VERIFY setting CHECKSUM - how to detect?

  Does anyone know how to detect the CHECKSUM setting of the PAGE_VERIFY database option (2005 only) BOL (ALTER DATABASE) includes the following statement: Actually, I was looking in sys.sysdatabases! sys.databases is just fine.... ...Show All

• Jeff Williams Unable to view the updated Data

  I am executing this code from asmx.vb page in ASP.NET It is not giving any error It is taking some time to process this request. But I am not able to see these changes in the cube's data Please help! I am using Following code to update the cube. Dim str As String Dim cnn_oledb As New OleDb.OleDbConnection(strOLAPConn) Dim s As New OleDb.OleDbCommand(str, cnn_oledb) str = "UPDATE CUBE [DEMO] SET ([MEASURES].[BY],[center].[Ames Research Center],[Budget Year].[2007]).VALUE=5" cnn_oledb.Open() s.ExecuteNonQuery() Thanks in Advance cnn_oledb.Close() Any Help Please! I am using ASP.Net 2003 I am using it in asmx file. Thank You Darren for your response ...Show All

• Mercury529 Copy Database Login Timout Expired

  Hi, I get the following error when I use the Copy Database Wizard. Tried searching for solutions but didn't find anything. One thing that caught my attention during the wizard was the "Package Location" dir. In my wizard it is greyed out and when I go to look on the server, that is where I am copying the database onto, that directory doesn't exist. Maybe that is causing it I don't know. Really frustarted here. This looks like a very generic error to me but I don't know where to look because I'm still a M$ server newbie here. Thanks for your help. TITLE: Copy Database Wizard ------------------------------ While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Login timeout expired ...Show All

• Rame Unable to install SQL Server 2005 SP2 - Unexpected error (error 1635)

  I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files". O/s: Windows Server 2003 SP1 Product: SQL Server 2005 Standard Edition Log file shows: +++++++++++++++++++ === Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:\SQL2005sp2\hotfix.exe === MSI (c) (74:68) [16:05:42:635]: Resetting cached policy values MSI (c) (74:68) [16:05:42:635]: Machine policy value 'Debug' is 0 MSI (c) (74:68) [16:05:42:635]: ******* RunEngine: ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI ...Show All

• doczap alter table MyTable with check check constraint all

  Hi Is it correct to use the following statement : alter table MyTable with check check constraint all to reenable all the foreign keys and check constraints on a table after a bulk load best regards, Thibaut Barrere (follow-up from this on the ssis forum, but it's more a tsql question, hence my post here). yes.. You can do this.. Advantage for disabling the constraint on bulk load is to increase the performance.. But if any data conflicts with your constraint you can't reenable it again.. Hi the SQL server destination in SSIS disables the constraints itself when the check constraints checkbox is disabled. Running the alter with check check all seems to work just fine, and properly ...Show All

• Sundar.Iyer OS backup

  Hello. New MSSQL guy coming from Oracle.  I've read and understand that you can create backup files for a database using the server management studio. However, I'm wondering if that is really necessary.  Suppose I do not care about the loss of transaction logs, is copying the .mdf database files via OS command a viable backup strategy If so do I need to bring down the database engine before starting the file copy Thanks a lot Thank you Kevin. Our production operations run on Oracle systems. We have to run 1 small MSSQL instance since some MSFT application only use that. So, I'm not really concerned about that DB's size, around-the-clock availibility, or point-in-time recovery. Given the above ...Show All