I'd like to pass two date variables from a VB app to a "Transform Data
Task" in my DTS package. This seems to be an easy request, but I can't
find any documentation for it.

Does anyone have any snippets or docs?

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***

You can pass the value in a Global Variable:

http://msdn.microsoft.com/library/en...papps_7rj7.asp

--
David Portas
SQL Server MVP
--

Jim,

Create glbal variables in your DTS package and pass values from the vb.net
application.

Execute a package from Visual Basic (VB)
http://www.sqldts.com/default.aspx?208,1

There is an example in Page 3.


AMB


"Jim James" wrote:

Thanks for the help. However, I can't even get to that point...

I am saving my DTS package as a VB file, but I can't get it to compile.
I'm receiving an error.

"Interface 'DTS.OleDBProperties' cannot be indexed because it has no
default property.

Do you know what this error could be in reference to?

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***

Jim,
If you want to execute a package from VB.Net there is no requirement to save
your package as a VB file.

Regards
Jamie Thomson
An SSIS blog - http://blogs.conchango.com/jamiethom...tegory/71.aspx


"Jim James" <rrichards (AT) exabyte (DOT) com> wrote