Loading SAS Dataset Into Sql Server 2005
Apr 5, 2008
Hi,
This is an urgent task came up at our i.e. Loading SAS dataset files into Sql Server 2005.
We received the various files generated from SAS from other team. Now we have only .dat files and some .sas files.
Requirment is to load them into SQL server and generate some reports out of the database.
Does any one has done this task previously i.e. SAS dataset into SQL server?
There is any documentation or steps to be followed using SSIS, please adive.
Any help is great appericated.
Thank you
NMohan
View 9 Replies
ADVERTISEMENT
Jul 20, 2005
Hi,SQL Server 2000 SP3Has anyone ever successfully loaded data into SQL Server from a SASdataset. I have tried using DTS and SAS OLE DB drivers but get thefollowing errorError Description:A provider specific error occurred (%1:%2)Context:Error calling GetRowSet to get DBSCHEMA_TABLES schema info. Yourprovider does not support all the schema rowsets required by DTS.It does seem to me to be a problem with the OLE DB providers but ifanyone has seen this issue with DTS previously , ler me know......Any help is appreciated....Thanks in advanceReg
View 1 Replies
View Related
Jan 15, 2008
Hi, when I try to open up an existing report project in VS 2005 then open the report template it will guide me to the Layout tab. Once I change the tab to Data, the following error showed up with an OK button:
TITLE: Microsoft Report Designer
------------------------------
The data extension SQL was not found in the configuration file RSReportDesigner.config.
Add the extension to the configuration file before proceeding or choose another data extension.
------------------------------
I tried creating a new dataset on the Data tab, the "Command Type" section use to have 2 selection: Text and Storeprocedure type. But now the Storeprocedure type is missing. I tried uninstall VS 2005 & SQL Server 2005 Components and reinstall them the same error still occurs.
I have no idea how to solve it, anyone encounter the same problem or able to help out please do so. Thanks in advance.
From,
Daren
View 1 Replies
View Related
Jan 13, 2008
Hi,
I am using VS2003 and SQL Server 2005. I will get the huge size xml from the web service. I need to load this xml to sql server 2005 table as records.
I got below solution from microsoft site. Load XML to Dataset and from Dataset to SQL Server 2005.
Note If you call ReadXml to load a very large file, you may encounter slow performance. To ensure best performance for ReadXml, on a large file, call the DataTable.BeginLoadData method for each table in the DataSet, then call ReadXml. Finally, call DataTable.EndLoadData for each table in the DataSet.
Any other better solution is there to load huge XML to SQL server 2005?
View 1 Replies
View Related
Aug 13, 2007
Please find the code below (which I am using).
1)
CREATE TABLE rssFeeds( feedXML XML)
SELECT * FROM RSSFEEDS
DECLARE @xmlDoc XML
SET @xmlDoc = ( SELECT * FROM OPENROWSET ( BULK 'C:Test.xml', SINGLE_CLOB ) AS xmlData)
2)
INSERT INTO rssFeeds (feedXML) VALUES (@xmlDoc)
I am able to get the contents of xml file into sql server in only one field of Table. Now I am asked to make one table with the schema same as xml file's. How to proceed? Pls let me know some URL for this.
Regards,
Ashish Johri
View 1 Replies
View Related
Aug 15, 2007
I am so new to SQL Server 2005 and just studying. Saying that...
We use SQL Server 2005 Express edition. Some one sent me a file (info.mdb) and asked me to load the data in this file in to a table called Products and also asked me to load in another table (ProdCat) where id = 'X05'.
So being not knowing anyting regarding data loading etc, how should I do this and proceed? The .mdb means its a Access database file? If that is the case, I dont have Access in my machine and what should I do?
View 5 Replies
View Related
Jul 24, 2006
I want to restore a backup of a SQL Server 2000 database to SQL Server 2005. Would I need to do anything after running the restore to upgrade the database?
View 1 Replies
View Related
May 16, 2008
HI
I am transferring the data from sql server 2005 to Informix 7.3.1 SE using SSIS .
I am using the OLEDB data connection for both source as well as destination databases.
I am trying to mapping the source and destination tables .I am getting the following error.
TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [OLE DB Destination [184]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
Error at Data Flow Task [OLE DB Destination [184]]: Opening a rowset for ""srinivas"."company"" failed. Check that the object exists in the database.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
I am using the following ODBC driver for the connecting INFORMIX 7.3.1 which is running on LINUX environment.
Openlink Generic ODBC Driver
It's creates the table in the informix 7.3.1 but it's not mapping the source and destination databases columns.
Please help me any one. it's urgent .
Thanks,
Srinivas Unnam
View 3 Replies
View Related
Jul 19, 2006
Im new to SQL server express 2005 and im having issues loading images into my tables. can anyone show me how to achieve this?
Thanks
Matt
View 4 Replies
View Related
Mar 31, 2006
Hello,
We are in need of some help around the use of SQL Server 2005 Mobile Edition.
The problem comes in when we have to import a large list of equipment ID€™s into the database.
The way that things work today is that the database only runs on the handheld computer, so we are having to process a large amount of data on the handheld therefore taking a lot of time.
If there were a way to have a €œseed€? database on the server side (running on Windows Server 2003 or similar) and import all of this data on the server side it would be more efficient and require less time.
Once the data was imported on the server side we can simply transfer this seed database down to the handheld
Could you please throw some light on the above queries.
Thanks in advance.
Jeeves
View 1 Replies
View Related
Jan 16, 2008
Has anyone done this? If so, how? I saw the systems requirement pages and web edition is not listed as as supported OS, but it's what we have. TIA.
View 1 Replies
View Related
May 26, 2015
I have a report with multiple datasets, the first of which pulls in data based on user entered parameters (sales date range and property use codes). Dataset1 pulls property id's and other sales data from a table (2014_COST) based on the user's parameters. I have set up another table (AUDITS) that I would like to use in dataset6. This table has 3 columns (Property ID's, Sales Price and Sales Date). I would like for dataset6 to pull the Property ID's that are NOT contained in the results from dataset1. In other words, I'd like the results of dataset6 to show me the property id's that are contained in the AUDITS table but which are not being pulled into dataset1. Both tables are in the same database.
View 0 Replies
View Related
Apr 20, 2006
I am running VS 2005 Professional Edition
Windows XP profession with Service Pack 2
SQL Server 2005 Developer Edition.
WHAT I HAVE DONE:
I have a database running in an instance of SQL Server.
I set this up for merge publication and then set up a SQL Server Mobile Edition Subscription to that publication. After a few oversights I got everything working. The Mobile database replicated just fine. I went back verified all data was there. Can make queries to it.
PROBLEM:
I set up a new dataset to use tables from the SQL Server Mobile database. If I drag one of the tables to the dataset, VS 2005 simply stops responding. It is not using any processor. I click any place on the application and I get the Microsoft Visual Studio Delay Notification saying:
Microsoft Visual Studio is Busy.
Microsoft Visual Studio is waiting for an internal operation to complete. If you regularly encounter this delay during normal usage, please report this problem to Microsoft.
Well... It is more than just a delay. The environment is not using any processor its just sitting here. And I left it running for 2.5 hours... so now this is becoming a big source of pain for me because I need to get that dataset working to finish my business logic. The only option I have is to Kill the process.
Hopefully someone out there can help.
Additional Services running:
IIS (Whatever version comes with Windows XP Pro. I think 5.1)
SQL Server Agent, SQL Server Integration Services, SQL Server Broswer and SQL Server FullTextSearch
UPDATE: I am editing this post with an update.
I noticed that my other tables get added to the dataset just fine. It is when I add one particular table that the entire visual studio simply stops and starts giving the delay notification. I have no idea why this happens... nor do I see any noticeable difference between this table and the rest of them. I went back and made sure that all columns types where directly supported by SQL Mobile Edition and they are.
View 14 Replies
View Related
May 20, 2008
I've only been doing sql 2005 for a couple of months with minimal training so there's a lot I don't know.
What I'm trying to do is load a nested table (industry & customer totals) based on a value from the table it's nested in.
This is the relationship of the data.
I have at the highest group, an industry code, then a customer, then the part and then the fiscal year.
What I'm trying to accomplish is to get a group total (footer) for the (1) industry code and (2) the customer code. This footer would contain the fiscal years (ascending) and their monthly totals. I would like to take the industry code from table one and pass it to the select statement in the dataset that feeds the nested table. I've read this is not possible to load a dataset field into a parm but I've seen where some people know how to work around this. If you reply, please explain in simple terms. Thanks!
industry Customer Year OCT NOV DEC
001 - Signposts
M12345
Part 1
2006 5 6 2
2007 0 3 1
Part 2
2006 4 3 0
2007 1 0 7
Customer M12345 totals
2006 9 9 2
2007 1 3 8
M45678
Part 3
2007 8 4 7
2008 3 4 8
Part 4
2006 3 8 7
2007 5 6 6
Customer M45678 totals
2006 3 8 7
2007 13 10 13
2008 3 4 8
Industry 001 totals
2006 12 17 9
2007 14 13 21
2008 3 4 8
View 1 Replies
View Related
Jan 17, 2008
Hi, Experts
The project is a C/S data analysis system built with .Net 2.0 in windows environment, OS: Microsoft Windows 2003 R2 standard Edition Service Pack2, Database used in this project is: Sql server 2005. As a data analysis system, we need to load large amount of data from file to database, we do it by create a dts package and then do data loading by execute "m_Package.Execute(null, variables, m_PackageEvents, null, null)".
The problem is, we fount that DTS miss some data randomly sometimes, we can't find the rule till now. for example we've data as follows in data file, all data field splited by '|'
11234|26341|2007-09-03 00:00|0|0|0.0|0|0.011470833793282509|1|0.045497223734855652|0|0|1|0|3|2929|13130|43|0|2|0|0|40|1|0|0|0|0|0|1||0|0|3|0|0|0|0|0||0|3|0|0|43|43|0|41270|0|3|0|0|10|3|0|0|0|0|0||0|1912|0|0|3|0|0|0|0|0|0|0|3|0|0|5|0|40|0|9|0|0|0|0|0|0|0|0|29|1|1|24|24.0|16|16.0|0|0|0.0|0|0|24|23.980693817138672|0|0.0|0|0.0|0|0.0|0|0.0|11|2.0764460563659668|43|2|0|0|30|11|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|3|0|0|0|0|0|0|0|0|0|6|0|0|0|0|0|6|0|0|45|1|0|0|0|2|42|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|0|0|0|2|0|0|0|0|0|0|51|47|85|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|||||||||||||0|0|0|0|0|97.117401123046875|0|0|83|57|||0.011738888919353485|0|1|0.065955556929111481|0|4|||0.00026658669230528176|1|0.00014440112863667309|1|68|53|12|2|1|2.0562667846679688|10|94|2|0|0|30|11|47|4|13902|7024|6878|18|85|4.9072666168212891|5|0.0|0|0.0|0|0.0|0|0.0|0|358|6448|6324|0|0|0|0||0||462|967|0|41|39|2|0|0|0|1|0|0|0|0|0|0|0|0|3|0|0|3|0|0|0|0|0|0|0|0|0|3|0|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|46|0|1|0|1|37|0|0|46|0|1|0|1|37|0|0|0|0|0|0|0|0|0.0|0|0|6|4|2|0|0|2|1|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|1|0.012290795333683491|0|44|44.0|0|0.0|0|0|0|30|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|0|2|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|1|0|0|0|0|0|0|0|0|0|0|0|0|27|0|0|2112|411|411|45|437|2|0|2|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|4|0|4|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|6|6|0|3|2|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|5|5.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|600|600|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|6|0|0|0|0|0|0|6|0|9|1|2|2|3|0|1|0|0|0|0|0|0|0|0|0|0|0|13|3|2|5|1|1|1|0|0|0|102|0|1|1|0|0|0|3|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0||||||||||0|0|0|0|0|0|0||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|46.0|46|0.0|0|0.0|0|0.011469460092484951|1|0.0|0|0.0|0|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|100.0|100.0|0|1|0|1|0|0|0.02481505274772644|1|0.014951236546039581|1|0|0|0|0|0|0|0|0|0|0|0|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|4695.5556640625|42260|7126.66650390625|62040|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||||||0|0||||||||||
11213|26341|2007-09-03 00:00|0|0|0.0|0|0.068584725260734558|2|0.14375555515289307|27|0|2|1|11|3966|13162|97|0|13|0|0|83|3|2|3|0|0|0|26||0|0|11|0|0|0|1|0||0|1|0|3|97|98|0|246795|0|11|1|0|3|14|0|0|0|0|0||0|1912|0|0|12|0|0|0|0|0|0|0|12|0|0|17|0|83|2|2|2|0|0|0|0|0|0|0|73|3|1|24|24.0|16|16.0|0|0|0.0|3|0|24|23.905364990234375|2|0.0040000001899898052|0|0.0|0|0.0|0|0.0|11|2.0772171020507812|97|7|0|0|80|10|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|12|12|0|0|0|0|0|0|0|0|0|41|0|0|0|0|0|41|0|0|99|25|0|0|0|0|74|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|0|0|0|0|0|0|0|0|0|0|177|158|332|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|3|||||||||||||0|0|0|0|0|0.0|0|0|321|198|||0.041950233280658722|0|2|0.1999288946390152|0|5|||0.00088306842371821404|1|0.00051651173271238804|1|529|113|4|8|2|2.0671226978302002|10|274|7|0|0|80|10|66|17|13934|7024|6910|31|332|4.7173333168029785|5|0.000033333333703922108|1|0.000033333333703922108|1|0.000033333333703922108|1|0.0|0|358|6448|6356|0|0|0|0||0||1609|3423|0|83|78|5|0|0|26|0|0|0|0|0|0|0|0|0|2|0|1|1|0|0|0|0|3|0|0|0|0|2|0|2|0|0|0|0|0|0|0|0|0|0|2|0|0|0|0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|65|0|1|0|1|72|0|0|65|0|1|0|1|72|0|0|0|0|0|0|0|0|0.0|0|0|12|7|0|2|3|16|5|5|6|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|2|0.04131799191236496|0|48|48.0|5|5.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|1|0|0|0|0|0|0|9|0|5|1|0|0|0|1|0|0|0|1|1|0|0|0|0|0|0|0|0|0|0|4|2|1|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|0|0|0|0|3|0|0|0|0|0|0|0|0|121|0|1410|6046|558|1400|192|2467|10|0|5|1|0|0|0|2|0|0|0|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|15|0|10|0|0|0|0|3|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|21|9|12|10|3|1|0|1|4|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|163|4|144|91|92|2|92|0|0|0|0|0|101|92|0|0|0|0|101|0|0|0|0|600|596|1|0|0|3|0|0|0|0|0|0|0|0|0|0|0|9|0|0|1|0|0|0|8|0|34|3|4|14|7|2|3|0|1|0|0|0|0|0|0|0|0|0|41|6|4|23|5|2|1|0|0|0|289|0|7|7|0|0|0|11|11|0|0|4|4|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0||0|0|4|0|0|0|0|0|4||||||||||3|0|0|0|0|0|3||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|55.814689636230469|47.931411743164062|48|0.0|0|0.0|0|0.068584725260734558|2|0.0|0|0.0|0|14|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0.0|0|0|0|0|1|0|0|1|0|0|0|0|0|||0|100.0|100.0|0|26|26|0|0|0|0.088263392448425293|2|0.056161552667617798|2|0|0|0|0|0|0|0|0|0|5|22|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|16308.888671875|146780|23162.22265625|184840|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||||||0|0||||||||||
11220|26341|2007-09-03 00:00|0|0|0.0|0|0.309184730052948|2|0.17757916450500488|0|0|7|4|18|3925|13682|172|0|19|0|0|164|10|5|4|0|0|0|2||0|0|20|0|0|1|4|0||0|5|0|4|172|172|0|1165085|0|20|4|0|20|8|0|0|0|0|0||0|1912|0|0|24|0|0|1|0|0|0|0|23|0|0|30|0|164|4|6|8|0|0|0|0|0|0|0|121|10|15|24|24.0|16|16.0|0|0|0.0|4|0|24|23.646148681640625|1|0.0040013887919485569|0|0.0|0|0.0|0|0.0|11|2.0849723815917969|172|5|0|0|123|44|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|26|24|0|0|0|2|0|0|0|0|0|192|1|0|0|0|0|191|0|0|190|12|0|0|0|0|178|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|0|0|0|0|0|1|0|0|0|0|1008|953|2758|0|5|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|4|||||||||||||0|0|0|0|0|84.418106079101562|0|0|2626|1420|||0.29022222757339478|0|5|1.5045944452285767|0|5|||0.0058597764000296593|2|0.0046600494533777237|2|1340|1114|80|119|27|2.2584490776062012|10|1180|5|0|0|123|44|953|55|14462|7024|7438|52|2758|3.0037333965301514|5|0.021266667172312737|1|0.00036666667438112199|1|0.0|0|0.0|0|362|6440|6880|0|0|0|0||0||13711|27667|0|159|149|10|0|0|1|1|0|0|0|0|0|0|0|0|7|0|0|7|0|0|0|0|4|0|0|0|0|7|0|7|0|0|0|0|0|0|0|0|0|2|3|0|0|0|0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|842|0|111|0|102|1702|0|1|842|0|111|0|0|1703|0|0|0|0|0|0|0|0|0.0|0|0|47|26|11|3|7|37|1|20|16|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|4|0.24921548366546631|0|44|44.0|0|0.0|0|0|0|1003|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|10|0|8|2|0|0|0|0|0|0|0|0|0|0|81|1|60|10|10|0|0|0|0|0|0|0|0|0|1|1|0|0|0|0|0|0|0|25|16|4|2|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|53|27|17|4|5|0|0|0|0|0|0|0|0|0|421|0|8685|67179|2138|12104|80|26285|104|1|73|16|14|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|87|1|77|7|2|0|0|0|0|0|0|0|0|0|1|0|0|1|0|0|0|0|0|0|0|0|0|0|16|0|9|5|2|0|0|0|0|0|0|0|0|0|155|155|0|105|51|32|9|13|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|5|5.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|102|0|0|0|0|0|600|445|4|20|32|63|16|15|4|1|0|0|0|0|0|0|0|37|0|0|5|0|0|0|32|0|230|7|10|99|68|22|21|0|3|0|0|0|0|0|0|0|0|0|286|18|10|182|53|17|6|0|0|0|2528|0|10|10|0|0|0|22|22|0|0|25|25|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0||0|0|30|0|0|0|0|0|30||||||||||23|0|0|0|0|0|23||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0.0|45.998283386230469|46|0.0|0|0.0|0|0.30917638540267944|2|0.0|0|0.0|0|8|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0.0|0|0|0|0|1|1|0|0|0|0|0|0|0|||0|100.0|100.0|0|2|1|0|0|1|0.73375397920608521|5|0.41600942611694336|6|0|0|0|0|0|0|0|0|0|0|0|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|98115.5546875|865520|176626.671875|1159360|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||||||0|0||||||||||
We found that some of the data field become 'null' after the load action finished, if we load the same data again, problem disappeared, we can't 100% reproduce this issue each time, we don't know why, Anybody here can help us to solve this issue or give us some clue?
View 3 Replies
View Related
Jun 19, 2007
Hi,
I'm dealing with loading xml data into sql 2005 relational tables
We are trying to do with C# class objects, what would be the better method to follow to load C# entity objects with xml data.
Xml has a complex 6 level heirarchy and with huge amounts of data.
please help.
-Thanks
Shiva
View 6 Replies
View Related
Jun 14, 2006
I am moving a VS 2003 Pocket PC app to VS 2005 and when I deploy the app from Visuyal Studio 2005 two sqlce cabs are deployed (in addition to the sqlce30 ones) namely
sqlce20.dev.ppc.wce4.armv4.CAB
and
sqlce20.ppc.wce4.armv4.CAB.
Now as I have documented in another thread (SQL 2005 Mobile : The file is not a valid database file) this gives me problems when I want to access the database being produced by replication. So I'm trying to eliminate the need for these cab files.
My pocket PC application uses two of my DLLs the first of which is my Business Objects. When I deploy this to my PDA I get the following build output
------ Build started: Project: BO, Configuration: Release Any CPU ------
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Vbc.exe /noconfig
/imports:Microsoft.VisualBasic,System,System.Collections,System.Collections.Generic,System.Data,Sys
tem.Diagnostics /nowarn:42016,41999,42017,42018,42019,42032,42036,42020,42021,42022 /nostdlib
/rootnamespace:MVnet.VS2005CF.MobileSeller.BO /sdkpath:"C:Program FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCE" /netcf /doc:objReleaseBO.xml
/define:"CONFIG="Release",TRACE=-1,_MyType="Windows",PLATFORM="AnyCPU",PocketPC=TRUE"
/reference:"................Program FilesIn The Hand LtdADOCE In The Hand
v1.7RuntimeInTheHand.Data.Adoce.dll","................Program FilesIn The Hand LtdADOCE
In The Hand
v1.7RuntimeInTheHand.Interop.dll",..............VS2005CFReferences
eleaseMVnetApplicati
on.dll,"C:Program FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Data.dll","C:Program FilesMicrosoft
Visual Studio 8SmartDevicesSDK\SQL ServerMobilev3.0System.Data.SqlServerCe.dll","C:Program
FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.dll","C:Program FilesMicrosoft
Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Drawing.dll","C:Program
FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Web.Services.dll","C:Program
FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Windows.Forms.dll","C:Program
FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Xml.dll" /debug:pdbonly
/filealign:512 /optimize+ /out:objReleaseBO.dll
/resource:objReleaseMVnet.VS2005CF.MobileSeller.BO.BO.frmError.resources
/resource:objReleaseMVnet.VS2005CF.MobileSeller.BO.Resources.resources /target:library
AmtechSynchroniser.vb AmtechAP_Board.vb AmtechAP_Circuit.vb AmtechAP_Completion.vb
AmtechAP_Domestic.vb AmtechAP_DomesticPeriodic.vb AmtechAP_DomesticSupplyCable.vb
AmtechAP_EmergencyLightingInspection.vb AmtechAP_FireDetectionCommissioning.vb
AmtechAP_FireDetectionInstallation.vb AmtechAP_FireDetectionServicing.vb
AmtechAP_FireDetectionSystemRevised.vb AmtechAP_FireDetectionVerification.vb AmtechAP_Job.vb
AmtechAP_MinorWorksNIC.vb AmtechAP_Periodic.vb AmtechAP_PeriodicBoardTest.vb
AmtechAP_PeriodicCircuitTest.vb AmtechAP_PeriodicRecommendations.vb AmtechAP_ProtectiveDevice.vb
AmtechAP_StandardRecommendations.vb AmtechAP_VersionInfo.vb AmtechICDBEntity.vb basMain.vb
basSQL.vb cAddress.vb cAnswer.vb cBlockAllocation.vb cBO.vb cCompany.vb cCustomer.vb cCustomerF.vb
cInvoice.vb cInvoiceLine.vb cJob.vb cNote.vb cOrder.vb cOrderF.vb cOrderLine.vb cPaymentLine.vb
cPaymentLineF.vb cPDA_Update.vb cProduct.vb cProductF.vb cProductStock.vb cProductStockF.vb
cQuestion.vb cQuestionAnswer.vb cReceipt.vb cRep.vb cRepF.vb cRepProductPrice.vb
cRepProductPriceF.vb cRepProductStock.vb cRepStockAdjustment.vb cRepStockOrder.vb
cRepStockOrderF.vb cSalesPosition.vb cSalesPositionF.vb cSupplier.vb cType.vb cTypeF.vb cVatCode.vb
cVisit.vb cVisitF.vb Database.vb EntityHelper.vb FleetMindercMakeModel.vb FleetMindercVehicle.vb
frmError.vb GradusGradusReport.vb IEntityForm.vb IManagedForm.vb ISQLInEntity.vb "My
ProjectAssemblyInfo.vb" "My ProjectResources.Designer.vb" PageSelection.vb PDAProduct.vb
Property.vb RDAControl.vb Synchroniser.vb "Web ReferencesFeedBackWSReference.vb" "Web
ReferencesWSPDADBReference.vb"
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(152) :
warning BC42104: Variable 'TableConfig' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(166) :
warning BC42104: Variable 'ATTable' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(292) :
warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(350) :
warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(400) :
warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(458) :
warning BC42104: Variable 'rstab' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(557) :
warning BC42104: Variable 'rsTab' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(611) :
warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(812) :
warning BC42104: Variable 'CDBSelectSQL' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(856) :
warning BC42025: Access of shared member, constant member, enum member or nested type through an
instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(952) :
warning BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1000) :
warning BC42025: Access of shared member, constant member, enum member or nested type through an
instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1004) :
warning BC42025: Access of shared member, constant member, enum member or nested type through an
instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1009) :
warning BC42104: Variable 'nCol' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1020) :
warning BC42104: Variable 'CDBSelectSQL' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1078) :
warning BC42104: Variable 'oProp' is used before it has been assigned a value. A null reference
exception could result at runtime.
vbc : warning BC42206: Maximum number of warnings has been exceeded.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Board.vb(231) : warning
BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Circuit.vb(239) :
warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Completion.vb(812) :
warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Domestic.vb(543) :
warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_DomesticPeriodic.vb(606
) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_DomesticSupplyCable.vb(
284) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_EmergencyLightingInspec
tion.vb(362) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.
A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionCommission
ing.vb(270) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.
A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionInstallati
on.vb(268) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A
null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionServicing.
vb(609) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A
null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionSystemRevi
sed.vb(293) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.
A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionVerificati
on.vb(277) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A
null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Job.vb(340) : warning
BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_MinorWorksNIC.vb(314) :
warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Periodic.vb(619) :
warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicBoardTest.vb(22
7) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicCircuitTest.vb(
239) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicRecommendations
.vb(181) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A
null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(113) : warning
BC42105: Function 'Version' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(176) : warning
BC42105: Function 'RepLogOn' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(443) : warning
BC42105: Function 'ExecuteSQL_ReturnIdentity' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(513) : warning
BC42105: Function 'InitialiseServiceOrderLines1' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(585) : warning
BC42105: Function 'GetVisit1' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(656) : warning
BC42105: Function 'GetCustomer1' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(728) : warning
BC42105: Function 'GetProduct1' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(798) : warning
BC42105: Function 'GetDataSet' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(868) : warning
BC42105: Function 'GetScalar' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1012) : warning
BC42025: Access of shared member, constant member, enum member or nested type through an instance;
qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1134) : warning
BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1176) : warning
BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1217) : warning
BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(238) : warning
BC42105: Function 'SelectSQL' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(342) : warning
BC42105: Function 'InsertSQL' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(404) : warning
BC42105: Function 'UpdateSQL' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(460) : warning
BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(522) : warning
BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(634) : warning
BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(847) : warning
BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(959) : warning
BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(1083) : warning
BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercMakeModel.vb(116) :
warning BC42104: Variable 'CurrentMake' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercMakeModel.vb(116) :
warning BC42104: Variable 'NewMake' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercVehicle.vb(132) :
warning BC42104: Variable 'V' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOGradusGradusReport.vb(39) :
warning BC42105: Function 'DisplayName' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOGradusGradusReport.vb(64) :
warning BC42105: Function 'CurrentSection' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(341) : warning
BC42105: Function 'ProductTypeInList' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(419) : warning
BC42104: Variable 'WhereSQL' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning
BC42104: Variable 'SelectSQL' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning
BC42104: Variable 'StockSQL' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning
BC42104: Variable 'CategoryValue2' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning
BC42104: Variable 'ProductSupplierJoinSQL' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(748) : warning
BC42107: Property 'SelectSQL' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(791) : warning
BC42107: Property 'CountSQL' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(850) : warning
BC42107: Property 'Products' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPageSelection.vb(8) : warning
BC40055: Casing of namespace name 'bo' does not match casing of namespace name 'BO' in file
'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Board.vb'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOSynchroniser.vb(213) : warning
BC42104: Variable 'ErrorInfo' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcBO.vb(217) : warning BC42107:
Property 'AmtechDBPath' doesn't return a value on all code paths. A null reference exception could
occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcBO.vb(582) : warning BC42104:
Variable 'TableName' is used before it has been assigned a value. A null reference exception could
result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCompany.vb(848) : warning
BC42024: Unused local variable: 'Setting'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomer.vb(924) : warning
BC42104: Variable 'SaveCurrentVisit' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomer.vb(974) : warning
BC42105: Function 'GenerateInvoices' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomerF.vb(419) : warning
BC42104: Variable 'WhereSQL' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcJob.vb(411) : warning BC42105:
Function 'InvoicedVisitWithNoPO' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcJob.vb(449) : warning BC42104:
Variable 'V' is used before it has been assigned a value. A null reference exception could result
at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcOrderF.vb(7) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.PhoneAPI' doesn't contain
any public member or cannot be found. Make sure the namespace or the type is defined and contains
at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcOrderF.vb(9) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.VS2005CF.MobileSeller.WebServices' doesn't
contain any public member or cannot be found. Make sure the namespace or the type is defined and
contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestion.vb(202) : warning
BC42105: Function 'RootQuestions' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestion.vb(212) : warning
BC42105: Function 'Questions_ForCompany' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(238) : warning
BC42105: Function 'AnswersForQuestion' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(244) : warning
BC42024: Unused local variable: 'sSQL'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(254) : warning
BC42105: Function 'AnswersForQuestion_IncludeUserAnswers' doesn't return a value on all code paths.
A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcRepF.vb(354) : warning BC42104:
Variable 'oRep' is used before it has been assigned a value. A null reference exception could
result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(905) : warning BC42105:
Function 'PopulateComboFromRepProductCategories' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(917) : warning BC42025:
Access of shared member, constant member, enum member or nested type through an instance;
qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(967) : warning BC42024:
Unused local variable: 'sValue'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1228) : warning
BC42104: Variable 'nCol' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1300) : warning
BC42104: Variable 'PaymentsSplit' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1318) : warning
BC42104: Variable 'NoSignaturesSplit' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1336) : warning
BC42104: Variable 'CancellationsSplit' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1356) : warning
BC42104: Variable 'NotesColonSplit' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1413) : warning
BC42105: Function 'VisitResultCodes' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisit.vb(12) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.MVnetApplicationVB' doesn't
contain any public member or cannot be found. Make sure the namespace or the type is defined and
contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(8) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.PhoneAPI' doesn't contain
any public member or cannot be found. Make sure the namespace or the type is defined and contains
at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(9) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.MVnetApplicationVB' doesn't
contain any public member or cannot be found. Make sure the namespace or the type is defined and
contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(10) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.VS2005CF.mobileseller.WebServices' doesn't
contain any public member or cannot be found. Make sure the namespace or the type is defined and
contains at least one public member. Make sure the imported element name doesn't use any aliases.
BO -> C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseBO.dll
------ Deploy started: Project: BO, Configuration: Release Any CPU ------
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL
ServerMobilev2.0System.Data.Common.dll'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL
ServerMobilev2.0wce400ARMV4sqlce20.ppc.wce4.armv4.CAB'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL
ServerMobilev2.0wce400ARMV4sqlce20.dev.ppc.wce4.armv4.cab'
Deploying 'C:DevVS2005CFReferences
eleaseMVnetApplication.dll'
Deploying 'C:Program FilesIn The Hand LtdADOCE In The Hand v1.7RuntimeInTheHand.Interop.dll'
Deploying 'C:Program FilesIn The Hand LtdADOCE In The Hand
v1.7RuntimeInTheHand.Data.Adoce.dll'
Deploying 'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseBO.dll'
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========
which as you can see is bringing in the two cabs.
Is there an easy way to determine what exactly requires these two cabs?
I strongly suspect that it's a third party stuff from ADOCE which I'm using to access access databases on the PDA.
View 5 Replies
View Related
Feb 20, 2008
I have a report in RS that uses a cube as a data source. I made some changes to a cube in AS 2005 and I am not sure how I can refresh my existing datasets without deleting everything?
Any feedback is greatly appreciated.
Thanks!
View 4 Replies
View Related
Oct 13, 2006
this may seem like a real newbie question, but I got no clue how to solve this problem. When I was working in Visual Studio 2003, whatever I wanted to fill a dataset with data, I was using a SqlDataAdapter that I created like this adapTest.Fill(dsTest); But now, I cant seem to find the sqldataadapter anywhere, I can just create (on the visual interface of one of my page of my aspx project) dataset, but cant find anywhere a adapter to put an SQL instruction into...maybe theres a new way to do this in Visual Studio 2005 that I dont know about. Im not sure if I was clear enough, but what I want in the end is to be able to use my dataset like that dsTest.Tables.Rows[0]["a column"].ToString()by filling the dataset with data like I was able to do in VS2003. Thanks for taking the time to read this.
View 3 Replies
View Related
Oct 1, 2015
I have a small number of rows in a dataset, Table 1. There is a CLOB on a large dataset, Table 2. They join on a PK. I would like to retrieve this CLOB and add it to the data flow for Table1. In short I want to emulate the following:
Table 1:Â Small table without CLOB, 10 rows.Â
Table 2: Large table with CLOB, 10,000,000 rows
select CLOB
from table2
where pk = (select pk from table1)
I want this to return the CLOBs for the small number of rows in Table 1. The PK is indexed obviously so it should be a fast look up.
Table 1 and Table 2 live on different Oracle databases. How do I perform this operation efficiently in SSIS? It seems the Lookup and Merge Join wont do this.
View 2 Replies
View Related
May 27, 2015
I have a report with multiple datasets, the first of which pulls in data based on user entered parameters (sales date range and property use codes). Dataset1 pulls property id's and other sales data from a table (2014_COST) based on the user's parameters.
I have set up another table (AUDITS) that I would like to use in dataset6. This table has 3 columns (Property ID's, Sales Price and Sales Date). I would like for dataset6 to pull the Property ID's that are NOT contained in the results from dataset1. In other words, I'd like the results of dataset6 to show me the property id's that are contained in the AUDITS table but which are not being pulled into dataset1. Both tables are in the same database.
View 3 Replies
View Related
May 21, 2007
I found out the data I need for my SQL Report is already defined in a dynamic dataset on another web service. Is there a way to use web services to call another web service to get the dataset I need to generate a report? Examples would help if you have any, thanks for looking
View 2 Replies
View Related
Apr 3, 2006
hi,
I have developed an application in c#.net 2.0 for Pocket PC. And even i developed a webservice to communicate between sql server 2005 and sql mobile 2005. Webservice returns the data in a dataset format from sql server 2005, but while inserting the data row by row from dataset, it is taking a huge amount of time. I would like to know, is there any way where i can copy the bulk data from dataset into the sql mobile 2005 using c#.And how this can be achieved.
Thank you
View 5 Replies
View Related
Oct 12, 2007
Is there any way to display this information in the report?
Thanks
View 3 Replies
View Related
May 7, 2008
Hi,
I have a stored procedure attached below. It returns 2 rows in the SQL Management studio when I execute MyStorProc 0,28. But in my program which uses ADOHelper, it returns a dataset with tables.count=0.
if I comment out the line --If @Status = 0 then it returns the rows. Obviously it does not stop in
if @Status=0 even if I pass @status=0. What am I doing wrong?
Any help is appreciated.
ALTER PROCEDURE [dbo].[MyStorProc]
(
@Status smallint,
@RowCount int = NULL,
@FacilityId numeric(10,0) = NULL,
@QueueID numeric (10,0)= NULL,
@VendorId numeric(10, 0) = NULL
)
AS
SET NOCOUNT ON
SET CONCAT_NULL_YIELDS_NULL OFF
If @Status = 0
BEGIN
SELECT ......
END
If @Status = 1
BEGIN
SELECT......
END
View 4 Replies
View Related
Jan 26, 2006
What is the fastest way I can load data into SQL SErver -- it seems to me it's with Bulk Copy and minimal logging. But that seems very slow when I look at Orace's Data Pump and DB2's LOADer. Does SSIS help here -- from what I can tell, you help me tons and tons on the ET part, but the L is what I'm wondering about...
View 5 Replies
View Related
Sep 18, 2000
hi
I am loading from Mainframe to Sqlserver.
Right now i am truncating the tables in sqlserver connecting to mainframe and downloading the tables to Sql server. The problem is sometimes i fail to connect to Mainframe. So is there any way of checking whether i can connect to mainframe and if succesful truncate the tables.
Thanks
View 1 Replies
View Related
Oct 5, 1999
I looked for an answer in the archives and could not find one.
Does anyone know if it is ok or works loading a database dump
from one SQL server running SP 5a (production server) onto another SQL server running SP 3 (backup server)? We were not planning to upgrade our production and backup servers simultaneously unless there would be a problem loading the
database dumps.
Thanks you in advance.
View 2 Replies
View Related
May 14, 1999
I am trying to setup 2 SQL servers (ver 6.5) - A live server and a standby server. The plan is to have regular transaction logs dumps from the Live server databases to the standby server and then have these logs automatically applied.
I have managed to get the logs dumping automatically but when I tried to apply them I keep getting synchronisation/sequence errors.
Has anyone done/tried anything similar. Any advice on this would be very useful.
Thanks
Samir
P.S I can't do this via replications as most tables in the database do not have primary keys.
View 5 Replies
View Related
Sep 18, 2001
WHEN I TRY TO LOAD THE SQL 2000 SERVER I GET THE FOLLOWING ERROR:
MICROSOFT SQL SERVER 2000 DEVELOPER EDITION SERVER COMPONENT IS NOT SUPPORTED ON THIS OPERATING SYSTEM. ONLY CLIENT COMPONENTS WILL BE AVAILABLE FOR INSTALLATION.
AT THE PRESENT I AM RUNNING WINDOWS ME AS THE OPERATING SYSTEM. THIS VERSION OF SQL SERVER 2000 WAS BOUGHT FROM MICROSOFT A COUPLE OF MONTHS AGO. THIS IS MY FIST TIME TRYING TO INSTALL IT.
THANKS FOR YOUR COMMENTS AND SUGGESTIONS.
View 1 Replies
View Related
Feb 10, 2007
HiI'm having problems loading a new instance of SQL 2000 Developer edition asa default instance onto my laptop. Everytime I try to do so it I get amessage at the end of the installation saying the 'Server failed toinitialize' and refer to the set up log. When I look at the error log itsays"[Microsoft][ODBC Driver Manager] data source not found and no defaultdriver specified".Can anyone help me understand this please
View 1 Replies
View Related
Jan 23, 2008
I have a SSIS package that transfers data from three SQL Server 7 servers to a SQL Server 2005 database. This package has about 30 different tables it copies. The table structures in the source database and destination tables are identical. About 25 different tables load without any issues. I have about 5 tables that load some nights without a problem. On other nights, the data transfers seem to randomly (though usually the most recent records) ignore some of the data. I have logging turned on and receive no errors. It just appears to stop loading data.
I should also mention that I truncate each destination table before begining and each table is loaded from data from each of the 13 source database (I am combining data from 13 regional database for reporting purposes). This is done using a Foreach Loop Container that updates the Server/Region connection string for each region. I am using the OLE DB Source connection to the SQL Server Destination. I have tried as well with the OLE DB Destination with the same result (and no error). I do not do any manipulation to the data on the transfer, but added a "RowCount" transformation between the source and destination and it gives the correct number of rows, but not all the rows get loaded.
View 6 Replies
View Related