OT - SSIS Blank Title 129694

Yahoo Archive
1
Run SSIS in 32 bit mode.
There is checkbox setting in jobs.

Hth,
Calvin

Sent from my Verizon Wireless 4G LTE Smartphone

----- Reply message -----
From: "mtisland@..." <mtisland@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Subject: [Vantage] OT - SSIS
Date: Thu, Apr 24, 2014 8:02 AM

 

I need help with an SSIS package issue involving SQL 2008 (NOT 2008 R2) on a 64 bit server trying to hit the Progress database using the 32 bit 10.2A driver. The 32 bit driver is installed on the server and has a 32 bit DSN setup with it, but I cannot get past connecting to the database using the DSN. I also tried it on my local machine and it is not working there. I can get this to run on a 2008 R2 server using a connection string, but that is not available in 2008.


Anyone out there have any tips or tricks to get this to work?


Thanks in advance.

2

I need help with an SSIS package issue involving SQL 2008 (NOT 2008 R2) on a 64 bit server trying to hit the Progress database using the 32 bit 10.2A driver. The 32 bit driver is installed on the server and has a 32 bit DSN setup with it, but I cannot get past connecting to the database using the DSN. I also tried it on my local machine and it is not working there. I can get this to run on a 2008 R2 server using a connection string, but that is not available in 2008.


Anyone out there have any tips or tricks to get this to work?


Thanks in advance.