may seem a bit pricky, but do you have a graphical representation of it?

will this be done with ssis and with what particular task will i be using?

Thats right....

Hiya

Please look at the attached spreadsheet, for further details and how the fiscal week is based on.

there are about 25,000 rows with the P character in front of the value, and what i want to do is to remove the P, in front of all values...

Will this create the CR UNIX csv file format? and besides that column heads are not to exist within the file.

when using data viewer in data flow

Thats right, the file created is empty, but when I preview it, i can see data.

thats right in a carraiage return unix format

select 'SKU,A,' + dbo.fn_digit(ItemID) + ',' + dbo.fn_digit(ItemID)+ ',' +

SUBSTRING(Description, 1, 40) + ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,' + CID + ',

' + SID + ',,,,,,,' + CAST([Cost Price] As nVarChar(32)) + ',T,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,'

FROM...

its a bespoke query, have you come across this problem before?

Hiya

Will this be at the end of my query, begining or within?

eg:

select * from table where + char(13) + char(10).

thats strange i thought the option of a variable can do that?

Hi there

do you know how i can configure the package to create an incremental file name each time it is dumped into the required locaton?

eg

file00001, file00002, file00003

Got the following errors:

Msg 134, Level 15, State 1, Procedure usprunreport, Line 5

The variable name '@startdate' has already been declared. Variable names must be unique within a query batch or...