Recent content by zhonghandle

Yes, I tried the import wizard and it works just fine. However, since the csv file name changes day to day. I have to create a script that automatically load the .csv files. So this is what i did: objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & FilePath &...

Thanks. I created the table and assigned the column type to be varchar for column C3. Then, I used Microsoft.Jet.OLEDB.4.0 to query the csv file and assign the results as a recordset. And the string value '8C' still doesn't get loaded. I used the VBScript code in a DTS package. Since the csv...

Hi, I am trying to load the following csv file: C1,C2,C3 1 ,M ,5 2 ,W ,1 3 ,M ,8C Where C1, C2 and C3 are column names. When I load the file using Microsoft.Jet.OLEDB.4.0, the table in SQL server looks like the following: C1,C2,C3 1 ,M ,5 2 ,W ,1 3 ,M , Which 8C missing. Can anyone tell...

Hi, I have two tables (t1 and t2) of same structure. The contents of two tables are different. Now I have to create a materilized views that append t1 and t2 together. Since materilized views do not allow 'Union', do anyone has a way to handle this or know any work-arounds? Thanks alot in advance!

Hi, I am using a DTS package-ActiveX task to call a SQL server database through a MS provided ODBC Driver, and my SQL statement has included a long Transac-SQl statement. In which a cursor is used. I can only use up to 69 records in the cursor, and the last 5 records loaded to the cursor were...

thank you for your reply. But what I intended to ask is that how to insert the value of a global variable into a "Execute SQL Task" of a DTS package. Thanks alot.

Hi, Suppose I am currently connected to a database "data1" (not the local server), and I want to make a connection to one of the tables (say, the table name is "table1") using VBScript code in a DTS package. How exactly should I do that? I have tried to create a ADO object...

Hi How can I change the owner of tables from "owner" to "dbo" using a script or stored procedure? If I have 60 tables, it is inpractical to change them manually, so is there a way to change it all together? Thanks in advance.

Hi, How to update a table using DTS? Say if I want to change all records of column c1 of table t to be 1, what should I do? Thanks~!

I don't know if the following link can help you, but I have had the same problem, and this site helped alot. http://www.swynk.com/faq/sql/sqlfaq_development.asp#variable and then go to "How can i issue a SQL command that uses a variable for the tablename, columns etc.?" and then use a...

Hi, Is it possible to do a MINUS option between tables in SQL Server? Like, (Select * from tableA) MINUS (Select * from tableB) assuming that both tableA and tableB have same number of columnes? Thanks alot in advance.

hi, I am running into a problem that, suppose table A has 10 columns and I want to access one column each time, at the same time keep track of what column that is. For example, I will get all the data from column "c1" and put the summary of the data, say "15" into table B...