April 4, 2016 at 7:42 am
Hi Team,
I have windows server 2008 r2 64 bit box where I have setup my Integration services.
The SSIS packages are called via .net c# 2.0 directly connection to SSIS sql store (not via SQL agent Jobs).
When I use excel manager and execute via .net , I get below error:
"The Excel Connection Manager is not supported in the 64-bit version of ... "
One way is to schedule SQL agent Job (set 32 bit envrmnt to true), but since application design doesnt allow to call SQL Jobs from .net , we dont want to implement this way.
My Question:
> Is der a way of using excel manager on 64 bit , it's very strange that 64 bit does not support excel manager !
> I have also installed 32 bit runtime components of integration services.
Please provide inputs of this. Thank you !
April 4, 2016 at 8:07 am
GonnaCatchIT (4/4/2016)
Hi Team,I have windows server 2008 r2 64 bit box where I have setup my Integration services.
The SSIS packages are called via .net c# 2.0 directly connection to SSIS sql store (not via SQL agent Jobs).
When I use excel manager and execute via .net , I get below error:
"The Excel Connection Manager is not supported in the 64-bit version of ... "
One way is to schedule SQL agent Job (set 32 bit envrmnt to true), but since application design doesnt allow to call SQL Jobs from .net , we dont want to implement this way.
My Question:
> Is der a way of using excel manager on 64 bit , it's very strange that 64 bit does not support excel manager !
> I have also installed 32 bit runtime components of integration services.
Please provide inputs of this. Thank you !
I take it that you are running dtexec.exe to run these packages from your code? If so you can use the "/X86" switch to run them in 32 bit mode. https://technet.microsoft.com/en-us/library/ms162810%28v=sql.105%29.aspx
April 4, 2016 at 8:00 pm
I use
Microsoft.SqlServer.Dts.Runtime.Package.Execute()
How do I control dtexec to run in 32 bit from c# code?.
April 5, 2016 at 12:19 am
GonnaCatchIT (4/4/2016)
I useMicrosoft.SqlServer.Dts.Runtime.Package.Execute()
How do I control dtexec to run in 32 bit from c# code?.
C# is not exactly my forte, but can you not just use Process.Start? Like:
Process.Start("dtexec.exe", "Arguments here");
More here: http://stackoverflow.com/questions/10530303/execute-a-program-which-accept-command-line-parameters
April 8, 2016 at 4:25 am
OK , so the options are to use command line or call a SQL Job from .net.
Thank you all
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply