3
MMawla
NSCTS001
10/29/2009 3:19:58 PM
5
1
-1
0
1
0
38
{B99097D6-6B37-4EE2-82EE-E1D5A127F982}
0
0
0
0
0
Local
{7890891b-f3f0-439f-9af9-c8ec3a24b5ef}
OLEDB
0
Data Source=localhost;Initial Catalog=master;Provider=SQLNCLI10;Integrated Security=SSPI;Auto Translate=false;
0
Spids
{986b5c1a-9e9d-4f84-b279-73ec328ca7d3}
FLATFILE
0
Delimited
1033
0
0
_x000D__x000A_
-1
0
<none>
1252
Delimited
_x002C_
0
0
2
0
0
-1
spid
{A5588D04-093A-41B3-841F-9729D01AAE38}
Delimited
_x002C_
0
0
2
0
0
-1
kpid
{5531902B-2548-4C62-94AD-A9CA2A5454AB}
Delimited
_x002C_
0
0
2
0
0
-1
blocked
{5E31370B-F813-4D32-B7B2-D91A5C69CB63}
Delimited
_x002C_
0
2
128
0
0
-1
waittype
{EAE6CE55-C6AF-4B36-AB22-3CE5110E3D62}
Delimited
_x002C_
0
0
20
0
0
-1
waittime
{C01D2F3D-5AA0-468A-9D38-A082D65CBA26}
Delimited
_x002C_
0
32
130
0
0
-1
lastwaittype
{A4D27AFD-3DEE-431E-B3B7-1D2DF171A2B9}
Delimited
_x002C_
0
256
130
0
0
-1
waitresource
{225A6871-3A84-409A-B421-545A951B3274}
Delimited
_x002C_
0
0
2
0
0
-1
dbid
{9DCF8291-7F64-4BDD-A09F-508425F75A70}
Delimited
_x002C_
0
0
2
0
0
-1
uid
{BF0F2BCD-0C94-4B2E-8738-D4C118FD61B7}
Delimited
_x002C_
0
0
3
0
0
-1
cpu
{20936A0E-EA20-4082-977E-F34521880B42}
Delimited
_x002C_
0
0
20
0
0
-1
physical_io
{239672A5-19E8-436E-A05B-69F37A9C2363}
Delimited
_x002C_
0
0
3
0
0
-1
memusage
{48FAED3E-1843-49F2-80F4-A7B702453FB1}
Delimited
_x002C_
0
0
135
0
0
-1
login_time
{3EEB498D-F11D-4AF6-A058-6043A0C589B4}
Delimited
_x002C_
0
0
135
0
0
-1
last_batch
{71D9C443-CB55-462E-8EA3-9FB539343D43}
Delimited
_x002C_
0
0
2
0
0
-1
ecid
{029718D1-3B19-4EB6-85C1-06BAA9DECE6C}
Delimited
_x002C_
0
0
2
0
0
-1
open_tran
{646120E9-981D-4D37-9EB0-DA33246A68C2}
Delimited
_x002C_
0
30
130
0
0
-1
status
{63F78B0B-E162-44CA-A4C6-3274C731D1A3}
Delimited
_x002C_
0
86
128
0
0
-1
sid
{C912BF9B-987E-4206-AC27-82234FB980A5}
Delimited
_x002C_
0
128
130
0
0
-1
hostname
{00D46F14-CF73-49B5-ADF1-767515BDA650}
Delimited
_x002C_
0
128
130
0
0
-1
program_name
{E1C9F956-6840-4A51-913A-27C7D04551DD}
Delimited
_x002C_
0
10
130
0
0
-1
hostprocess
{166EDA70-566C-485E-8E24-DCEA4E13FBF5}
Delimited
_x002C_
0
16
130
0
0
-1
cmd
{9B945A72-0AF9-44B8-B9D6-2826F8B02F12}
Delimited
_x002C_
0
128
130
0
0
-1
nt_domain
{847BC303-D561-4EE5-B588-E0ED815CC32E}
Delimited
_x002C_
0
128
130
0
0
-1
nt_username
{93F90FF2-D587-4880-B8D7-62561D36DE9B}
Delimited
_x002C_
0
12
130
0
0
-1
net_address
{3B2B5763-8D0A-4A29-A0C9-C5BF3AF4F1A7}
Delimited
_x002C_
0
12
130
0
0
-1
net_library
{BEB98A16-3220-4015-9E8D-40957EB05CAB}
Delimited
_x002C_
0
128
130
0
0
-1
loginame
{F1F16F7C-92B6-4684-A6EA-C0ECAEED2D5B}
Delimited
_x002C_
0
128
128
0
0
-1
context_info
{715242B5-CD9C-4B1A-B44E-D24365F3CA9A}
Delimited
_x002C_
0
20
128
0
0
-1
sql_handle
{5F90919F-6E48-449A-804F-C48E6D696129}
Delimited
_x002C_
0
0
3
0
0
-1
stmt_start
{AE048E18-6C90-4891-BD11-06A4C34EE0A0}
Delimited
_x002C_
0
0
3
0
0
-1
stmt_end
{51630B30-962E-421D-A8C8-8A19E8BC6982}
Delimited
_x000D__x000A_
0
0
3
0
0
-1
request_id
{6119F04D-6AAD-4F66-B45A-B53A159C7AE0}
D:\spids.txt
10.0.1600.22
0
0
-1
0
0
0
1
1048576
1033
1
0
0
User
0
0
6789-1
interactive_values
{22A7061F-A554-46B3-824C-E8621ADCB426}
0
User
0
0
678910
spid
{2A7ACF5A-3E75-4112-8A75-7AE36D268583}
0
1
0
0
0
-1
0
0
0
1
1048576
-1
1
0
0
1
Ask for parameters values when mode is interactive
{8EEE4D26-11A0-4F1A-9628-3A1EA372BF0D}
Script Task
Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
0
'The following GUID is for the ID of the typelib if this project is exposed to COM
' Version information for an assembly consists of the following four values:
'
' Major Version
' Minor Version
' Build Number
' Revision
'
' You can specify all the values or you can default the Build and Revision Numbers
' by using the '*' as shown below:
'
]]>
_
_
Partial Public Class ScriptMain
Inherits Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
Enum ScriptResults
Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success
Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
End Enum
Dim PackageName As String
Public Sub Main()
packageName = Dts.Variables("PackageName").Value.ToString()
If Dts.Variables("interactive_values").Value.Equals(True) Then
Dts.TaskResult = PromptForParams()
Else
Dts.TaskResult = ScriptResults.Success
End If
End Sub
Public Function PromptForParams() As ScriptResults
Dim Response As String
Dim spidint As Integer
' Default Task output to failure
Dts.TaskResult = ScriptResults.Failure
response = InputBox("Get a list of SQl server processes that begin with SPID X " & vbCrLf & vbCrLf & " Enter SQL server SPID , must be integer and > 0:", PackageName)
If response = String.Empty Then
MsgBox("Cancelled! ", MsgBoxStyle.OkOnly, PackageName)
Return ScriptResults.Failure
End If
If Integer.TryParse(Response, spidint) And spidint > 0 Then
Dts.Variables("spid").Value = spidint
Else
MsgBox("Invalid value spid , must be integer and larger than Zero ", MsgBoxStyle.Critical, PackageName)
Return ScriptResults.Failure
End If
Return ScriptResults.Success
End Function
End Class]]>
]]>
' This code was generated by a tool.
'
' Changes to this file may cause incorrect behavior and will be lost if
' the code is regenerated.
'
'------------------------------------------------------------------------------
Option Strict Off
Option Explicit On
Namespace My.Resources
'''
''' A strongly-typed resource class, for looking up localized strings, etc.
'''
'This class was auto-generated by the Strongly Typed Resource Builder
'class via a tool like ResGen or Visual Studio.NET.
'To add or remove a member, edit your .ResX file then rerun ResGen
'with the /str option, or rebuild your VS project.
Class MyResources
Private Shared _resMgr As System.Resources.ResourceManager
Private Shared _resCulture As System.Globalization.CultureInfo
Friend Sub New()
MyBase.New
End Sub
'''
''' Returns the cached ResourceManager instance used by this class.
'''
_
Public Shared ReadOnly Property ResourceManager() As System.Resources.ResourceManager
Get
If (_resMgr Is Nothing) Then
Dim temp As System.Resources.ResourceManager = New System.Resources.ResourceManager("My.Resources.MyResources", GetType(MyResources).Assembly)
_resMgr = temp
End If
Return _resMgr
End Get
End Property
'''
''' Overrides the current thread's CurrentUICulture property for all
''' resource lookups using this strongly typed resource class.
'''
_
Public Shared Property Culture() As System.Globalization.CultureInfo
Get
Return _resCulture
End Get
Set
_resCulture = value
End Set
End Property
End Class
End Namespace]]>
text/microsoft-resx
2.0
System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
]]>
' This code was generated by a tool.
'
' Changes to this file may cause incorrect behavior and will be lost if
' the code is regenerated.
'
'------------------------------------------------------------------------------
Option Strict Off
Option Explicit On
Partial Friend NotInheritable Class MySettings
Inherits System.Configuration.ApplicationSettingsBase
Private Shared m_Value As MySettings
Private Shared m_SyncObject As Object = New Object
_
Public Shared ReadOnly Property Value() As MySettings
Get
If (MySettings.m_Value Is Nothing) Then
System.Threading.Monitor.Enter(MySettings.m_SyncObject)
If (MySettings.m_Value Is Nothing) Then
Try
MySettings.m_Value = New MySettings
Finally
System.Threading.Monitor.Exit(MySettings.m_SyncObject)
End Try
End If
End If
Return MySettings.m_Value
End Get
End Property
End Class]]>
{A860303F-1F3F-4691-B57E-529FC101A107};{F184B08F-C81C-45F6-A57F-5ABD9991F28F}
Debug
AnyCPU
Library
ScriptTask_d79bff27715b418eb499aed033fd6172.vbproj
ScriptTask_d79bff27715b418eb499aed033fd6172.vbproj
On
Binary
Off
On
{2E214CCB-47BA-42A2-9841-10A4C8224FD5}
true
true
true
false
bin\
false
false
42016,42017,42018,42019,42032
false
true
false
true
bin\
false
false
42016,42017,42018,42019,42032
Code
VbMyResourcesResXFileCodeGenerator
Resources.Designer.vb
My.Resources
True
True
Resources.resx
Code
SettingsSingleFileGenerator
Settings.Designer.vb
True
Settings.settings
Code
Code
SSIS_ScriptTask
]]>TVqQAAMAAAAEAAAA//8AALgAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAgAAAAA4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1v
ZGUuDQ0KJAAAAAAAAABQRQAATAEDAJyX9EoAAAAAAAAAAOAAAiELAQgAAB4AAAAMAAAAAAAAzjwA
AAAgAAAAQAAAAABAAAAgAAAAAgAABAAAAAAAAAAEAAAAAAAAAACAAAAAAgAAAAAAAAIAQIUAABAA
ABAAAAAAEAAAEAAAAAAAABAAAAAAAAAAAAAAAIA8AABLAAAAAEAAAFAJAAAAAAAAAAAAAAAAAAAA
AAAAAGAAAAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAIAAACAAAAAAAAAAAAAAACCAAAEgAAAAAAAAAAAAAAC50ZXh0AAAA1BwAAAAgAAAAHgAAAAIA
AAAAAAAAAAAAAAAAACAAAGAucnNyYwAAAFAJAAAAQAAAAAoAAAAgAAAAAAAAAAAAAAAAAABAAABA
LnJlbG9jAAAMAAAAAGAAAAACAAAAKgAAAAAAAAAAAAAAAAAAQAAAQgAAAAAAAAAAAAAAAAAAAACw
PAAAAAAAAEgAAAACAAUAfCQAAAQYAAABAAAAAAAAAFAgAAC4AAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAALQAAADOyu++AQAAAJEAAABsU3lzdGVtLlJlc291cmNlcy5S
ZXNvdXJjZVJlYWRlciwgbXNjb3JsaWIsIFZlcnNpb249Mi4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFs
LCBQdWJsaWNLZXlUb2tlbj1iNzdhNWM1NjE5MzRlMDg5I1N5c3RlbS5SZXNvdXJjZXMuUnVudGlt
ZVJlc291cmNlU2V0AgAAAAAAAAAAAAAAUEFEUEFEULQAAAAeAigBAAAKKh4CKAQAAAoqpnMGAAAK
gAEAAARzBwAACoACAAAEcwgAAAqAAwAABHMJAAAKgAQAAAQqAAATMAEACwAAAAEAABF+AQAABG8K
AAAKKgATMAEACwAAAAIAABF+AgAABG8LAAAKKgATMAEACwAAAAMAABF+AwAABG8MAAAKKgATMAEA
CwAAAAQAABF+BAAABG8NAAAKKgATMAIADQAAAAUAABECAygRAAAKKBIAAAoqAAAAEzABAAcAAAAG
AAARAigTAAAKKgATMAEACwAAAAcAABHQBQAAAigUAAAKKgATMAEABwAAAAgAABECKBUAAAoqABMw
AQAQAAAACQAAEQKMAQAAGy0GKAEAACsqAioTMAIAEAAAAAoAABEDEgD+FQIAABsGgQIAABsqHgIo
FwAACioTMAIAKAAAAAsAABECexkAAApvGgAACgsHjAMAABstEigCAAArCwJ7GQAACgdvGwAACgcq
SgIoFwAACgJzHAAACn0ZAAAKKgAeAigXAAAKKhMwAgAtAAAADAAAEX4GAAAELSByAQAAcNAHAAAC
KBQAAApvHgAACnMfAAAKCweABgAABH4GAAAEKgAAABMwAQAGAAAADQAAEX4HAAAEKgAAHgKABwAA
BCpCcxcAAAooEQAACoAJAAAEKgAAAB4CKCAAAAoqGzABAD8AAAAOAAARfggAAAQtMn4JAAAEKBEA
AAooIQAACn4IAAAELRxzFgAABoAIAAAE3hB+CQAABCgRAAAKKCIAAArcfggAAAQqAAEMAAACAB0A
DCkAEAAAAAEeAigkAAAKKhMwAwBsAAAAAAAAAAICbyUAAApvJgAACnIzAABwbycAAApvKAAACm8V
AAAKfQoAAAQCbyUAAApvJgAACnJLAABwbycAAApvKAAACheMHgAAAW8SAAAKLBMCbyUAAAoCbxoA
AAZvKQAACisMAm8lAAAKFm8pAAAKKhMwBQCPAAAADwAAEQJvJQAAChdvKQAACnJxAABwAnsKAAAE
clIBAHAVFSgqAAAKCwd+KwAAChYoLAAAChYzFHJUAQBwFgJ7CgAABCgtAAAKJhcqBxICKC4AAAoI
Fv4CXywiAm8lAAAKbyYAAApybAEAcG8nAAAKCIwkAAABby8AAAorFXJ2AQBwHxACewoAAAQoLQAA
CiYXKhYqAEJTSkIBAAEAAAAAAAwAAAB2Mi4wLjUwNzI3AAAAAAUAbAAAAAwIAAAjfgAAeAgAANQJ
AAAjU3RyaW5ncwAAAABMEgAA7AEAACNVUwA4FAAAEAAAACNHVUlEAAAASBQAALwDAAAjQmxvYgAA
AAAAAAACAAABVx2iCQkPAAAA+gEzABYAAAEAAAAwAAAACgAAAA0AAAAaAAAABAAAADsAAAACAAAA
NQAAAA8AAAAEAAAACAAAAAkAAAAJAAAAAQAAAAYAAAABAAAAAwAAAAMAAAACAAAAAACbCQEAAAAA
AAoAeAFOAQoArAGOAQYAvAG1AQoAFAJOAQYAkgK1AQoAFAPqAgYASgM5AwYAdwNiAw4A3gPJAxIA
XQQ0BAYAmgS1AQ4AzQS3BA4A5gS3BA4AEwX7BAYAPQUqBQoAfAVVBQoAlAUTAA4AyQWsBQYA/gXe
BQYAHAa1AQYAQAa1AQoAWQYTAAYAnQZ+BgYAwwaxBgYA6gbZBgYA/QYqBRIAGgc0BBYAcwdTBxYA
iwdTBwYAnQe1AQoAtAcTAAYAyQe1AQoA1gdVBQoA7gcTAAoA+wcTAAYADgi1AQYAHQi1ARoAQAgz
CAYAlgjeBQYAtgjeBQYA1AixBgYA8Qh+BgYA/wixBgYAGgmxBgYANQmxBgYATgmxBgYAZwmxBgYA
hAmxBgAAAAABAAAAAAABAAEAAAAAACkANwAFAAEAAQAAAAAAbQA3AAkAAQACAAABEAB4ADcADQAB
AAMABQEAAIIAAAANAAUACAAFAQAAkAAAAA0ABQAPAAAAAACrALcADQAGABEAAAEQAPcAAgElAAgA
FQABAAAANQECASkACgAYAAIBAABAAQAALQALABsAMQDXASAAMQAAAi0AMQAiAjoAMQBHAkcAIQAj
A5AAEQBaA50AEQCDA6EAEQD2A78AEQD+A8MAAQB5BNkABgafBOEAVoCnBOQAVoCvBOQACCEAAAAA
BhiIARMAAQAQIQAAAAAGGIgBEwABABghAAAAABEYwwEXAAEARCEAAAAAEwjKARsAAQBcIQAAAAAT
CPABKAABAHQhAAAAABMIGQI1AAEAjCEAAAAAEwg3AkIAAQCkIQAAAABGAn0CYwABAMAhAAAAAEYC
hgJoAAIA1CEAAAAAgwCXAmwAAgDsIQAAAABGAp8CcQACAAAiAAAAABEAqAJ4AAIAHCIAAAAAAQDG
AoAAAwA4IgAAAAAGGIgBEwAEAEAiAAAAAAMI2gKLAAQAdCIAAAAABhiIARMABACIIgAAAAADGIgB
EwAEAJAiAAAAABYIjwOlAAQAzCIAAAAAFgijA6oABADgIgAAAAAWCK8DrwAEAOgiAAAAABEYwwEX
AAUA/CIAAAAABhiIARMABQAEIwAAAAAWCAsExgAFAGAjAAAAAAYYiAETAAUAaCMAAAAABgCFBBMA
BQDgIwAAAAAGAIoE3AAFAAAAAQCEAgAAAQC9AgAAAQC9AgAAAQC7AwkAiAETAGEAiAHyAHEAiAEB
AREAiAETAHkAiAETACQAiAETACwAiAETADQAiAETADwAiAETACQA2gKLACwA2gKLADQA2gKLADwA
2gKLAIEAiAETAIkAiAETAJEAiAFPAZkADQaaARkAfQJjABkAhgJoACkALganARkAnwJxAKkASga3
ARkAiAETALEAiAHHAUQAIwOQAEwACwSLAEwAdAZEAkwAiAETALkAiAFRAikAzAZcAjkAiAFhAkkA
iAETAMkA8gZ9AskA+AZ9AtEAiAETAFEAiAETAFEALAeHAtkAfQeMAuEAlAeRAukACwSXAtkApQeb
AvkAwAegAgEB0AfZAAkB4AepAvkABwiwAiEBFAi7AukAdAbCAikBiAFRAjEBiAFPATkBiAGbAkEB
iAETAEkBiAFPAVEBiAFPAVkBiAFPAWEBiAFPAWkBiAFPAXEBiAFPAXkBiAFPAYEBiAFPAQgAMADo
AAgANADtACkAgwBoAS4AywFWAi4A2wGEAy4AswFWAi4AkwEIAy4AgwFnAy4A0wFWAi4AwwGEAy4A
uwFtAy4AmwERAy4AowEwAy4AqwE9Ay4A6wBWAkAAKwDtAEAAEwD4AEMAEwD4AEMAGwAHAUkAgwBU
AWMAEwD4AGMAGwAHAWkAgwB5AYAAKwDtAIMAewDtAIMAGwAHAYMAcwDtAIkAgwCGAaAAKwDtAKMA
wwDPAaMAEwD4AMAAKwDtAMMAEwD4AMMA6wBWAskAEwB0AuAAKwDtAOkAEwB0AgABKwDtAAABEwD4
AAkBGwHtACABEwD4ACABKwDtACMBgwFWAiMBiwHOAkABKwDtAEABEwD4AGABEwD4AGABKwDtAIAB
KwDtAKABKwDtAMABKwDtAMABEwD4AOABKwDtAAACKwDtAAACEwD4ADsBQAFFAUoBnwGjAa4BswHC
AcIBSgJoAm8CggLHAgQAAQAGAAUABwAGAAgACAAAAKwBTwAAAGUCVAAAABQCWQAAAHECXgAAAC0D
mAAAAEoDtQAAAMEDugAAALsDywACAAQAAwACAAUABQACAAYABwACAAcACQACAA8ACwACABIADQAC
ABMADwABABQADwACABcAEQB1AHUAiAAfASYBLQE0ATECOAIEgAAAAQAAAAAAAAAAAAAAAAACAQAA
AgAAAAAAAAAAAAAAAQAKAAAAAAAIAAAAAAAAAAAAAAAKABMAAAAAAAIAAAAAAAAAAAAAAAEAtQEA
AAAACgAAAAAAAAAAAAAA0AAVBAAAAAAKAAAAAAAAAAAAAADQADQHAAAAAAMABQAAAAAAAAAAAAEA
MwgAAAAAAAAAAAEAAABPCAAABQAEAAYABAAKAAkAAAAQAAwAuwIAABAAGQC7AgAAAAAbALsCLQC9
AS0APwIAAAAAADxNb2R1bGU+AG1zY29ybGliAE1pY3Jvc29mdC5WaXN1YWxCYXNpYwBNeUFwcGxp
Y2F0aW9uAFNjcmlwdFRhc2tfZDc5YmZmMjc3MTViNDE4ZWI0OTlhZWQwMzNmZDYxNzIudmJwcm9q
Lk15AE15Q29tcHV0ZXIATXlQcm9qZWN0AE15V2ViU2VydmljZXMAVGhyZWFkU2FmZU9iamVjdFBy
b3ZpZGVyYDEATXlSZXNvdXJjZXMAU2NyaXB0VGFza19kNzliZmYyNzcxNWI0MThlYjQ5OWFlZDAz
M2ZkNjE3Mi52YnByb2ouTXkuUmVzb3VyY2VzAE15U2V0dGluZ3MAU2NyaXB0VGFza19kNzliZmYy
NzcxNWI0MThlYjQ5OWFlZDAzM2ZkNjE3Mi52YnByb2oAU2NyaXB0TWFpbgBTY3JpcHRSZXN1bHRz
AE1pY3Jvc29mdC5WaXN1YWxCYXNpYy5BcHBsaWNhdGlvblNlcnZpY2VzAEFwcGxpY2F0aW9uQmFz
ZQAuY3RvcgBNaWNyb3NvZnQuVmlzdWFsQmFzaWMuRGV2aWNlcwBDb21wdXRlcgBTeXN0ZW0AT2Jq
ZWN0AC5jY3RvcgBnZXRfQ29tcHV0ZXIAbV9Db21wdXRlck9iamVjdFByb3ZpZGVyAGdldF9BcHBs
aWNhdGlvbgBtX0FwcE9iamVjdFByb3ZpZGVyAFVzZXIAZ2V0X1VzZXIAbV9Vc2VyT2JqZWN0UHJv
dmlkZXIAZ2V0X1dlYlNlcnZpY2VzAG1fTXlXZWJTZXJ2aWNlc09iamVjdFByb3ZpZGVyAEFwcGxp
Y2F0aW9uAFdlYlNlcnZpY2VzAEVxdWFscwBvAEdldEhhc2hDb2RlAFR5cGUAR2V0VHlwZQBUb1N0
cmluZwBDcmVhdGVfX0luc3RhbmNlX18AVABpbnN0YW5jZQBEaXNwb3NlX19JbnN0YW5jZV9fAGdl
dF9HZXRJbnN0YW5jZQBNaWNyb3NvZnQuVmlzdWFsQmFzaWMuTXlTZXJ2aWNlcy5JbnRlcm5hbABD
b250ZXh0VmFsdWVgMQBtX0NvbnRleHQAR2V0SW5zdGFuY2UAU3lzdGVtLlJlc291cmNlcwBSZXNv
dXJjZU1hbmFnZXIAX3Jlc01ncgBTeXN0ZW0uR2xvYmFsaXphdGlvbgBDdWx0dXJlSW5mbwBfcmVz
Q3VsdHVyZQBnZXRfUmVzb3VyY2VNYW5hZ2VyAGdldF9DdWx0dXJlAHNldF9DdWx0dXJlAFZhbHVl
AEN1bHR1cmUAU3lzdGVtLkNvbmZpZ3VyYXRpb24AQXBwbGljYXRpb25TZXR0aW5nc0Jhc2UAbV9W
YWx1ZQBtX1N5bmNPYmplY3QAZ2V0X1ZhbHVlAE1pY3Jvc29mdC5TcWxTZXJ2ZXIuU2NyaXB0VGFz
awBNaWNyb3NvZnQuU3FsU2VydmVyLkR0cy5UYXNrcy5TY3JpcHRUYXNrAFZTVEFSVFNjcmlwdE9i
amVjdE1vZGVsQmFzZQBQYWNrYWdlTmFtZQBNYWluAFByb21wdEZvclBhcmFtcwBFbnVtAHZhbHVl
X18AU3VjY2VzcwBGYWlsdXJlAFN5c3RlbS5Db21wb25lbnRNb2RlbABFZGl0b3JCcm93c2FibGVB
dHRyaWJ1dGUARWRpdG9yQnJvd3NhYmxlU3RhdGUAU3lzdGVtLkNvZGVEb20uQ29tcGlsZXIAR2Vu
ZXJhdGVkQ29kZUF0dHJpYnV0ZQBTeXN0ZW0uRGlhZ25vc3RpY3MARGVidWdnZXJIaWRkZW5BdHRy
aWJ1dGUATWljcm9zb2Z0LlZpc3VhbEJhc2ljLkNvbXBpbGVyU2VydmljZXMAU3RhbmRhcmRNb2R1
bGVBdHRyaWJ1dGUASGlkZU1vZHVsZU5hbWVBdHRyaWJ1dGUAU3lzdGVtLkNvbXBvbmVudE1vZGVs
LkRlc2lnbgBIZWxwS2V5d29yZEF0dHJpYnV0ZQBTeXN0ZW0uUnVudGltZS5Db21waWxlclNlcnZp
Y2VzAFJ1bnRpbWVIZWxwZXJzAEdldE9iamVjdFZhbHVlAFJ1bnRpbWVUeXBlSGFuZGxlAEdldFR5
cGVGcm9tSGFuZGxlAEFjdGl2YXRvcgBDcmVhdGVJbnN0YW5jZQBNeUdyb3VwQ29sbGVjdGlvbkF0
dHJpYnV0ZQBzZXRfVmFsdWUAU3lzdGVtLlJ1bnRpbWUuSW50ZXJvcFNlcnZpY2VzAENvbVZpc2li
bGVBdHRyaWJ1dGUAU3lzdGVtLlJlZmxlY3Rpb24AQXNzZW1ibHkAZ2V0X0Fzc2VtYmx5AFN5c3Rl
bS5UaHJlYWRpbmcATW9uaXRvcgBFbnRlcgBFeGl0AERlYnVnZ2VyTm9uVXNlckNvZGVBdHRyaWJ1
dGUAU2NyaXB0T2JqZWN0TW9kZWwAZ2V0X0R0cwBNaWNyb3NvZnQuU3FsU2VydmVyLk1hbmFnZWRE
VFMATWljcm9zb2Z0LlNxbFNlcnZlci5EdHMuUnVudGltZQBWYXJpYWJsZXMAZ2V0X1ZhcmlhYmxl
cwBWYXJpYWJsZQBnZXRfSXRlbQBCb29sZWFuAHNldF9UYXNrUmVzdWx0AEludGVyYWN0aW9uAElu
cHV0Qm94AFN0cmluZwBFbXB0eQBPcGVyYXRvcnMAQ29tcGFyZVN0cmluZwBNc2dCb3hSZXN1bHQA
TXNnQm94U3R5bGUATXNnQm94AEludDMyAFRyeVBhcnNlAENMU0NvbXBsaWFudEF0dHJpYnV0ZQBT
eXN0ZW0uQWRkSW4AQWRkSW5BdHRyaWJ1dGUAU2NyaXB0VGFza19kNzliZmYyNzcxNWI0MThlYjQ5
OWFlZDAzM2ZkNjE3Mi52YnByb2ouUmVzb3VyY2VzLnJlc291cmNlcwBDb21waWxhdGlvblJlbGF4
YXRpb25zQXR0cmlidXRlAFJ1bnRpbWVDb21wYXRpYmlsaXR5QXR0cmlidXRlAEFzc2VtYmx5Rmls
ZVZlcnNpb25BdHRyaWJ1dGUAR3VpZEF0dHJpYnV0ZQBBc3NlbWJseVRyYWRlbWFya0F0dHJpYnV0
ZQBBc3NlbWJseUNvcHlyaWdodEF0dHJpYnV0ZQBBc3NlbWJseVByb2R1Y3RBdHRyaWJ1dGUAQXNz
ZW1ibHlDb21wYW55QXR0cmlidXRlAEFzc2VtYmx5RGVzY3JpcHRpb25BdHRyaWJ1dGUAQXNzZW1i
bHlUaXRsZUF0dHJpYnV0ZQBTY3JpcHRUYXNrX2Q3OWJmZjI3NzE1YjQxOGViNDk5YWVkMDMzZmQ2
MTcyLnZicHJvai5kbGwAAAAAMU0AeQAuAFIAZQBzAG8AdQByAGMAZQBzAC4ATQB5AFIAZQBzAG8A
dQByAGMAZQBzAAAXUABhAGMAawBhAGcAZQBOAGEAbQBlAAAlaQBuAHQAZQByAGEAYwB0AGkAdgBl
AF8AdgBhAGwAdQBlAHMAAIDfRwBlAHQAIABhACAAbABpAHMAdAAgAG8AZgAgAFMAUQBsACAAcwBl
AHIAdgBlAHIAIABwAHIAbwBjAGUAcwBzAGUAcwAgAHQAaABhAHQAIABiAGUAZwBpAG4AIAB3AGkA
dABoACAAUwBQAEkARAAgAFgAIAANAAoADQAKACAARQBuAHQAZQByACAAUwBRAEwAIABzAGUAcgB2
AGUAcgAgAFMAUABJAEQAIAAsACAAbQB1AHMAdAAgAGIAZQAgAGkAbgB0AGUAZwBlAHIAIABhAG4A
ZAAgAD4AIAAwADoAAAEAF0MAYQBuAGMAZQBsAGwAZQBkACEAIAAACXMAcABpAGQAAHVJAG4AdgBh
AGwAaQBkACAAdgBhAGwAdQBlACAAcwBwAGkAZAAgACwAIABtAHUAcwB0ACAAYgBlACAAaQBuAHQA
ZQBnAGUAcgAgAGEAbgBkACAAbABhAHIAZwBlAHIAIAB0AGgAYQBuACAAWgBlAHIAbwAgAACJnun0
Gq1ITJP/tlPdlJWHAAi3elxWGTTgiQiwP19/EdUKOgMgAAEDAAABBAAAEgwHBhUSGAESDAQAABII
BwYVEhgBEggEAAASEQcGFRIYARIRBAAAEhQHBhUSGAESFAQIABIMBAgAEggECAASEQQIABIUBCAB
AhwDIAAIBCAAEhUDIAAOAh4ABxABAR4AHgAHMAEBARAeAAITAAQgABMABwYVEhkBEwAEKAATAAMG
Eh0DBhIhBAAAEh0EAAASIQUAAQESIQQIABIdBAgAEiEDBhIgAgYcBAAAEiAECAASIAiJhF3NgIDM
kQIGDgQgABEoAgYIAwYRKAQAAAAABAEAAAAFIAEBETUIAQABAAAAAAAFIAIBDg4XAQAKTXlUZW1w
bGF0ZQc4LjAuMC4wAAAGFRIYARIMBhUSGAESCAYVEhgBEhEGFRIYARIUBAcBEgwEBwESCAQHARIR
BAcBEhQEIAEBDhMBAA5NeS5BcHBsaWNhdGlvbgAAEAEAC015LkNvbXB1dGVyAAAMAQAHTXkuVXNl
cgAAEwEADk15LldlYlNlcnZpY2VzAAAEAAEcHAMHAQIDBwEIBgABEhURUQQHARIVAwcBDgUQAQAe
AAQKAR4ABAcBHgAHIAQBDg4ODmEBADRTeXN0ZW0uV2ViLlNlcnZpY2VzLlByb3RvY29scy5Tb2Fw
SHR0cENsaWVudFByb3RvY29sEkNyZWF0ZV9fSW5zdGFuY2VfXxNEaXNwb3NlX19JbnN0YW5jZV9f
AAAABhUSGAETAAYVEhkBEwAECgETAAUgAQETAAYHAhMAEwAEIAEBAgUBAAAAAAQgABJhBiACAQ4S
YQYHAhIdEh0EBwESIQgBAAIAAAAAAAQAAQEcBAcBEiAEIAASbQQgABJxBSABEnUcAyAAHAQgAQEI
CAAFDg4ODggIBgADCA4OAgoAAxGAiRwRgI0cBgACAg4QCAQgAQEcBgcDESgOCDkBAApTY3JpcHRN
YWluAwBUDgdWZXJzaW9uAzEuMFQOCVB1Ymxpc2hlcgBUDgtEZXNjcmlwdGlvbgAIAQAIAAAAAAAe
AQABAFQCFldyYXBOb25FeGNlcHRpb25UaHJvd3MBDAEABzEuMC4wLjAAACkBACRiYmM0ODJlNC1j
YTI2LTQ4MDMtOTQ3Yi03MzE3ZTZiYTg5MDcAAAUBAAEAABYBABFDb3B5cmlnaHQgQCAgMjAwOQAA
NwEAMlNjcmlwdFRhc2tfZDc5YmZmMjc3MTViNDE4ZWI0OTlhZWQwMzNmZDYxNzIudmJwcm9qAACo
PAAAAAAAAAAAAAC+PAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAsDwAAAAAAAAAAF9Db3JEbGxN
YWluAG1zY29yZWUuZGxsAAAAAAD/JQAgQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMA
AwAAACgAAIAOAAAASAAAgBAAAABgAACAAAAAAAAAAAAAAAAAAAACAAIAAAB4AACAAwAAAJAAAIAA
AAAAAAAAAAAAAAAAAAEAAH8AAKgAAIAAAAAAAAAAAAAAAAAAAAEAAQAAAMAAAIAAAAAAAAAAAAAA
AAAAAAEAAAAAANgAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAOgAAAAAAAAAAAAAAAAAAAAAAAEAAAAA
APgAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAgBAAAYRQAA6AIAAAAAAAAAAAAAAEgAACgBAAAAAAAA
AAAAAChJAAAiAAAAAAAAAAAAAAAYQQAAAAQAAAAAAAAAAAAAAAQ0AAAAVgBTAF8AVgBFAFIAUwBJ
AE8ATgBfAEkATgBGAE8AAAAAAL0E7/4AAAEAAAABAAAAAAAAAAEAAAAAAD8AAAAAAAAABAAAAAIA
AAAAAAAAAAAAAAAAAABEAAAAAQBWAGEAcgBGAGkAbABlAEkAbgBmAG8AAAAAACQABAAAAFQAcgBh
AG4AcwBsAGEAdABpAG8AbgAAAAAAAACwBGADAAABAFMAdAByAGkAbgBnAEYAaQBsAGUASQBuAGYA
bwAAADwDAAABADAAMAAwADAAMAA0AGIAMAAAAJAAMwABAEYAaQBsAGUARABlAHMAYwByAGkAcAB0
AGkAbwBuAAAAAABTAGMAcgBpAHAAdABUAGEAcwBrAF8AZAA3ADkAYgBmAGYAMgA3ADcAMQA1AGIA
NAAxADgAZQBiADQAOQA5AGEAZQBkADAAMwAzAGYAZAA2ADEANwAyAC4AdgBiAHAAcgBvAGoAAAAA
ADAACAABAEYAaQBsAGUAVgBlAHIAcwBpAG8AbgAAAAAAMQAuADAALgAwAC4AMAAAAJAANwABAEkA
bgB0AGUAcgBuAGEAbABOAGEAbQBlAAAAUwBjAHIAaQBwAHQAVABhAHMAawBfAGQANwA5AGIAZgBm
ADIANwA3ADEANQBiADQAMQA4AGUAYgA0ADkAOQBhAGUAZAAwADMAMwBmAGQANgAxADcAMgAuAHYA
YgBwAHIAbwBqAC4AZABsAGwAAAAAAEgAEgABAEwAZQBnAGEAbABDAG8AcAB5AHIAaQBnAGgAdAAA
AEMAbwBwAHkAcgBpAGcAaAB0ACAAQAAgACAAMgAwADAAOQAAAJgANwABAE8AcgBpAGcAaQBuAGEA
bABGAGkAbABlAG4AYQBtAGUAAABTAGMAcgBpAHAAdABUAGEAcwBrAF8AZAA3ADkAYgBmAGYAMgA3
ADcAMQA1AGIANAAxADgAZQBiADQAOQA5AGEAZQBkADAAMwAzAGYAZAA2ADEANwAyAC4AdgBiAHAA
cgBvAGoALgBkAGwAbAAAAAAAiAAzAAEAUAByAG8AZAB1AGMAdABOAGEAbQBlAAAAAABTAGMAcgBp
AHAAdABUAGEAcwBrAF8AZAA3ADkAYgBmAGYAMgA3ADcAMQA1AGIANAAxADgAZQBiADQAOQA5AGEA
ZQBkADAAMwAzAGYAZAA2ADEANwAyAC4AdgBiAHAAcgBvAGoAAAAAADQACAABAFAAcgBvAGQAdQBj
AHQAVgBlAHIAcwBpAG8AbgAAADEALgAwAC4AMAAuADAAAAA4AAgAAQBBAHMAcwBlAG0AYgBsAHkA
IABWAGUAcgBzAGkAbwBuAAAAMQAuADAALgAwAC4AMAAAACgAAAAgAAAAQAAAAAEABAAAAAAAgAIA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAACAAAAAgIAAgAAAAIAAgACAgAAAgICAAMDAwAAAAP8A
AP8AAAD//wD/AAAA/wD/AP//AAD///8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB3d3d3d3d3d3d3d3d3d3AERERERERERERE
RERERERwBP/////////////////0cAT/////////////////9HAE//////////////////RwBP//
///////////////0cAT/////////////////9HAE//////////////////RwBP//////////////
///0cAT/////////////////9HAE//////////////////RwBP/////////////////0cAT/////
////////////9HAE//////////////////RwBP/////////////////0cAT/////////////////
9HAE//////////////////RwBP/////////////////0cAT/////////////////9HAE////////
//////////RwBIiIiIiIiIiIiIiIiIiEcARERERERERERERERERERHAETExMTExMTExMTs7OSXRw
BMzMzMzMzMzMzMzMzMzEAABEREREREREREREREREQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD/////////////////////wAAAAYAAAAGAAAABgAAAAYAA
AAGAAAABgAAAAYAAAAGAAAABgAAAAYAAAAGAAAABgAAAAYAAAAGAAAABgAAAAYAAAAGAAAABgAAA
AYAAAAGAAAABgAAAAYAAAAGAAAADwAAAB////////////////ygAAAAQAAAAIAAAAAEABAAAAAAA
wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAACAAAAAgIAAgAAAAIAAgACAgAAAgICAAMDAwAAA
AP8AAP8AAAD//wD/AAAA/wD/AP//AAD///8AAAAAAAAAAAAHd3d3d3d3d0RERERERERHT///////
+EdP///////4R0////////hHT///////+EdP///////4R0////////hHT///////+EdP///////4
R0iIiIiIiIhHTMzMzMzMzEfEREREREREwAAAAAAAAAAAAAAAAAAAAAD//wAAgAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAP//AAD//wAAAAABAAIAICAQ
AAEABADoAgAAAgAQEBAAAQAEACgBAAADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADAAAAwAAADQPAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=
0
Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1
0
0
-1
0
0
0
1
1048576
-1
1
0
0
1
Dump Processes list to a Flat file
{12061b8c-c450-4873-a556-1349964e01b5}
Data Flow Task
SSIS.Pipeline.2
0
true
0
select
spid,kpid,blocked,waittype,waittime,rtrim(lastwaittype)lastwaittype,rtrim(waitresource) waitresource,db_name(dbid) dbname,uid,cpu,physical_io,memusage,login_time,last_batch,ecid,open_tran,rtrim(status) status,rtrim(hostname) hostname,rtrim(program_name)program_name,hostprocess,rtrim(cmd) cmd,rtrim(nt_domain)nt_domain,rtrim(nt_username)nt_username,
rtrim(net_address)net_address,rtrim(loginame)loginame,stmt_start,stmt_end,request_id
from master.sys.sysprocesses where spid >= ?
1252
false
2
"Spid",{2A7ACF5A-3E75-4112-8A75-7AE36D268583};
0
2
-1
Constraint
{CE894C81-343D-41F1-8D7A-41953C3D7ED2}
Interactive_Variables_value_2008
{84774989-5C52-4AF9-887E-3D1DA7240F8B}
SSIS.Package.2
0
<TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsDataFlowDiagram><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="17" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-5011" scrolltop="523" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="29051" y="7461" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
<font>
<ddsxmlobjectstreamwrapper binary="01000000900144420100065461686f6d61" />
</font>
<mouseicon><ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager><ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Flat File Destination" left="-2569" top="3675" logicalid="7" controlid="7" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"><control><ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" />
</control>
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{12061b8c-c450-4873-a556-1349964e01b5}/components/359" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method ca..." left="-1630" top="1523" logicalid="8" controlid="8" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"><control><ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" />
</control>
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{12061b8c-c450-4873-a556-1349964e01b5}/components/428" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-1169" top="2288" logicalid="9" controlid="9" masterid="0" hint1="0" hint2="0" width="1738" height="1887" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"><control><ddsxmlobj><polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1"><adornment percentpos="50" controlid="10" width="423" height="423" side="1" behavior="2" himetric="963" distfromline="175" startobj="0" x="-125" y="3356" visible="1" allowoverlap="1" usepercent="1" />
</polyline>
</ddsxmlobj>
</control>
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{12061b8c-c450-4873-a556-1349964e01b5}/paths/539" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector sourceid="8" destid="7" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="169" y="2687" />
<point x="169" y="3181" />
<point x="-770" y="3181" />
<point x="-770" y="3675" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" left="-125" top="3356" logicalid="10" controlid="10" masterid="9" hint1="0" hint2="0" width="423" height="423" noresize="1" nomove="1" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="0" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"><control><ddsxmlobjectstreaminitwrapper binary="00080000a7010000a7010000" />
</control>
<layoutobject><ddsxmlobj><property name="VisualizerAdornment" value="-1" vartype="11" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortLeft>-5011</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>523</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">428 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>
dts-designer-1.0
{12061b8c-c450-4873-a556-1349964e01b5}
{83ACB69B-4B32-4728-B615-C0D44034F005}
<PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>Flat File Destination Input</dwd:DestinationName></PipelinePath>
dts-designer-1.0
{12061b8c-c450-4873-a556-1349964e01b5}-539
{50E6A449-D9BE-4DD0-8FB8-F329C93E467C}
<Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>894</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="10" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="13864" y="13414" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
<font>
<ddsxmlobjectstreamwrapper binary="01000000900144420100144d6963726f736f66742053616e73205365726966" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Script Task" left="1879" top="894" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="4843" height="1535" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000eb120000ff050000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{8EEE4D26-11A0-4F1A-9628-3A1EA372BF0D}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Data Flow Task" left="2220" top="3493" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="4392" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000281100008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{12061b8c-c450-4873-a556-1349964e01b5}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="3901" top="2030" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="915" height="1963" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobj>
<polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{CE894C81-343D-41F1-8D7A-41953C3D7ED2}" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="1" destid="2" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="4300" y="2429" />
<point x="4300" y="2961" />
<point x="4416" y="2961" />
<point x="4416" y="3493" />
</connector>
</ddscontrol>
</dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package>
dts-designer-1.0
{84774989-5C52-4AF9-887E-3D1DA7240F8B}
{0796CAFB-242E-4485-A879-16613079ADF2}
<PrecedenceConstraint xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint>
dts-designer-1.0
{CE894C81-343D-41F1-8D7A-41953C3D7ED2}
{DE797204-E94B-4F2F-81E6-D3C9D5D67317}
<Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>894</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="10" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="13864" y="13414" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
<font>
<ddsxmlobjectstreamwrapper binary="01000000900144420100144d6963726f736f66742053616e73205365726966" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Script Task" left="1879" top="894" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="4843" height="1535" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000eb120000ff050000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{8EEE4D26-11A0-4F1A-9628-3A1EA372BF0D}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Data Flow Task" left="2220" top="3493" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="4392" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000281100008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{12061b8c-c450-4873-a556-1349964e01b5}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="3901" top="2030" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="915" height="1963" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobj>
<polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{CE894C81-343D-41F1-8D7A-41953C3D7ED2}" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="1" destid="2" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="4300" y="2429" />
<point x="4300" y="2961" />
<point x="4416" y="2961" />
<point x="4416" y="3493" />
</connector>
</ddscontrol>
</dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package>
dts-designer-1.0
package-diagram
{9FB3A214-4FC5-4D42-A58D-900D660A600C}