December 3, 2002 at 9:01 pm
Hello All
I have a problem.
We have a file that will be uploaded to the webserver whenever there r changes made to the file.
Now we have to get some columns of the file and put that data in our table in the database. Now since this is done through a HTML page and the connection to the DB server will be normal user i am not able to run the DTS package from the store procedure, as the member of sysadmin user will only able to run "dtsrun" utility.
Does any 1 know how do i do this. What i have done is created the stored procedure and which will run the job and the job will run the dts package. Can any1 tell me the solution, abt how do go abt it. Is there any better way to do it.
Regards
Jay
December 4, 2002 at 5:39 am
December 4, 2002 at 9:19 pm
Can any1 tell me what will be the field and row deliminator for a Visual Fox pro "dbf" file. So i can just do the Bulk Insert facility (as u need to give row and field deliminator inthe command)and so i need not create any proxy account for jobs which has cmd script steps.
Ya the xp_cmdshell works fine, but it does not work if ur SQL Server is running on Domain Controller PC and also if the Log on Service is the Domain Controller account. This is a bug in MS SQL Server 2000 and i have read it on msdn. They have reported this as a bug and no fix is still availabe for the same.
December 5, 2002 at 5:10 pm
I thought DBF was a sturtured file, not delimited. Try using DTS to pull in with the FoxPro provider. Don't think Bulk Insert can do it.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply