Recent content by ton12

Hi SQLBill, Thanks for your suggestion. I tried with square brackets but still doesn't work. Tony

I'm using SSMS 2008 which points to : "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

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

Thanks guys

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

The data types of the variables are defined as 'String'

Hi, Here is part of the code : Dim Delimiter1 As String Dim Delimiter2 As String Dim TextLength As Integer Dim TextLine As String Dim Line As String Dim fs As New FileStream(FileName, FileMode.Open, FileAccess.Read) Dim sr As New...

Hi, here is part of the code : ----------------------------------------------- Line = TextLine.Replace(Delimiter1, Delimiter2) ind = Line.ToString.LastIndexOf(Delimiter2) ---------------------------------------------- Delimiter1 - é Delimiter2 - | line is "11111é2222222é333" Thru debugger...

Thanks. I'm writing the info to a file. I have no error message but it is not replacing the "é" by '|'. Instead, it is being replaced by a special character (a square). Any suggestions? Ton

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...

Thanks fo the data flow task solution but I need to cater for different table names. I might have to copy Tab2 or Tab11 to Oracle but I w'ont know in advance the table name that needs to be copied. The matching table name will exist in Oracle. The value of the table name to be copied is...

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...