>>>>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?