What is the purpose of the foreach container?

Worth a test, though I would expect SQL to SQL to be the fastest.

I think you might mean a script task, and I agree.

The extra flexibility (and, I...

It was in a previous role and I don't still have the...

Have a read here[/url].

i.campbell (7/6/2012)

---

Hi All,

i have an SSIS package that loops round a recordset, it takes a file name and path and copies it into other directories, updates a DB entry and...

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.