Viewing 15 posts - 421 through 435 (of 1,118 total)
mukisql2008 (2/3/2010)
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...
February 4, 2010 at 10:31 am
Ananda-292708 (2/2/2010)
The 32bit server has got 48gb Memory, with SQL...
February 4, 2010 at 10:19 am
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.
February 4, 2010 at 10:14 am
ryan213 (2/2/2010)
February 2, 2010 at 1:08 pm
ryan213 (2/2/2010)
Do I need to install the CozyRoc software on the actual machine that's running the job? I develop the package on...
February 2, 2010 at 10:00 am
imani_technology (2/1/2010)
"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...
February 1, 2010 at 5:39 pm
ryan213 (2/1/2010)
CozyRoc (9/29/2008)
February 1, 2010 at 3:27 pm
You can check this script for ideas.
January 31, 2010 at 2:34 pm
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...
January 30, 2010 at 2:55 pm
Try to reinstall your Oracle client. There must be something missing.
January 28, 2010 at 1:08 pm
imani_technology (1/28/2010)
Yes, the machine is 64-bit! We are using 64-bit SQL Server 2005 on top of 64-bit Windows Server 2003. Is there a way around the problem?
You have...
January 28, 2010 at 12:16 pm
Is your machine 64bit? The Oracle driver is available only in 32bit mode.
January 28, 2010 at 12:03 pm
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...
January 28, 2010 at 11:22 am
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...
January 28, 2010 at 11:18 am
If you can use third-party solutions, check the commercial CozyRoc OpenPGP Task. It is completely integrated in SSIS and easier to use.
January 28, 2010 at 11:15 am
Viewing 15 posts - 421 through 435 (of 1,118 total)