SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Execute Process Task Variables as Arguments
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cidr
Posting Yak Master

United Kingdom
204 Posts

Posted - 05/12/2013 :  19:42:11  Show Profile  Reply with Quote
Hi

I have a package with an Execute Process task. The process task executes a custom exe that imports rows into a SharePoint list (a complex one that SP destination containers can't handle)

I pass two arguments to the Task; URL (of the Sharepoint site) and Excel path)


URL and Excel path
@SiteURL: http://devserver/Demo
@ExcelPath: C:\SSIS\Import.xlsx

String variables as Arguments
@SiteURL + " " + @ExcelPath.


Unfortunately I get an error in the command window:

"System.Data.Ole.Db.OleDBExeption : The Microsoft Access database engine could not find the object 'Sheet1$'. Make sure the object exits and that you spell...."

It works fine when the arguments are the actual URL and Excel path. Perhaps I have to configure the varibles in a different way.

Any ideas?

Thanks

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/13/2013 :  01:21:37  Show Profile  Reply with Quote
How are you getting the values for URL and Path variables? Are you passing it or do it get from an expression?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

cidr
Posting Yak Master

United Kingdom
204 Posts

Posted - 05/13/2013 :  06:39:23  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

How are you getting the values for URL and Path variables? Are you passing it or do it get from an expression?


That's possibly where I'm missing something. I'm adding the variables in the variable window with the URL and the Path as the values for each and then adding the variable names to the Arguments.

Do I have to add the variables as expressions? I think I've missed doing something here.

Thanks

Edited by - cidr on 05/13/2013 06:40:26
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/13/2013 :  06:46:50  Show Profile  Reply with Quote
quote:
Originally posted by cidr

quote:
Originally posted by visakh16

How are you getting the values for URL and Path variables? Are you passing it or do it get from an expression?


That's possibly where I'm missing something. I'm adding the variables in the variable window with the URL and the Path as the values for each and then adding the variable names to the Arguments.

Do I have to add the variables as expressions? I think I've missed doing something here.

Thanks


You need to if you've to get values on the fly. The variables have a property called EvaluateAsExpression which should be set to true and then give expression under expression builder available from variable properties window.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

cidr
Posting Yak Master

United Kingdom
204 Posts

Posted - 05/13/2013 :  06:48:24  Show Profile  Reply with Quote
OK, thanks, I'll give it a go
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/13/2013 :  06:49:33  Show Profile  Reply with Quote
fine...let me know if you face any more issues and need any more help.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000