Not really what I asked for. What is your...

Write out your detailed logic for breaking the column into three and we'll help with the solution. Might need a Script Component if...

Use a multicast to broadcast data from one source to multiple destinations.

I suggest that you search for something like "shredding a recordset in ssis".

Not until you prove that you have tried. There are plenty of resources available on the Internet for this fairly straightforward task. Come back...

Never seen anything like it, sorry, no idea at all.

Luis Cazares (8/29/2012)

---

It should be char or varchar.

Ideally you should only store the digits and format the phone in the front end. However, you'll need an extra field for extension...

Nasty. Can you explain a bit what the package is doing?

If you remove that expression, does the package work?

Is pageref.cpp something which you are explicitly using in the package?

harri.reddy (8/28/2012)

---

hi

in my package i am gettign error like ,

truncation may occur due to inserting data from data flow column "Copy of Column 34" with a length of 20...

+1 - no idea what's going on here!

You could right click on the table in SSMS and select SCRIPT TABLE AS / SELECT To / New query editor window.

That will build a SELECT query for you containing...

If you're using full cache, I am not certain that the index will help (it's loading all the columns into memory anyway) - but worth a test.

The index would, however,...

The same comment applies as from your last thread. There is no guaranteed row order in SQL tables, therefore you cannot ask for 'the first occurrence' unless you define an...

ganeshkumar005 (8/24/2012)

---

for 'D1234', the first time it appears while reading from top, the value against it is 1001. I want this row in result. And skip the others if 'D1234'...

ganeshkumar005 (8/24/2012)

---

I have a table:

D12341001

A11224001

D12342001

C13425001

B19646001

A11223001

you can see leftside values D1234 and A1122 are repeated. Now I want the result as very first numerical ID returned when I meet the alphanumeric...