Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
polomease
Starting Member
1 Post |
 Posted - 2004-08-30 : 17:09:26
|
| ok here is the error I am getting, when running some DTS packages.Selected collating sequence not supported by the operating system.Copy Data from Q_eShopping_List_Root_Output to [eShoppingList].[dbo].[tblSL_Root] StepMicrosoft JET Database EngineAs you can see the error is coming from a step in the DTS, but I am not sure if the error is being caused by the DTS or the Access file or SQL Server. I did some Internet searching and found the MS KB articles that address the collating issue for Access 2000 but I looked at the settings and they are at what MS said they should be. I havn't installed multilanguage support yet but I don't think that is the problem because if it was I would be getting the error all the time and plus the two machines are both set up for the same language.What the strange thing about it is, is that the only way I can get rid of the error is by opening the Access database and closing it letting Access compact it again. (Which is why I think it is a error with Access)I don't change anything I just open it and then close it. And on top of that it sometimes works for a few times before I open and close, then it starts to give me the error until I open and close the database file and then it goes away.The DTS is using an ActiveX script to copy data from an Access XP database to a SQL Server database and is using the query Q_eShopping_List_Root_Output which is in the access databaseThis all started when I wanted to run DTS packages from an app I am writing in C# .net. The problem was that I wanted to know when the DTS package was funished running so I could do some processing with the data the package was copying. I found this[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;319985#1[/url] MS KB article showing how to make an event handler for running DTS in your app. The KB code works fine but when I run my app i get the above error from the OnError event I wrote when running the DTS. The app I am writing is located on a client machine and is connecting the SQL Server machine to run the DTS's the server also has the Access database on it. I am at a complete loss. |
|
|
|
|
|
DTS step failure