I think it best to give developers SA rights within their own development environment. This allows them to profile and tune the apps. They can also setup scheduled jobs, do...

Are there any weird characters in the data you are inserting, like quotes and such?

Thanks

Phill Carter

What text qualifier do you have set?

Thanks

Phill Carter

Can you explain a bit more about what you are currently doing, and what you have tried?

Some things to look at are the Dynamic Properties task (if you are using...

Hate to be a stick pointer ... but I've been in the same situation in regards to Network bods. One response I got was "Oh I didn't think that was...

Have you checked the versions of that DLL on each of the servers? Also, check if there are multiple copies of that DLL. Might have the wrong one registered.

Thanks

Phill Carter

Were there any other error messages in the log?

What was running on the server when you got this message?

Thanks

Phill Carter

Take a look at DTSBackup2000 at

http://www.sqldts.com/default.aspx?6,105,242,0,0

It has both GUI and Command line functionality. After making all your selections in the GUI you can generate a command line from your...

If the volume of data you're importing is large, consider using BULK INSERT, either the DTS task or the TSQL statement. Check out "Optimizing Bulk Copy Performance".

In these cases, I've...

About the best you can do is use the WITH ENCRYPTION option on the CREATE PROCEDURE statement. However, I know that procs encrypted on SQL 6.5 & 7 can be...

If you are running SQL 2000, try using the T-SQL BULK INSERT statement. It's quicker than BCP ( See 'Optimizing Bulk Copy Performance' in BOL ) and it keeps the...

You would need to do an ActiveX Script transformation instead of a Copy Column. Delete the transformations you currently have. Select the fields that need conversion and create a new...

Firstly check out the following article, it'll give you an idea on working out what security context the DTS package is executing under.

http://support.microsoft.com/default.aspx?scid=kb;en-us;269074

Secondly, the text of the error message...

Are the numbers the values that are missing? If so, check the format of the cell in Excel. If Excel sees it as a number then when you import it...

Looks like it may be related to some sort of cleanup for a transaction.

Where you able to find in similarities in server activity at the time of the two messages?

Thanks

Phill...