RBarryYoung (5/13/2009)

---

Rich96 (5/13/2009)

---

RBarryYoung (5/13/2009)

---

That will remove all of the zero characters from [Account] if account is a string. Is that what you wanted to do?

If your intent was to change...

RBarryYoung (5/13/2009)

---

That will remove all of the zero characters from [Account] if account is a string. Is that what you wanted to do?

If your intent was to change all of...

I probably didn't make myself clear. I'm using the Derived Column Transformation Editor.

Thanks ksullivan!!! I'll check out BOL's topic "SQL Server Batch or Task Scheduling".

not sure if this will resolve your error 547 but it did mine just now.

my publisher and subscriber table had no records. so upon initializing the snapshot I...

That did it. Thanks Matt.. 5 stars.

I finally found a table of characters.. if anyone is interested.

http://www.dropbears.com/u/utilities/character.htm

So true Vladen. I'm having to forge ahead with the ASSumption that it won't change.....

Fortunately the records will always be in sequential order based on the key column. I verified with the programmer that same question you had and it will never be:

new

10203003275...

Thanks for the replies!

Jacob's solution was right on. The only thing I tweaked was the Order By, I went with the KEY instead of the column.

with cte as (

select...

Nevermind. Should've finished my research...

I ended up using a For Loop Container and setting a counter limit variable really high, like 999. It's going to work for me.

Solid. Thanks Mukti!

You can always use the BCP tool and wrap that into a batch file and then add an "Execute Process Task" to your package.

bcp "Select * from dbo..table FOR XML...

I had all kinds of issues when using OLE DB providers to connect to my iSeries. I ended up creating a Linked Server, it ended my pain with extracting...

The only thing I changed was (BOLD below) the <= to a <. So that it would not include the next '+' since that starts another new set.

create table...

I'm in the presence of Jedi masters.... that did it! I have much melon candy to consume... thank you all for your contributions..