|
I have to create a SSIS package which will take data from a large xml file(~10GB), and import it into sql server 2005 database. Can anyone tell me the steps which i have to follow to do this? I also have to do XSD validation and maitain Transaction.
|
|
|
|
|
well you could better use BCP command for large files to import into a database.
See here for more details
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Hi all,
I have a MS-Access database.
Whenever I open the database its modified date and time will be changed.
I want whenever a change in the database ( by modifying records or tables )
then only the DB date and time should be changed.
How to control by not modifying date and time, when only database is opened or accessed?
How to do this?
|
|
|
|
|
I can't understand enough your question, can you explain more technically?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Yaah,
Whenever we just open and close the database. The date and time of the database will be modified.
I don't want this. ( date and time modification ).
If I have changed the database
ex: By adding new records or tables, or deleting records or tables
then only the database modified date and time should be changed.
how to do this?
|
|
|
|
|
You are not going to be able to manage the modified time of a file (your DB) from within the file, it will be in use by another process.
If you need to track the changes made WITHIN the database then you are going to have to build the logging infrastructure to manage that and it will not be via the modified date of the database file.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You could possibly get and store the date before opening the file and restore it after closing.
But I doubt it's worth the trouble.
|
|
|
|
|
I have a large xml file and I want to importing data from it to my database using LINQ.
- My database has many type of data and my xml file has null value.
- xml file has multi table.
In T-SQL, I used Dataset.Readxml and using SqlBulkCopy to insert dataset into SQL. My problem is xml file has null value.
I want to use LINQ to write it. What should I do? Please help me.
|
|
|
|
|
xml doesn't have 'null', so exactly what do you mean?
I suspect you mean that you have an element with no value or perhaps 'nil'?
If so there are two possibilities.
1. The corresponding database column allows nulls.
2. The corresponding database column does not allow nulls - thus you MUST provide a value. You would do that while processing the file. No one can tell you what a valid value for that is since it depends on business rules.
|
|
|
|
|
Yes, I mean I have an element with no value or perhap null.
I want to use LINQ.I have a column date type of data is datetime. And in my xml file, date has no data. I wrote a store procedure use openxml. When I execute it, it return 01/01/1900. I want it return null.
|
|
|
|
|
So just add something to the end of the stored proc to update the invalid value to null.
|
|
|
|
|
|
|
|
|
Hello,
Can any one tell me common function for SQL server and Oracle for getting month from the given date.
For Example,
In SQL Server
--> CAST(DATEPART(Month , Booking.BookingDtTime) AS VARCHAR(20)) AS Month_Value
In Oracle
--> TO_CHAR(Booking.BookingDtTime, 'Month') AS Month_Value
I want a common function for the same which works both in SQL Server as well Oracle.
Thanks..
|
|
|
|
|
NTheOne wrote: I want a common function for the same which works both in SQL Server as well Oracle.
Good luck with that. They are different databases using different sql dialects (TSQL and PLSQL) what makes you thinks there is or should be a common function in each dialect. You are going to have to code around the differences and detect the type of database you are working against.
[edit]
One way would be to code your own function in each database and use the same name. Functions are on a roll this morning.
[/edit]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You will encounter many more differences between SQL Server's SQL and Oracle's SQL. When I made our application work with both of them, I created a framework for that. The "S" in SQL stands for "structured", not for "standard"!
|
|
|
|
|
There's ANSI-92 SQL, and Sql Server supports that. Doesn't Oracle have something similar?
I are Troll 
|
|
|
|
|
Why?
I would suspect there isn't one.
If you are attempting SQL independence that means you can't use stored procs and must be using another language to wrap it, so just use that language to extract the month.
If using in a where clause then construct an appropriate timestamp value that represents a month range. This has the advantage that it is probably faster as well.
|
|
|
|
|
Hi Everyone,
First: what is desired
Most of us probably know this trick for clipping of the time part of a DATETIME value (at least you can find it in an awful lot of places on the internet):
@Date = DATEADD (DD, DATEDIFF (DD, 0, @Date), 0)
It will simply get you a new DATETIME value with the time set at 00:00:00.
If you use any other datepart abbreviation you get the same but with the date or time clipped at whatever you selected.
Example: if you use MI you get your DATETIME clipped at the minute value (i.e: seconds and milliseconds set to 0).
It is very useful but it would be even more useful if it were possible to put this in a function.
Then it would be possible to call "my_f_cliptime (XXX, DateTimeValue)" in which XXX (note the lack of quotes) would be the datepart abbreviation you want to pass to the function for further use within the DATEADD and DATEDIFF operations.
The problem is that DATEADD and DATEDIFF do support datepart abbreviations but you have to include them in your source code directly.
Also: you can't pass those abbreviation as strings because DATEADD and DATEDIFF do not accept them that way.
So here is the question: does anyone know of a way to pass the datepart abbreviations (there does not seem to be a datepart variable type) or, alternatively, a way to convert equivalent strings to datepart abbreviations before passing them to DATEADD and DATEDIFF ?
For the moment I suppose there is'nt but then again you never know.
Bye
PS: I am generally not very curious but if possible I prefer knowing everything
|
|
|
|
|
According to This SO answer[^] there is no way to paramterize this argument, so you're stuck with CASE logic
Something like this would do nicely:
CREATE FUNCTION dbo.FlooredDate
(
@date DATETIME,
@interval VARCHAR(10)
)
RETURNS DATETIME
AS
BEGIN
RETURN CASE @interval
WHEN 'DD' THEN DATEADD (DD, DATEDIFF (DD, 0, @Date), 0)
WHEN 'MI' THEN DATEADD (MI, DATEDIFF (MI, 0, @Date), 0)
END
END
GO
|
|
|
|
|
Too bad, I did not see this particular answer before but it confirms a number of similar others I have seen.
I knew I could do it with a case structure like that but I wanted to do it with less code if it was possible.
It just goes to show that you can easily want it all but getting it all is a lot tougher.
|
|
|
|
|
Turn the kludge into a UDF to hide the bulk code and then you have a nice neat function to call. Especially as this feels like it should be reusable code.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
errr... thats exactly what my example had.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
