January 30, 2009 at 1:37 pm
Hi everyone,
we have SQL server 2005 enterprise edition with 64 bit. and Oracle client 32 bit as a data source.
I created a small package to extract data from Oracle and insert into sql server table.
Created the xml config file for the connection string to oracle and provided the password in the config file.
I am able to run the package through BIDS and also through command line dtexec using sql server agent job.
But when I create SQL server agent job with type as " SSIS PAckage" then the job fails.
can anyone suggest how to resolve this.
February 1, 2009 at 11:15 am
We cannot see the error message from here. Can you tell us what it is?
Thanks,
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 1, 2009 at 12:05 pm
I think the key is to develop the package in 32bits and move it to 64bits open the package and save it again that should fix it.
Read the blog posts referenced in the thread below.
Kind regards,
Gift Peddie
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply