I'm transfering data from a SAP system to my local SQL Server 2005
Database by using customized RFCs with SSIS. I'm using .NET Data
Provider for mySAP Bussiness Suite.

By example I simply create a SAP Connection (.NET Data Provider for
mySAP) and a Data Reader Source and set the SqlCommand property of Data
Reader Source as "EXEC Z_RFC001 @BEGINDATE='20040101,
@ENDDATE='20040131'". Then set the target and execute.

The Z_RFC001 function has two parameters BEGINDATE and ENDDATE
hardcoding them in SqlCommand property is not an effective way.
Especially if you are thinking to schedule a task that updates your
local table in your database.

For the table updating issue: I'm trying to find a way that provides me
the automatic SqlCommand property setting. I tried many different ways
like setting SqlCommand as an expression of Package variables but it
didn't work. Now I'm trying to create a Script Task that changes the
SqlCommand property of the Data Reader Source. And I'm not going on
this well. My further idea is to schedule a program that edits the
Package.dtsx file and execs a batch like "dtsexec Package.dtsx".

Do anybody know a solution for this mechanism?