3 global variables 3 sql server connections?

Hello!
I've 3 sql server connections in the DTS package. They are:
conn1
conn2
conn3
Using dynamic properties task, I set up three global variables (gv1, gv2
and gv3).
For conn1 - I am getting server value from @.@.servername. (I am running
this pkg under a sql server job). see the pkg execution code:
declare @.dtsrun varchar(300)
set @.dtsrun = 'dtsrun /F d:\DTS\Mydts.dts /N Mydts /Agv1:8=' +
@.@.servername
exec master.dbo.xp_cmdshell @.dtsrun
for conn2 and conn3, I am using ActiveX script inside the DTS pkg to get
the server values (which are stored in a table in the db).
I am getting server values for 'gv2' and 'gv3'. My question is how would
I pass "gv2" value in "conn2" and "gv3" value in "conn3"?
thanks for your help!
*** Sent via Developersdex http://www.examnotes.net ***why don't have such values into global variables? It seems the most reliable
and safe way
--
Current location: Alicante (ES)
"Test Test" wrote:

> Hello!
> I've 3 sql server connections in the DTS package. They are:
> conn1
> conn2
> conn3
> Using dynamic properties task, I set up three global variables (gv1, gv2
> and gv3).
> For conn1 - I am getting server value from @.@.servername. (I am running
> this pkg under a sql server job). see the pkg execution code:
> declare @.dtsrun varchar(300)
> set @.dtsrun = 'dtsrun /F d:\DTS\Mydts.dts /N Mydts /Agv1:8=' +
> @.@.servername
> exec master.dbo.xp_cmdshell @.dtsrun
> for conn2 and conn3, I am using ActiveX script inside the DTS pkg to get
> the server values (which are stored in a table in the db).
> I am getting server values for 'gv2' and 'gv3'. My question is how would
> I pass "gv2" value in "conn2" and "gv3" value in "conn3"?
> thanks for your help!
>
>
>
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
>

2005 Update Statistics Task fails

