Erin-489205 (3/4/2010)

---

I need to populate a table in MySQL with data from a SQL view. I am trying to figure out how to create the destination. I have...

You can pre-process the file with LF only and replace it with CR LF. You may check this script for reference.

Hi,

There is Windows 7 x64 compatibility issue. We are working with the Microsoft team to resolve this problem. The instructions how to fix it manually are posted in the FAQ...

This setting will not work unless you use the exact same user account you have used to create the package. I would recommend you setup to use EncryptAllSensitiveWithPassword. Then...

DKlein (2/19/2010)

---

Thanks for the responses, the package is housed in our Dev-environment and one of the data sources is from a production box, so I am not permitted to grant...

Can you try to deliver the file as a test using other method like email? My point is...

Have you tried to decrypt the file locally before sending to the remote location? Did it work? Also what...

I understand this. But what connection manager do you use to transfer the files?

msumangupta (2/19/2010)

---

Hi

I encrypted a text file using OPENpgp Task provided by CozyRoc.

When the other end of the line is trying to decrypt it, they receive a error saying that,...

Niall Duggan-433856 (2/19/2010)

---

Hey all,

Wanted to take a database and export all the documents from it using either t-sql or ssis package. It would be a nightly job that would...

DKlein (2/19/2010)

---

Hello all,

I am trying to put together a package that reads data from two different servers and writes to a third, the third server is also, where the package...

haggisns (2/19/2010)

---

Hi,

I would like to create a database table from scratch using a flat file.

I create my flat file connection and db connection and control flows and dataflows.

However when I...

Paul_Harvey (2/4/2010)

---

Hi all,

I am trying to do some basic integrity checking on incoming email addresses. I want to add a Derived Column to state whether or not the email...

What you are trying to accomplish is not possible with the standard Data Flow Task. The data flow is by default static. If you can use third-party solution, I would...

Have you tried...