I have noticed that my processing all fails on the first section of the application, that actually imports the excel file into the database, its a powershell script, with the...

Hi, I tried that.

web.config looks like this:

<runtime>

<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

<dependentAssembly>

<assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>

<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>

</dependentAssembly>

<dependentAssembly>

<assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>

<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>

</dependentAssembly>

<dependentAssembly>

<assemblyIdentity name="Microsoft.SqlServer.Smo" publicKeyToken="89845DCD8080CC91" culture="neutral"/>

<bindingRedirect oldVersion="0.0.0.0-10.0.1600.22" newVersion="10.1.2531.0"/>

</dependentAssembly>

</assemblyBinding>

</runtime>

I get the following error:

Exception calling...

Hi Tom

I just double checked the server, it has a newer version than my dev machine

SMO v10.1.2531.0

Do I try and still this version on my dev machine rather?

Thanks for the info!

Hi Tom

Its MS SQL Server 2008 Management Objects

Version 10.0.1600.22

Thanks.

Hi

SMO is not installed on the server, the version on my dev PC is

MS SQL Server 2008 Management Objects

Version 10.0.1600.22

Can I install this to make it work?

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16978

2008 R2...

I changed the connection type from connector/Net to connect/ODBC 5.1

working 100% now 🙂

If I click on the preview button for the ADO.Net datasource it comes up empty, but I now the rows are there, even if I simplify the query, it still...

ok, I set the ownder of the job to the user account running it and granted execute access to the sp_start_job procedure, but the job fails with the following:

Non-SysAdmins have...

I tried that, reset the privelegs on the user account and made it it the owner, but now it doesn't want to execute the dbo.sp_start_job procedure

will grant it execute access...

Hi

Yes I can do that, but then I just have to make sure that account has enough privileges to run the job?

Thank you.

wow, that easy!

thanks for the tip, will keep that in mind, and thanks a lot for the help!

need to read up on FOR XML

mmm, it loads all the columns as VARCHAR(8000)

I will just cast them when I do the updates.

Thanks.

Thanks, will have a look at it.

Thanks Koen, that was going to be my next work around if this doesn't work.

I guess I will create a script that checks for each column and imports the data.

Thanks...