For each task, look at the workflow dialog, options tab, and the
"execute on main package thread" checkbox.
I don't know if this will work, I've often wondered ... but not enough
to sit and try it, sorry! :)
But I've had some random threading issues with DTS when I was creating
collection objects in a task, and such, even with parallelism turned
down to one, and this fixed it.
J.
On Wed, 14 Mar 2007 03:29:03 -0700, Kolos
[quoted text, click to view] <Kolos@discussions.microsoft.com> wrote:
>Hi J,
>
>There is only one package with 1 DQL connection and 4 Excel ones.
>I do as follows.
>
>1. Create an Excel table from a template.
>2. On succes 1. create the ##temp table using the SQL Server connection.
>3. On success 2. I export to Excel via Excel connection 1.
>4. On success 3. I export to Excel via Excel connection 2.
>5. On success 4. I export to Excel via Excel connection 3.
>6. On success 5. I export to Excel via Excel connection 4.
>
>As precedences are set, I think the ##temp table should be reachable for all
>Excel connections, not only for the first one.
>
>Thanks.
>
>Kolos
>
>"JXStern" wrote:
>
>> Are you sure the table is created before at least three of the
>> packages try to access it? Maybe if you turned the max threads down
>> to one, and/or run them all on the main thread.
>>
>> J.
>>
>>
>> On Tue, 13 Mar 2007 13:24:22 -0700, Kolos
>> <Kolos@discussions.microsoft.com> wrote:
>>
>> >Yes, I have one SQL Server connection. All the four Excel exports use that.
>> >
>> >Kolos
>> >
>> >"RLoski" wrote:
>> >
>> >> Is your source connection the same? Does it use the same database?
>> >> --
>> >> Russel Loski, MCSD.Net
>> >>
>> >>
>> >> "Kolos" wrote:
>> >>
>> >> > Hi All,
>> >> >
>> >> > I have the following problem.
>> >> >
>> >> > I'd like to export data to 4 Excel tables the source of which is a ##temp
>> >> > table. It works fine with the first connection to Excel, but the rest does
>> >> > not see the ##temp table, I receive 'Invalid object name' error message.
>> >> > Have you got any idea what I do wrong?
>> >> >
>> >> > Thanks for your help.
>> >> >
>> >> > Kolos
>>
>>
