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...

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.

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.

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"...

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

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...

I dont think i have permissions to perform this action...

sp_addlinkedserver

Emmanouil

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...

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...

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...

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 🙂

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...

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...

hehehehehehe, I like your thinking mate 🙂

Yes I am actually,I used it recently on a different program.

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...