| Author |
Topic |
|
hellilyntax
Starting Member
19 Posts |
 Posted - 2006-08-17 : 00:02:01
|
| im using windows XP Pro SP2i need to connect to my SQL Server 2005 on internet to configure a DTS function.the problem is, when i connect using SQL Server Management Studio Express, it didnt have DTS wizard.I tried to install SQL Server 2005 client on my PC but failed.i read SQL server 2005 requirements, it says cant be run on winxp...is there any other way? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 00:14:26
|
| You can install developer edition of SQL Server 2005 on your PC.Tara Kizer |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-17 : 00:56:55
|
| sql 2005 doesn't have DTS. It was replaced by Integration Services (SSIS). Is that what you meant?-ec |
|
|
|
hellilyntax
Starting Member
19 Posts |
Posted - 2006-08-17 : 11:40:53
|
thanks guys...its getting more complicated here...it seems like i dont have a chance to use DTS because my server admin says only administrator can use that feature. db owner didnt have right to use it. fyi, my server is located at hosting company. they only grant me little rights.time is running out now...i have to think other ways.i have codes to read through excel rows and export it to SQL Server table using common SQL statement (INSERT). it may take a bit longer than DTS/SSIS but it is the only way.  there still a problem using this method.do you know how to run sql directly at server side from my VB client?my stupid idea thinks about to have VB client run the webpage contains the sql query. it may take long time. im afraid the script will timed out. do you have other idea. im totally stuck here... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 12:31:05
|
| I don't understand what you need to do. Please explain.Tara Kizer |
|
|
|
hellilyntax
Starting Member
19 Posts |
Posted - 2006-08-17 : 12:53:43
|
| sorry tara,ok..i write a vb6 program to upload Excel file to web server.after the file was uploaded, i need to transfer the excel data to SQL server.i plan to use DTS but the administrator at hosting company said they dont grant right to customer to use DTS, so i have to let it go.im thinking other ways to rip data in excel and insert into sql table.do you have any idea? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 12:59:16
|
| You can also use bcp.exe. As long as you install the client tools on your client machine, you should be able to use bcp.exe. It's a command line way of importing and exporting data.Tara Kizer |
|
|
|
hellilyntax
Starting Member
19 Posts |
Posted - 2006-08-17 : 13:05:19
|
| what is bcp?forward me some references... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 13:10:35
|
| SQL Server Books Online describes bcp.Tara Kizer |
|
|
|
redzex
Starting Member
3 Posts |
Posted - 2006-08-23 : 03:20:39
|
| You can use some connections from vb6 to SQL Server to minimize processes. it will not time out (",) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-23 : 13:42:18
|
quote:
Originally posted by redzex
You can use some connections from vb6 to SQL Server to minimize processes. it will not time out (",)
Could you provide some more details on this? Your statement is very vague.Tara Kizer |
|
|
|
|
Using DTS