December 19, 2005 at 2:11 am
Pleas help - I have a development environment consisting of my local machine, and the sql server on another machine which is also the a web server.
SQL bulk upload works fine when running it from my machine. If I deploy to the server though, it runs but does not insert any rows. There is no error message either.
Does anyone know what is going on? Any help would be mucho appreciated.
TR
December 21, 2005 at 4:02 pm
If this is an XML Bulk upload then make sure that the agent running the bulk load is a memeber of the bulkadmin fixed server role in SQL Server.
Also are you using DTS to perform the bulk load? If so then in the upper right hand corner of the DTS Package designer choose: Package>Properties>Logging Tab then create an error file. See if that captures any errors.
December 23, 2005 at 1:31 am
make sure that the file path from the server is the same as the file path from the computer that you made the dts on.
also make sure that the web srvices toolkit is installed on the database server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply