Viewing 15 posts - 1 through 15 (of 18 total)
Hi,
I was wondering if you could give me some advice regarding the following:
Let's say you have a table with a varchar() column that contains date values in different format.
What if...
April 10, 2008 at 2:15 am
Hi mate,
Is there a way you can unzip/extract files in a directory via T-SQL? by that I mean without using SSIS or DTS packages.
March 13, 2008 at 2:15 am
I'm trying to automate the process mate.I'm using Bulk Insert and it's pretty quick assuming the data is consistent. Although MS Access will be used for complicated and bad files.
February 7, 2008 at 12:33 pm
Do you know of a way to import just one line of the file?
the followinf for example imports the whole data in one row per line...
exec xp_cmdshell 'type "\\sigfiler1\Data$\EuroDirect Departments\Production\Neptune\CallTraceFormatFiles\datacsv56.csv"...
February 7, 2008 at 7:55 am
Im thinking the following and then compare that to the initial length...
Is that what you meant?
replace(RowData,',',0) from #RowTable where ID = 1
February 7, 2008 at 7:43 am
Hey jeff,
Do you know of any way to count how many columns a file has (other than the manual way...)?
The files are usually comma delimited, tab delimited, or fixed length.
I'm...
February 7, 2008 at 5:13 am
I dont think i have permissions to perform this action...
sp_addlinkedserver
Emmanouil
February 5, 2008 at 3:03 am
That was a little too much for my knowledge... 🙁
How about a dummies guide...?
I'm using MS SQL 2005.
Assuming that my datafile is in:
\\sigfiler1\Data$\EuroDirect Departments\Production\Neptune\CallTraceFormatFiles
and my format file is in:
\\sigfiler1\Data$\EuroDirect Departments\Production\Neptune\CallTraceFormatFiles\csv
What...
February 5, 2008 at 2:22 am
That's fine, mate.
At least now I know that's the only way.
Thank you very much everybofy for your help.
i really appreciate it.
I will keep you posted of any other issues...
January 25, 2008 at 3:53 am
Nahh,
It's the bulk insert that doesn't work... That's to do with the format file and the structure of the data.
If the delimitor used for this kind of data is...
January 25, 2008 at 1:14 am
there must be something wrong with the data then because it doesnt work...hehe
nevertheless I'll work it out. thank you for all this information. I really appreciate it 🙂
January 24, 2008 at 10:09 am
Hi,
That was way more stuff than I need hehe! You really work hard in here! Very impressed.
I only needed a format file sample. The format file is very similar to...
January 24, 2008 at 7:37 am
Hey guys,
I don't know what to say? Thanks a lot for all the support!!! I'm overwhelmed!!!
Just to let you know, I won't be using DTS/SSIS packages for this scenario.
One of...
January 24, 2008 at 1:17 am
hehehehehehe, I like your thinking mate 🙂
Yes I am actually,I used it recently on a different program.
January 23, 2008 at 2:13 am
Sorry mate,
Here's the table.
Also how can you get it to NOT include spaces between columns. For example, if some of the rows are pushed to the left that will...
January 18, 2008 at 9:02 am
Viewing 15 posts - 1 through 15 (of 18 total)