Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Executing Package on 64 bit machine Expand / Collapse
Author
Message
Posted Monday, September 07, 2009 6:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 15, 2010 5:49 AM
Points: 32, Visits: 82
This particular code executes properly when executed on 32 bit windows 2003 with no errors

Its throwing error on 64 bit machine only.

package functionality is importing excel data into sql database... so just the sql credentials have been entered.
Post #783734
Posted Monday, September 07, 2009 8:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:04 PM
Points: 1,114, Visits: 2,192
amit (9/7/2009)
This particular code executes properly when executed on 32 bit windows 2003 with no errors

Its throwing error on 64 bit machine only.

package functionality is importing excel data into sql database... so just the sql credentials have been entered.


Again my question what is the package protection level in use?


---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #783818
Posted Monday, September 07, 2009 9:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 15, 2010 5:49 AM
Points: 32, Visits: 82
DontSaveSensitive
Post #783825
Posted Monday, September 07, 2009 10:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:04 PM
Points: 1,114, Visits: 2,192
amit (9/7/2009)
DontSaveSensitive


You said you are using SQL Server credentials to login. But with this setting unless you provide the password with external configuration file, the connection will not work.

You said you already had this package working from another machine. Do you use exactly same user account on both machines?


---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #783850
Posted Monday, September 07, 2009 10:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 15, 2010 5:49 AM
Points: 32, Visits: 82
The package on both the machines are different but have the same functionality with diffrent sql connection.

the common is the asp.net code on both the machines
Post #783859
Posted Monday, September 07, 2009 11:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:04 PM
Points: 1,114, Visits: 2,192
amit (9/7/2009)
The package on both the machines are different but have the same functionality with diffrent sql connection.

the common is the asp.net code on both the machines


What is the package protection level on:

1. The working machine?
2. Not working machine?

What is the sql connection setup on:

1. The working machine?
2. Not working machine?


---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #783861
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse