Have you looked at the T-SQL REPLACE command? It should help.

ronan.healy (5/14/2014)

---

hi i have the following text in a coulmn

Net Asset Value for Ignis Absolute Return Government Bond Fund . Class A GBP

Total Outstanding shares for Ignis Absolute return...

Are you using SSIS 2012?

So how are you executing the package?

According to the examples here[/url], that number is not included. Can you post the code fragment that creates the output?

brad.mccollum (5/8/2014)

---

I must say, the Project Deployment Model as opposed to the Package Deployment Model seems overwhelming as far as the differences, the length of time it appears to take...

Eirikur Eiriksson (5/9/2014)

---

Hadrian (5/9/2014)

---

Hi,

I have a folder which receive the CDR and CMR files sended by Cisco.

There is no datetime for them,but I wish to move on another folders separated...

As you're using 2012, can I assume that you are using the project deployment model? If not, can you explain why?

The configuration methods you mentioned are superseded in 2012. You...

vanamali (5/7/2014)

---

People who can answer my question can understand it. If you don't know anything about it why do you respond? I am sorry, I am not trying to be...

twin.devil (5/6/2014)

---

There are two ways to achieve for update

1. Use this Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services[/url] which is a slower way...

Text is a deprecated datatype - are you able to consider a datatype change? Varchar(max) or, even better, Varchar(nnn) if your column width won't exceed 8000.

If yes, this update should...

Use breakpoints.

Dataflow task.

UNC paths need to use local disks, as far as I know. But if you can map a drive to another server, you should also be able to point a...

If you log in as that service account, are you able to navigate to that path in Windows Explorer? Is that definitely a local drive on the server?