Hi,
Can anyone, given the history below, tell me why this task fails? Or could
you tell me how to figure out why the task fails?
Thanks,
Jim
Windows Server 2003 SP2
Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
---
Date 9/10/2007 9:58:00 AM
Log Job History (User Maintenance.Update Statistics)
Step ID 1
Server GENOME-GENDB
Job Name User Maintenance.Update Statistics
Step Name Update Statistics
Duration 00:03:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: <our_domain>\<our_sql_server_account>. ...00.3042.00 for
64-bit Copyright (C) Microsoft Corp 1984-2005.
All rights reserved.
Started: 9:58:00 AM
Progress: 2007-09-10 09:58:00.59
Source: {5D469B6D-98A4-4907-92D7-904C931892B5}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
100% complete
End Progress
Progress: 2007-09-10 10:00:10.27
Source: Update Statistics Task
Executing query "use [blast_xml] ".: 12% complete
End Progress
Progress: 2007-09-10 10:00:10.33
Source: Update Statistics Task
Executing query "UPDATE STATISTICS [dbo].[tBlastOutput] WITH SAMP".: 25%
complete
End Progress
Progress: 2007-09-10 10:00:10.33
Source: Update Statistics Task
Executing query "use [blast_xml] ".: 37% complete
End Progress
Progress: 2007-09-10 10:00:10.44
Source: Update Statistics Task
Executing query "UPDATE STATISTICS [dbo].[tBlastRun] WITH SAMPLE ".: 50%
complete
End Progress
Progres... The package execution fa... The step failed.I would create a text file for the log for more details, instead of just
relying on the job history.
You can also execute the SSIS package while in the designer window and watch
which step fails in the debug mode.
"Jim" <noreply@.noreply.com> wrote in message
news:eEJ35X88HHA.4752@.TK2MSFTNGP04.phx.gbl...
> Hi,
> Can anyone, given the history below, tell me why this task fails? Or
> could you tell me how to figure out why the task fails?
> Thanks,
> Jim
> Windows Server 2003 SP2
> Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> ---
> Date 9/10/2007 9:58:00 AM
> Log Job History (User Maintenance.Update Statistics)
> Step ID 1
> Server GENOME-GENDB
> Job Name User Maintenance.Update Statistics
> Step Name Update Statistics
> Duration 00:03:00
> Sql Severity 0
> Sql Message ID 0
> Operator Emailed
> Operator Net sent
> Operator Paged
> Retries Attempted 0
> Message
> Executed as user: <our_domain>\<our_sql_server_account>. ...00.3042.00 for
> 64-bit Copyright (C) Microsoft Corp 1984-2005.
> All rights reserved.
> Started: 9:58:00 AM
> Progress: 2007-09-10 09:58:00.59
> Source: {5D469B6D-98A4-4907-92D7-904C931892B5}
> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> 100% complete
> End Progress
> Progress: 2007-09-10 10:00:10.27
> Source: Update Statistics Task
> Executing query "use [blast_xml] ".: 12% complete
> End Progress
> Progress: 2007-09-10 10:00:10.33
> Source: Update Statistics Task
> Executing query "UPDATE STATISTICS [dbo].[tBlastOutput] WITH SAMP".: 25%
> complete
> End Progress
> Progress: 2007-09-10 10:00:10.33
> Source: Update Statistics Task
> Executing query "use [blast_xml] ".: 37% complete
> End Progress
> Progress: 2007-09-10 10:00:10.44
> Source: Update Statistics Task
> Executing query "UPDATE STATISTICS [dbo].[tBlastRun] WITH SAMPLE ".: 50%
> complete
> End Progress
> Progres... The package execution fa... The step failed.
>|||Thank you, YPD. I will keep this in mind when I return to troubleshooting
that situation.
"YPD" <y.ding@.neu.edu> wrote in message
news:286E5C59-EE3E-4263-96C1-D51E7461915A@.microsoft.com...
>I would create a text file for the log for more details, instead of just
>relying on the job history.
> You can also execute the SSIS package while in the designer window and
> watch which step fails in the debug mode.
>
> "Jim" <noreply@.noreply.com> wrote in message
> news:eEJ35X88HHA.4752@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> Can anyone, given the history below, tell me why this task fails? Or
>> could you tell me how to figure out why the task fails?
>> Thanks,
>> Jim
>> Windows Server 2003 SP2
>> Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50
>> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
>> on Windows NT 5.2 (Build 3790: Service Pack 2)
>> ---
>> Date 9/10/2007 9:58:00 AM
>> Log Job History (User Maintenance.Update Statistics)
>> Step ID 1
>> Server GENOME-GENDB
>> Job Name User Maintenance.Update Statistics
>> Step Name Update Statistics
>> Duration 00:03:00
>> Sql Severity 0
>> Sql Message ID 0
>> Operator Emailed
>> Operator Net sent
>> Operator Paged
>> Retries Attempted 0
>> Message
>> Executed as user: <our_domain>\<our_sql_server_account>. ...00.3042.00
>> for 64-bit Copyright (C) Microsoft Corp 1984-2005.
>> All rights reserved.
>> Started: 9:58:00 AM
>> Progress: 2007-09-10 09:58:00.59
>> Source: {5D469B6D-98A4-4907-92D7-904C931892B5}
>> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
>> 100% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.27
>> Source: Update Statistics Task
>> Executing query "use [blast_xml] ".: 12% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.33
>> Source: Update Statistics Task
>> Executing query "UPDATE STATISTICS [dbo].[tBlastOutput] WITH SAMP".:
>> 25% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.33
>> Source: Update Statistics Task
>> Executing query "use [blast_xml] ".: 37% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.44
>> Source: Update Statistics Task
>> Executing query "UPDATE STATISTICS [dbo].[tBlastRun] WITH SAMPLE ".:
>> 50% complete
>> End Progress
>> Progres... The package execution fa... The step failed.
>>
>