Answer Questions

• Bagpuss Using variable of Foreach loop - File Enumerator

  I have a Foreeach loop container that is looking for all the files in a specified directory. For each file in the directory I need to open the file, extract the contents, and pass the contents as a variable for a stored procedure call. I was able to loop thru the files in the directory and see each file and store the name to a variable. I was able to use an XML task to open one file via a file connection that connects to a specified file ...Show All

• tcochran64 SSIS as Reporting Server Datasource

  Hi folks! I read through Donald Farmers "Scripting SQLServer 2005 Integration Services" and downloaded the Bonus Chapter B. I created a custion SSIS package and wanted to use it as a Reporting Server Datasource. But my problem was type "SSIS" was not an available choice. I am using the Standard Edition of SQL 2005 Reporting Services. Do I have to register anything Thanks in advance :)) Thanks a lot :) ...Show All

• briankaiser Is SSIS slower than DTS????!!!!!!

  I am new to SSIS and probably doing some mistake while transferring data from oracle source to oracle destination.   Please guide me..   In our project we need to transfer nearly 80 GB data from old system (Oracle 9i) to new system (Oracle 10 G Release 2). To do this exercise we are testing and comparing performance and cost effectiveness between different tools like SSIS, DTS and SQL * Loader (oracle built in tool).   ...Show All

• kwilk Changes in SQL2005 syscolumns table

  It seems MS changed the way syscolumns table works.  It appears this is no longer a table, but probably a systemview.  Problem is, it looks like the autoval column is no longer working.  I was using this to determine whether a column was an auto incrementing identity field.  How should I go about determining a column's auto increment values Thanx, Have you tried COLUMNPROPERTY ( id , column , property ) using Is ...Show All

• Benjamin80 Problem with Large data amounts

  I have a dataset with 300,000 records and I'm getting the following error with MS Reporting Services.  "An error has occurred during report processing.  Exception of type System.OutOfMemoryException was thrown.  any help with this would be highly appreciated. I am having a similar problem with large data amounts.  My reporting server is a Dual Xeon 3GHz machine with 2.5GB RAM and still has ...Show All

• wooten Best way to handle License issues

  Here is the scenario: We are developing an ETL type data load application and we're thinking building a SSIS package to assist with this. The application and data files to be loaded would be on the client Windows XP Workstation. The SQL Server 2005 instance would be on a networked server elsewhere. The XP Workstation would NOT have sql server 2005. What is the best way to handle this Can this be achieved fairly easily Kevin ...Show All

• Joe9999 Hierarchy

  Hi to All! Is there a perfect method to implement a hierarchy structure with different types as a table in Sql server 2005 Currently I am thinking of this way: [Node | ParentId | ParentType | ChildId | ChildType] But there is this nagging little voice saying it can be better Cheers! Nele I had not thought of that solution. Thank you! Can ...Show All

• Miguel Gzz SQL Server Default Data Directory

  I would like to know how to change the default data directory in SQL Server Express. I have a partitioned hard disk with SQL Installed on the C:\ drive. I would like to move the data to d:\ drive. I have just installed SQL and do not have any databases. I have installed SQL with advanced services. Thanks in advance for your response. If you are using SQL Server Management Studio, navigate to the server propert ...Show All

• crazygrey A Problems after the install of the Hotfix

  After installing SP1 and then the hotfix: http://support.microsoft.com/Default.aspx id=918222 We now get the following error when trying to work with date parameters in Report Builder: Query (6, 117) The '[VBA].[DateSerial]' function does not exist. ---------------------------- Semantic query execution failed. ---------------------------- Query execution failed for data set 'dataSet'. ---------------------------- An error has occurred duri ...Show All

• TaegerD SQL Express Advanced commandline install

  I'm trying to install SQL Express Advanced Services from the commandline, but cannot get Management tools to install. Does anyone know the correct commandline to get this to work thanks, Daren I was trying to add SQL_Tools90 to the ADDLOCAL entry because that is the entry for SQL Std Edition. thanks, Daren Ah, ok, that's the problem. The tag for Management Studio Express is SQL_SSMSEE. Here is the snippet fr ...Show All

• XASD How can I use Microsoft SQL Server 2000 DTS Designer Components on X64 machine?

  Is there a X64 version of Microsoft SQL Server 2000 DTS Designer Components from Feature pack for SQL Server 2005 I have installed an X86 version on the AMD64 machine. But when I open a sql 2000 dts package, there is always a warning window. The Message is as follows: SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use t ...Show All

• Christiane-Annette Database Mirroring Monitor

  Hi there! I've some trouble with monitoring a database mirroring session. I am testing a lot configuration possiblities, and i use the database mirroring monitor to view the mirroring states. But in some (most) of my configurations, i only get following informations in the database mirroring monitor: Oldest unsend transaction, Unrestored Log, Current Restore rate and the Witness Adress. I am working in High safety mode with automatic fa ...Show All

• fwpi SQL 2005 changing default port no from 1433

  Just installed the 180 day trial of Enterprise SQL 2005 - does anyone know how to change the default port No - use to use Server Network utility in 2000 and a cycle of the SQL instance. From BOL: If enabled, the default instance of the Microsoft SQL Server Database Engine listens on TCP port 1433. Named instances of the SQL Server Database Engine and SQL Server Mobile are configured for dynamic ports, which me ...Show All

• agerman77 Not able to connect to server from SQL Server Management Studio

  After the latest security updates from Microsoft, a connection I had to a server in my local area network no longer works. I can log onto the machine sql server itself is installed on and use SQL Server Studio with no problem. However, when I try to connect from my desktop machine, as I've been doing for months with no problem, I get the following error An error has occurred while establishing a connection to the server. When connecting to SQ ...Show All

• Ben S How to include SSIS into install file?

  I've already read many topics that was asked about SSIS runtime, but for my purposes I didn't find satisfied answer Our clients don't use SQL Server for their data. But we anyway used DTS packages for transfering data between client DBes. Only thing that we needed to install was DTS dlls. What will I need to do now to use old DTS and new SSIS packages on these clients   Michael Entin SSIS wro ...Show All