How to Connect VB and Visual Foxpro

I have some tables in .dbf format, I want to connect VB
and Visual Foxpro 6.0. How to connect VB with .dbf in
Visual Foxpro.Via ADO using the FoxPro ODBC or OLEDB driver.
If you need more help, post to one of the Fox groups such as
microsoft.public.fox.programmer.exchange.
--
David Portas
--
Please reply only to the newsgroup
--
"K.G.Palanisamy" <sendprasath@.yahoo.com> wrote in message
news:04cf01c3460d$605c3280$a001280a@.phx.gbl...
> I have some tables in .dbf format, I want to connect VB
> and Visual Foxpro 6.0. How to connect VB with .dbf in
> Visual Foxpro.

How to connect ExecuteSQLTask with data flow task

Hi, there;
I am doing my first SSIS project that moves data from dbf file to SQL2005.
What I did here is that I created a dataflow task (move data)with ASP.NET successfully (Very happy!). Now I want to create an ExecuteSQLTask that runs before data flow runs. This ExecuteSQLTask is used used to create a table if there is no destination table in the SQL2005.
This can be done easily in SSIS design mode, just need to connect those two box with a green line: )
I had a look example from MS website, but I didn't find a code example to connect this two task.
Does anybody know how to resolve this or have any link with sample code?

Big thanks here.

Not sure what the issue is. Just drag the green line to the data flow task.|||

I am creating SSIS package from C# manully, not using the SQL Server Business Intelligence Development Studio at all. So I'd like to know how to connect these two task using C# code.

Thanks.

|||

Try this:

.....

//Create the package
Package pkg = new Package();

//Add the tasks
TaskHost sqlTask = (TaskHost)pkg.Executables.Add("STOCK:SQLTask");
TaskHost pipelinetask = (TaskHost)pkg.Executables.Add("STOCK:PipelineTask");

//Add the PrecedenceConstraint
PrecedenceConstraint pc = pkg.PrecedenceConstraints.Add(sqltask, pipelinetask);
pc.Value = DTSExecResult.Success;

.....

HTH,
Ovidiu Burlacu