Search results for query: *

XP Professional SQL Server 2008 - Developer Edition I have SQL Server 2005 installed and running fine. I installed SQL Server 2008 correctly, no error message. The instance is named 'SQL2008'. The Server is DELL-BDD3. When I connect to DELL-BDD3\SQL2008 thru SQL Server Management...

Hi, I have a simple package where I move the content of a table to a text file.I have enabled SQL Server logging to write to a database. (SQL Server 2005) The package runs ok but I do not see the table 'sysdtslog90' being created. Ton.

Hi, Any suggestion of how to automatically delete default views created (e.g view2, view3...). Thanks. Ton

Hi, I have four tables Tab1,Tab2,Tab3 and Tab4 and I need to create a fifth table using values from Tab1 and Tab4 but there are no common columns between Tab1 and Tab4. However, there are common columns beween. Tab1 and Tab2 Tab2 and Tab3 Tab3 and Tab4 Table Columns ---- -------...

I would like to store my configuration info in a SQL Server table. Can anybody point me to a url where there is an example of SQL Server package configuration set up. Thanks

I need to replace all column delimiters in a flat file by "|". I need to replace all "é" by "|". If the delimiter is any character to be replaced by "|", there is no problem, it works fine. But with special characters I have an error message concerning the Substring clause as it cannot cope...

I have a table TAB1 in SQL Server and would like to copy its content to a table TAB1 on ORACLE having the same column names and datatypes. The database connection to the Oracle database has been set and I can see the table. Any suggestions how to implement it in task...

I have Data Flow task to move Flat Files to a Table. Some of the files to be moved might be empty. I'm using a ForEach Loop container. I just want to ignore empty files or Files with size 0. Any suggestions. Ton

I have a table with two TIMESTAMP data type columns from a DB2 database. I need to convert it to SQL Server. I understand that only one TIMESTAMP column per table is allowed. Any suggestion as to how this conversion with two TIMESTAMP columns can be converted to a SQL Server table? Thanks. Ton

I have a script contained in a table called TABA. How can I run the content of a table TABA? It contains the following script: CREATE PROCEDURE PROCTest AS CREATE TABLE TESTA -- -- I would like to create a stored Procedure PROCTEST and a Table TESTA. Thanks for your suggestions. Ton

I'm using master..xp_cmdshell to run simple.sql which is a file containing 'Create Procedure TESTPROC '. The command works fine but it creates TESTPROC in the Master database. I want the procedure TESTPROC to be created in a database called DB1. I tried DB1..xp_cmdshell but didn't help...

XP Pro and Visual Studio 2005 I'm trying to create a package. Once I click on the Data Flow Task tab and try to drag and drop a Flat File Source or OLE DB Source from the Toolbox, I'm getting these messages : 'This task does not have a custome editor' or 'The editor for the selected...

Hi, I have done a full backup of a database on a 2005 Express Edition and I'm trying to attach it to a 2005 Standard Server. When I try to attach it on the target server, it is looking for the .mdf file but I didn't copy the .mdf file. I just used the backup feature on the Express edition...

I'm installing SQL 2005 on XP Pro. It fails as it cannot find ASPNET account. I've checked the user accounts and in fact the ASPNET account isn't there. XP Pro has just been installed on this machine. Could anyone tell me how does the ASPNET account get created. Thanks. Ton

Windows Server 2003, IIS 6.0. My asp-based website was working well. I had to reboot my server but since the reboot I'm getting the following error message : "The system cannot find the file specified" when trying to access any 'asp' pages. All HTML pages are fine. I have tried a simple...

Moved to a new server (Windows 2003 web edition)and also moved from MSDE to SQL Server Management Studio Express 2005 I'm new to SQL Server Management Studio Express 2005 and just created a user database. When I'm trying to access it thru my .asp program thru a website, I'm having the...

The code below is an extract of ActivexScript within DTS where the values match but does not return the expected result. ------------------------------------------------------------ SqlCommand3 = "Select 'countRec'= count(*) from Tab1 where SysKey = "&" ' " & SystemKeyVal &" ' " set Flds3 =...

Hi, I need to copy empty files with wildcards from a folder to another and then delete the files from the input folder using a Stored Procedure. Any suggestions welcome. Regards. Ton.

Hi, I'm processing a number of files from a folder.If the first file has a size 0, I want to stop the task but wish to process the other files. I'm using the following code in the Workflow properties. --------------------------------------------------------- Function Main() Dim oFSO...

The script below writes to a file when all the values of 'column2' = 'TEST'. If it's true, no problem, the file is created otherwise I get 'Invalid pointer' error : --------------------------------------------------- IF (SELECT COUNT(*) FROM TABLEA where substring (column2,1,4) =...