I GOT IT,

YOU NEED TO DO THIS:

LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(Name,"BM2",""),"BM2A",""),"BM9",""),"BM11B","")))

Hope it can helps someone 🙂

Guys,

I will try it and let you know becasue I will need to change or recreate my actual package.

Thank you 🙂

I wasa planing to take the File Date System. I really dont know how to set it up.

My files can have different names, so one way will be to see...

Thank you for the advices.

Lutz solution works fine for what Im doing right now. The set of results that I need arent big, just the number of columns change.

Thank you...

OMG!

pretty easy... lol

I was tryint to do the IsNull in one only line, thats why my pivot result always get an error with that.

I see you use the varchar(8000) instead...

NOTE: I cant use the IsNull or the COALESCE, because my columns always will be different. they can be between 1 to 15.

I realize that I’m mixing real names with examples. I will show the most important columns.

Please take this as the example:

DataType of the Table to be PIVOT

#TestTable

ClientIdint

Advarchar(10)

TagIDint

Namevarchar(10)

Totalint

This will be...

Im sorry. I didnt put the entire code.

I just showed where I thought the IsNull function will be.

This is the code:

declare @columns varchar(max)

declare

I need the data in a table with each value in its own column

i will take at look at your link

Thank you very much

I need the output to be a column.

thank you 🙂

Thank you

I tried the checksum, but it didnt detect the differences. I was even forcing changes in the files and I got always the same CheckSum.

Im controling my process...

not body ?

I got the Solution:

"If " + (DT_WSTR, 1)@[User::NonProcessed] + " = 0

Begin

Insert ActiveSetTopBoxFile (FileName, Created, Modified, Hash, Processed)

SELECT " + "'" + @[User::stbinfoFileName] + "'" +...

See attach.

And image says more than a word

It was kind of hard to find out the answer. Even know its something easy, but I never use this before. I used...

I got the solution for this particular case.

Anybody is interested?