Lowell (21/09/2007)

you gotta try what i posted: you end up with a 15 character string with the preceeding zeros you requested.

SELECT RIGHT('000000000000000' + CONVERT(VARCHAR,1),15)

SELECT RIGHT('000000000000000' + CONVERT(VARCHAR,86456),15)

SELECT...

Lowell,

I thing my question was not so clear, as i say before the 000000000086456 parts is always 15 character, that mean when i get a higher row number for example 765486456 then I have...

Dear Jeff,

I have to calculated, 53910072007 parts is date and time (hmiddmmyyyy) and 000000000086456 parts is total row. With Lowell scripts and after a little changing I can make the following...

Lowell,

Thank you very much.. It works.. You don't have any idea how long I was busy with this script..

Hi,

It looks like my question is too difficult or not so clear, so I will like repeat my question.

I want to export data from...

Vladan,

you are right about the export and headers things. well what i want to have is:

The table i have look like this:

Column1         Column2

1                   Hi

Well.. it working.. I made manually a format file.. as fallowing:

7.0

1

1  SQLCHAR 0  100  ""  1 column name  ... etc,  and then i used bcp utility to fill the table in the...

here are the hex editor view too, i used xvi32 hex editor.

http://www.mediafire.com/?04y4uyj9tne

thx again..

Cees

Here you are.. you can download the file from this link..

http://www.mediafire.com/?efcdmj9n4x1

thx..

Cees

Dear Noeld,

I get zipped .dat file from the FTP. I have first unzipping the file op the server and then use it in the DTS.

Now as I said before...

I tread to made a file format by using the fallowing.. Command:

bcp c:\or\test.dat format nul –T –n –f c:\ds\test.fmt