You could also use transactions within your stored procedure. That way any changes it makes will be rolled back on failure.

Thanks

Phill Carter

Probably something a bit more robust and controllable, would be to use a DTS package. It would run on the server and pull the data in to the database.

You could...

If/when you host a chat session, can you take us Southern Hemisphere guys into account when you set the time.

I'm not that good in the wee early hours of the...

Would it be taht you haven't actually opened the Recordset object? You open the connection, not the recordset.

Also, probably not a good idea to advertise your server name and the...

Sorry, I got an error when trying to post this. Didn't think it had actually made it to the list. See the topic titled "Slow Insert Response with Indexed Views"

Thanks

Phill...

You need to do two things,

1) update the global variable gv_FileLocation to point to your directory.

2) On the line

set conExceltFile = pkg.Connections("Excel File (Source)")

Make sure...

quote:

---

... i'm facing difficulty from step 4 to step 5 as i'm using excel files i'm not able to set the precendence...

Check out the following,

http://www.sqldts.com/default.aspx?6,103,246,0,0

Thanks

Phill Carter

Firstly, pasting a bit of your code would help with providing a solution.

Secondly, try assigning the value of @@FETCH_STATUS to a seperate variable for each of the loops.

Thanks

Phill Carter

quote:

---

1. The datatypes were datatime, i changed them to varchar, then it worked.

---

So the username...

Can you post the table definition that you are working with.

How are you selecting the records to export?

Thanks

Phill Carter

quote:

---

I have an ASP page that is inserting into our database... When i do the insert i get this error message

Microsoft OLE...

When you run the package through the Designer it's running on your workstation with your security context. Therefore it will be able to access the file via the C$ share.

When...

Are you sure the server has the same connectivity as your workstation. The DTS package will execute on the machine that launched it. So when you're previewing the data and...

We use the DTS Backup 2000 tool from the SQLDTS site. Works a treat and if permissions are set right you can perform direct transfers which preserves the layout.

http://www.sqldts.com/default.aspx?220,272,272,1,1

Thanks

Phill Carter