This should do it, you may have to convert the values

Function Main()

 sTemp = DTSSource("Col001")

 iThere = InStr(sTemp, ",")

 DTSDestination("Column1") = Left(sTemp, iThere - 1)

 sTemp = Mid(sTemp, iThere + 1)

 iThere = InStr(sTemp, ",")

 DTSDestination("Column2")...

Personally I would write an ActiveX script to parse the data into separate columns as part of the transformation process.

LEN([column])-LEN(REPLACE([column],',',''))

Yes, however ALTER will create a second entry in sysobjects with an increased value of base_schema_ver.

DROP will remove all these entries and another CREATE will set it back to 0.

using...

The only way I can see to make this work is to input the data as one column and process the data, using your eample of

20040325,000072,005309,1.00,1.00,2.00,LUNCH

pass the first 3...

This question was asked on a thread a while ago and I think someone's solution was to only DROP / CREATE procedures and to snapshot the creation dates daily (or...

I presume that LSeries can be any value or is it as per your example limited to 999?

But why a nested cursor!

One cursor to get distinct LSeries and do a...

Presumably you are writing a procedure to do this so the answer will depend on how you pass the dates.

If you pass them as a single delimited string then two...

Peter,

That is fine as long as the procedures are called in sequence, if there is any logic that may or may not execute one or more procedures (or series of procedures) then unless...

Hmm, seems like you've been there and done that Kenneth

if you have a linked server setup then

SELECT *

FROM OPENQUERY(servername,'SELECT * FROM [TableB]')

otherwise

SELECT *

FROM OPENROWSET('MSDASQL','servername';'loginname';'password','SELECT * FROM [TableB]')

you can also join local and remote tables like...

the IDENTITY property alone does *not* guarantee uniqueness.

** Only if you fiddle while Rome burns ** ...

Well, Frank, I've heard of sitting on the fence but it looks like you've jumped it and half way across the field.

Frank is...