May 15, 2012 at 3:53 am
Hi to all, I'm migrating an old SSIS 2005 version to a SSIS 2012 structure (on a new machine Windows 2008 R2 64 bit).
I've converted DTS package using SQL Data Tools and all seems to be ok.
To run the package I use a .bat file with the following syntax
dtexec.exe /FILE "D:\SSIS\MySSIS.dtsx" /CONFIGFILE "D:\SSIS\MySSISConf.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI > Log_DTEXEC.txt
We're planning to move our environment from Windows 2003 32 bit to Windows 2008 R2 64 bit
If I run the .bat file I get the following errors:
The requested OLE DB provider SQLNCLI.1 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
Consider changing the PROVIDER in the connection string to SQLNCLI11 or visit http://www.microsoft.com/downloads to find and install support for SQLNCLI.1.
I've change in MySSISConf.dtsConfig from SQLNCLI.1 to SQLNCLI11.1
but the error still the same.
I've searched on web for a solution and tried to execute 32 bit version of dtexec.
To be sure I've copied my dtsx and dtsconfig file in C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn and ALL IS WORK FINE ????
Can someone suggest me a way to investigate the problem?
Thank you in advance for your help.
Best regards
Fabrizio
May 16, 2012 at 1:47 am
So you converted the package in SSDT and it works there just fine?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 16, 2012 at 1:53 am
Thank you for your reply, yes, I've made a step ahead (I hope;-)).
I've succesfully call .bat file in my working directory but I need to Run As Administrator the bat file.
I've made a small C# program to start .bat file and the behaviour is the same, I need to run As Administrator the exe to succesfully run dtexec.
The strange (for me) thing is that I'm an administrator so why do I have to run As administrator bat file or exe file?
Thank you again for your help.
Fabrizio
May 16, 2012 at 1:55 am
fabriziocrespi (5/16/2012)
Thank you for your reply, yes, I've made a step ahead (I hope;-)).I've succesfully call .bat file in my working directory but I need to Run As Administrator the bat file.
I've made a small C# program to start .bat file and the behaviour is the same, I need to run As Administrator the exe to succesfully run dtexec.
The strange (for me) thing is that I'm an administrator so why do I have to run As administrator bat file or exe file?
Thank you again for your help.
Fabrizio
That last one is probably User Account Control being funny.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 16, 2012 at 2:41 am
I'd like to create a WCF service to start bat programmatically, do you know how to configure WCF service to start as Administrator ? I've tried from service console but it seems not to work.
Thank you
Fabrizio
May 16, 2012 at 2:44 am
Sorry, WCF services are out of my comfort zone.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply