Actually, I have SSMS, just no reports. That's why I am looking for DMVs etc to help me figure out how big this one record is. Looks like I need...

One possible way around this is to create a SQL Agent job which runs the package and then to allow the user to kick off that job, rather than the...

Use Redgate's free SQL Search tool - no coding required and works well.

Turncoat!

🙂

Ah, you must mean the magic-wand component.

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!