mukisql2008 (2/3/2010)

---

Hi,

I want to create a SSIS package to send an e-mail upon completion.

The problem is my SMTP server is not windows and requires a username and password.

Is there...

Ananda-292708 (2/2/2010)

---

I have an SSIS code. This was running fine until last one week. Now its failing saying below error.

The 32bit server has got 48gb Memory, with SQL...

You can use standard Foreach Loop where you can specify wildcard. The loop will hopefully do one iteration and you can rename current iterated item to your destination static name.

ryan213 (2/2/2010)

---

Will I need licensing for this? I've downloaded SSISPlus14.msi from the cozyroc site and that's what I've been using on my machine. Will I need some sort of...

ryan213 (2/2/2010)

---

I restarted but it didn't work.

Do I need to install the CozyRoc software on the actual machine that's running the job? I develop the package on...

imani_technology (2/1/2010)

---

We re-installed and got the following error:

"Test connectionfailed because of an error in initializing provider. The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.

Also, I followed the...

ryan213 (2/1/2010)

---

CozyRoc (9/29/2008)

---

Check CozyRoc's SSIS+ library, if you want straightforward solution. It is your choice. You either have time on your hands or you want to get the job done...

You can check this script for ideas.

You have to include a class attribute of type double and use the algorithm you have correctly described to find the highest current value in the ProcessInputRow method. Store the...

Try to reinstall your Oracle client. There must be something missing.

You have...

Is your machine 64bit? The Oracle driver is available only in 32bit mode.

I don't think you will be able to resolve this issue from the SSIS side. 200,000 objects is crazy to start with and probably the SSIS team never expected to...

Use quoted year like "Year" in your SQL statement, too. Probably Year is keyword in the specific SQL dialect you use and the quotes will help the database engine handle...

If you can use third-party solutions, check the commercial CozyRoc OpenPGP Task. It is completely integrated in SSIS and easier to use.