anthony.green (7/6/2012)

---

For keeping the read-only copy up to date, could you not do a sort of make shift logshipping configuration, assuming that the recovery model is FULL or you are...

blom0344 (7/5/2012)

---

Hi,

Being accustomed to the Powercenter Normalizer, we try to unravel the mysteries of the unpivot component in SSIS

We want to normalize tables containing keys (integer) , numbers (integer)...

Which version of SSIS are you planning to use?

icampbell (7/5/2012)

---

How do i search a string that contains 6 or seven characters but no spaces this is to identify incorrect postcodes

ie select pk,pcode

from postcode

where pcode like '%%%%%%'

Thanks,

...

tush002sunny (7/4/2012)

---

I have the records in my flat file as below :

HDR123495968908

1111023456712345

1234567890098007

TRL4567897593494

After the use of derived column I am able to map certain characters to the particular column of database...

I suggest that you post specific questions about extracting stuff from XML strings as a separate post on one of the T-SQL forums.

Nimmel (7/3/2012)

---

I'm having trouble with understanding how to handle XML data returned by a web service. I'm struggling to the extent that I can't even think of how to logically...

Please see the Overview section here. Could it be this?

🙂 QED.

Maybe we should push for...

Do you get any build errors?

Great - thanks for posting back.

Where, exactly, did you try to change change the codepage?

I'm not logged in to SSIS at the moment, so can't give you exact details, but you need to start off...

robinrai3 (6/28/2012)

---

hi All,

I am using a single dataflow that is populating OLE DB staging tables from respective OLE DB data sources. So they all run in parallel. My question is...

tush002sunny (7/2/2012)

---

Thanks,

I tried it & it's working .

I also have to check a particular character at an index no. 8 is blank/null/not specified .

If character is not present there then...