Answer Questions

• iSreenivasRao.K Executing a package from within a C# program returns failure everytime

  Hi All, I am trying to execute a package (programmatically) that is stored on my local disk using the information that is provided on the following page: http://msdn2.microsoft.com/en-us/library/ms136090.aspx This means, I am using the Application object and the Package object to actually load the package using the path to it. So my code looks something like this: ----- pkgLocation = @"<package_path>/Package1.dtsx&q ...Show All

• Michael Tallhamer Performance Vs length of the data

  Using varchar we can define upto 8000 bytes as a length. Suppose i am defining one column upto the maximum size of varchar type and i am not storing not more than 100 charaters per row. what is the performance and storage differences This question belongs in one of the Sql forums. I'll move it there. Books Online might have an answer to your question (storage): http://msdn2.microsoft.com/en-us/li ...Show All

• - permood Record set to file

  Any tips on how to get a recordset into a file. I want the result of a stored procedure (multiple rows) written to a flat file.  I've tried a data flow task with an OLE DB Source linked to Raw File destination but that produces gibberish in the file - I need the raw rows returned from the s/p Any tips much appreciated. Greg. I understood SSIS was the new DTS. Any pointers on how I can go about this Mike G ...Show All

• Etheren Problem with SSIS Transaction...Transaction Scope

  Hi, I am having some problem with SSIS transaction. Eventhought I tried to imitate the concept that Jamie presented at http://www.sqlservercentral.com/columnists/jthomson/transactionsinsqlserver2005integrationservices.asp . My workflow is as followed ********************************* For Each ADO.Record in Oracle (transaction=not supported) If (Certain_Field_Value = 'A') Lookup Data in SQL DB with values from Ora ...Show All

• ef Extended Stored Procedures and VB

  I have two functions in a .DLL created in VB6 I want to use. I create two Extended Stored Procedures using: sp_addextendedproc 'MyFunctionA', 'MyFunctions.dll' sp_addextendedproc 'MyFunctionB', 'MyFunctions.dll' When I run: EXECUTE @ReturnValue = MyFunctionA @Paramate1 I get: "Cannot find the function MyFunctionA in the library C:\Program Files\MyDLLs\MyFunctions.dll. Reason: 127(The specified procedure could not be found.)" What am I missi ...Show All

• KDV ADO.NET Please Help ??

  ADO.NET is great But I have a problem I using Stored Procedures and UDFs to Insert and retrieve my data I can recieve a variable Only from UDF or Stored Procedure Put when the returned value is a set of records Whats the matter then and very especially: I need to know How to navigate through this set of records Next,Previous,First and Last Programmatically without Binding to Controls One of my Friends challenge me and Say :&quo ...Show All

• CSH Can This Be Accomplished in My Time Dimension in my AS2005 Cube?

  In my AS2005 cube, I have a time dimension with the following attributes: year, quarter and month. Also, there is currently no hierarchy by design. Is there a way to make a custom attribute/time period that reflects the last 12 months (R12M) and work in the same manner such as year, quarter and month The time dimension would then have: years, quarter, month and R12M. As a result, a user can drop a measure such as Sales Amt and then add ...Show All

• MikeMSDn SQL 7 [DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error

  HI all I am facing a problem on sql server 7 Desktop Engine with front end VB6 and ADO 2.8 my OS is windows 2000 Professional. ie. I am doing appendchunk to add image files on SQL Table it works fine for Approximately 130 MB, But i am trying to add 249 MB size file it will be showing these error Message. [DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error check your network documentation. I do so ma ...Show All

• Amjith MySQL OLEDB Driver

  Hi! I have a small question, there are OLEDB drivers availible for .NET on the MYSQL download site. But when I install them I'm not able to see them inside SQLIS, I've tried them inside Visual Studio and they work fine. Is there a way to get them "registred" or add them as a reference inside SQLIS so that I may choose them when setting up an OLEDB Source / Destination Don't think that's the problem, I think the problem is that the driver ...Show All

• Benjamin gomez Hiding the Find option in REPORT Manager - Viewing report

   Hi, I want to suppress the "Find" option in Report Manager when I am viewing the report. Is it possible How can we do this Thanks in advance. You can do this by creating a custom CSS for the viewer toolbar, modifying the RSReportServer.config file to use this CSS, and setting the find section of the toolbar to display:none in the CSS file. I am planning on writing a blog entry for more details about this. ...Show All

• Omega147 RUNNIG A JOB???

  I HAVE A PROBLEM,, I``ve just deployed a package into my server..it runs without problems from my SSIS.. but when i set a job with the sql agent and the package to it,. the job just fails .. why any solution please somebody help me!!! yes, this question comes up a lot, I apologize for the confusion. We are working on a KB article to help explain issues around this. It should be ready within a few days. The short asnwer is that when ...Show All

• slodaddy In 2005, finding users who have context in a database?

  I know sysprocesses has the information, but I can't seem to find how this is done using the dmv's. sessions doesn have a db context, and requests is only active while activity is occurring. Thanks! This is a known limitation. None of the new DMVs expose this information. There is a bug already filed for this problem and we have some ideas on how to expose the information but not sure if it will be done in a service pack for SQL Server ...Show All

• sjayachandran77 SSIS Tasks

  Hi, I need some suggesstion regarding which SSIS tasks to use regarding my job in hand. Basically what I need is to extract data from joining multiple tables and then load to a particular output database. How I can go about it Thanks Are the tables in the same database If so you should write a SQL statement to do the join in an OLE DB Source Adapter. if they are not in the same database ...Show All

• Vivian "Package failed validation from the ExecutePackage task" error

  I have an SSIS package which calls two other SSIS packages as part of it's control flow (using the Execute Package task). Both packages are stored in the same parent folder on the same server. The first child package runs successfully, the second does not. It ran fine for days until yesterday. Not sure what I might have done. I have tried to delay validation and recreate the connection. No go. Has anyone else run into this. I am running SQL 2005 ...Show All

• JatinShah Merge Replication and Snapshot Isolation

  I was reading at the following page: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql2k/html/sql_replmergepartitioned.asp When SQL Server accesses the data in a table, it locks the data for the duration of the process to ensure the transactional consistency of the data during the process. I was wondering if it is possible to take advantage of snapshot isolation to allow me to avoid these locks Without snaps ...Show All