Viewing 15 posts - 11,536 through 11,550 (of 13,416 total)
gayathridevi.msit (7/15/2010)
hi,Try script component between excel source and database destination.
In script component use a function , if '-' then null.
insert the column into database as null value..
That will do...
July 15, 2010 at 4:29 am
Please provide sample input data, along with desired output data.
July 15, 2010 at 12:47 am
The general solution to this sort of problem is to import the entire row into a single big varchar field and then break it up into your required fields as...
July 15, 2010 at 12:45 am
Vernon Jimmerson-306463 (7/14/2010)
July 14, 2010 at 1:26 pm
skcadavre (7/14/2010)
INTs don't have 0's padding. If you want to keep them, you'll have to use something else, e.g. VARCHAR.
I'd leave it as int and add a char(4) derived column...
July 14, 2010 at 9:13 am
riajain9 (7/13/2010)
Here is the solution in SSIS...Pls Let me know , how can I do the same in T-SQL, do you want me to post it there again
Yes - I...
July 13, 2010 at 1:55 pm
This is looking like a challenge. Other than using a chunk of procedural code to read through the data line by line (in order) and add a 'Group Number' field,...
July 13, 2010 at 10:54 am
Raunak Jhawar (7/13/2010)
Hi Ria,This is simple. You have to use SQL Windowing functions such as ROW_NUMBER,RANK,DENSE_RANK with the OVER CLAUSE using Partition...:cool::cool::cool:
Hope this helps!!!
Please present your simple solution.
July 13, 2010 at 10:46 am
You'll have a problem with September if you use that code verbatim!
<= 9 works better 🙂
July 13, 2010 at 7:07 am
Ed Zann (7/12/2010)
July 12, 2010 at 10:38 am
There is a much simpler way: use the FOREACH container to loop round all files in a folder and (if required) its sub-folders.
July 12, 2010 at 5:59 am
This is an SSIS forum. I suggest that you raise this in the T-SQL forum here.
July 9, 2010 at 3:15 am
Viewing 15 posts - 11,536 through 11,550 (of 13,416 total)