>>>>>>Well, what do you have in tcAlias variable and do you have a table opened with this alias? Try debugging this stuff, I haven't had a need to work with it myself.
>>>>>>
>>>>>>
>>>>>>>but tcAlias is supposed to be empty isnt it? at least my DE is
>>>>>>
>>>>>>P.S i saw your threads on SSID...Did you ever figure it out?cause i think ill get en enterprise SQL sever
>>>>>
>>>>>Which thread do you mean?
>>>>
>>>>
>>>>http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c32c0820-0e2d-4461-820a-530541c769c6/
>>>
>>>Well, the first part - creating a package - worked fine with the steps outlined - I even have a blog on this topic. Since I was doing this as an exercise, I never finished it to figuring out how to make it a job.
>>
>>
>>you used SQL Agent?
>
>No, I think I was trying to create a job from the interface (yes, using SQL Agent). If you're using SQL Express, you would not be able to even create a package as I specified, because you need to use BIDS for that.

yea well i have Express think ill get enterprise soon.

http://www.craigbailey.net/vfp-importing-vfp-data-into-sql-server/

maybe you could take a gandar at this page...he talks about using SQL agent to create a job maybe it can help you :)
i printed a 50 page document to read to night (its not so big but he used alot of screen shots to walk you through it)