Thank you for your reply,
The problem is I know that the destination table has numeric datatype but the data comes from a cube on an OLAP linked server, I looked att som values there som was numerics and others '-1,#j' probably a formuler results. and I do this convert(float, "[Measures].[ The profit]"). What else do I need to do?
mayati
Last Activity: Jun 14 '07, 11:56 AM
Joined: Jul 11 '06
Location:
-
Dts Problem!
Hello Everyone,
I have a DTS package, which has been working fine for few years. it runs once a month to get information from different databases and save it into the destination database. Now I get this error:
error source: microsoft ole db provider for sql server
error description: could not get the data of the row from the ole db provider 'MSOLAP'.
Conversion failed because the data value overflowed... -
Hello again Enyi,
sorry I forgot to ask you about your reply to my question nr 1. Now I have the declaration, where I should declare it to be able to use it theroug the project, so I do not need to declare it in every single form.Leave a comment:
-
Hello Enyi,
Thank you for your concern, do you think threading will be a good solution for my number 2 questionLeave a comment:
-
vb.net help!
I am programing in vb.net and having sql server 2000 as database. I have two questions:
1- How to connect dynamically to the server from a vb.net form field by the user(user enters server, database, username and password)so this connection will be available for the rest of the forms in the application.
2- I have to migrate millions of documents and their related data from one sql 2000 server to the other. I have retrieved from...
No activity results to display
Leave a comment: