Answer Questions

• xrayb Package running other packages

  Hi everybody, I have to create a package that executes other packages I've already created... Every one of these packages run with the same Configuration File, but if I try to execute the main one, including the path of the file, I get errors from the other packages because they can't find it... How can I manage to pass this file and its content to the other packages Here a little explanation of te process: Main Package needs confi ...Show All

• AlHenCoon sql server agent job execution of a package failed

  Hi, when I try to run a package as Job I receive the following error Executed as user: SITA\sqlserveragent_svc. The package execution failed. The step failed. Has someone an idea how I can get more detailed information about WHY the job failed Tha package was created in BIDS and imported into MSDB. Running the package from the Integration Services context menu works, but starting it as a job from SQL Server Agent fails. Any idea or ...Show All

• gebhartj The underlying connection was closed: Could not establish trust relationship with remote server.

  Hi, I am installing reporting services sp1 in loadbalanced servers. I keep on getting this error upon installation and upon configuration of target url in the config files. The underlying connection was closed: Could not establish trust relationship with remote server. Its not with the ssl since the ssl uses the full dns and is valid. So i was wondering what else needs to be done to fix this error. Thanks! karen ...Show All

• PradeepSattikar Viewing the report footer in layout view

  I have a basic report with one table in the body. I need to add a report footer based on a different dataset. I set up a new dataset just fine, but I don't see the report footer section in layout view. I looked in report properties, tools, view, edit, add..... how do I insert/add/view a report footer (not page footer) Thanks In SSRS 2005 Report Designer, there should be a Report Menu on the menu bar ...Show All

• irrdev connecting to sql server from mobile device

  How can I connect to sql server from a mobile device the server is on pc and my app is on the device. I want to perform commands and stored procedures which will be performed online on the pc and get immediate results. is there any way of achiving that That usually means DB collation you're using is not supported on particular device. You can change collation of this DB or get localized device which supports ...Show All

• Bruce Williams raw file destination and environment variables

  when using a raw file destination it would be nice to be able to use an environment variable for the filename property. like %my_extract%\data.txt instead of c:\my_extract\data.txt Now, I have. It worked fine for me. Have you had problems with it Here is how I did it: - Define RawFileName variable of type string on the package level - Add the Script Task and set its ReadWrit ...Show All

• Bonnie Colleen Running Total cursor

  I have two tables. ID table that has these fields Code_id,YearPeriod, ReachedDate fields. And table Amount that has Code_id,Amount,Date fields. What I need to do is write a cursor that when the amount.Amount adds up to $100.00 it Updates the ReachedDate in the ID table to the amount.date fields value of that record. Any help would be greatly appreciated. You shouldn't need a cursor. Try this instead, first create a view to give the total ...Show All

• mamma Error updating data in table that uses a trigger?

  Hello. I am new to SQL Server Management Studio 2005 and am using it to connect to a database on another machine running SQL Server 2000. Everything seems to work well, except when I try to edit table data on a particular table that has an update trigger associated with it. I am receiving the error: ------- The data in row 1 was not committed. Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) update ...Show All

• Anonymous Date Using File System task to move a file

  Hi All, I am having a problem using the file system task, what I am trying to achieve is to move a file after it has been processed . I am using a For each loop container to process bunch of files but I want to remove the files that have been processed after every loop.To achieve this I added a File System Task after my data flow task and was using the same variable used in the for each loop container as my source variable but the package is ...Show All

• AMaher What is the difference between Crystal report and SQL 2005 Report?

  hi, As default, VS2005 is able to create crystal report project, what is the difference between crystal report and SQL Server report I am trying to evaluate these same two products to determine which one to go with, and there is no info online comparing the two. Does anyone have a good reqource comparing features, or links to articles comparing the two products. These are two ...Show All

• xFors Interactive Sort within a Matrix

  Can't seem to make any kind of interactive sort work within a Matrix. Is it possible I've got the interactive sort to work in a Table. In a Matrix, the sort buttons come up, but they don't have any affect on the presentation of the data (columns). In the matrix, I think I've used every possible combination of Current Scope, Choose Data Region or Grouping, Detail Scope and the second Choose Data Region or Grouping. Any help or suggestions w ...Show All

• Derek Comingore - RSC Doing a SELECT on a different field than the field in the GROUP BY

  I'm using SQL Server 2005. I've got table tblSaleAddresses which looks something like this: AddressID   SaleID   Address1                  Address2                .....    DateEffective ------------   -------   -------------------       ---------------------             --------------- 1 ...Show All

• Ensynch unique code

  Hi all Problem Counter ID is not good because it gives information about the number of records, the next record.... So i want to obtain another unique code to store in another field of my table. I want to know some function to obtain a new code from the counter or other bases and which are very difficult to get inverse one. For example, if i have my counter 1,2,3,4,5,6,.... and my f(x) = x +100 my new code is 101,102,103,104 bu ...Show All

• gaile Visual Studio and SQL 2005

  Hi, I have installed Visual Studio 2005 (release) which installs SQL 2005 Express by default. Then I attmpted to install SQL 2005 Enterprise Edition (release) which resulted in a Set up message noting:   "SQL Server 2005 Setup has detected incompatible components from beta versions of Visual studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again." How ...Show All

• Serge Posudevsky Merge Replication with SQL Mobile Server 2005 / SQL Server 2005

  I am using Merge Replication to Synchronize a database on a mobile PDA. I create an empty table 1st using; "engine.CreateDatabase()" then sync with ; "replicator.Synchronize() " It works great the 1st sync, but subsequent calls to "replicator.Synchronize() " dont download new table changes at the server level to the remote PDA. I have found by calling ; "replicator.ReinitializeSubscription(True)" I can get new updates downloaded to ...Show All