>>>>>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.
If it's not broken, fix it until it is.
My Blog