Dim fso, file1
Dim pkg
SET pkg = DTSGlobalVariables.Parent

Set fso = CreateObject("Scripting.FileSystemObject")

IF (fso.FileExists("c:\abc.txt")) THEN
Msgbox "File exist. Continue"
pkg.Steps("DTSStep_DTSActiveScriptTask_2").DisableStep=False

Set fso= Nothing

ELSE
Msgbox "Stop"
pkg.Steps("DTSStep_DTSActiveScriptTask_2").DisableStep=True
END IF
set pkg=nothing
Main = DTSTaskExecResult_Success

no code

?>
<div class="node<?php if ($sticky) { print " sticky"; } ?><?php if (!$status) { print " node-unpublished"; } ?>">
<?php if ($picture) {print $picture;}?>
<?php if ($page == 0) { ?><h2 class="title"><a href="<?php print $node_url?>"><?php print $title?></a></h2><?php }; ?>
<div class="taxonomy"><?php if ($terms) {print "Tagged:" . $terms; }?></div>
<?php if ($links) { ?><div class="links-node"><?php print $links?></div><?php }; ?>
<br clear="all"/>
<div class="content"><?php print $content?></div>
</div>

1.Extract InfoPath form
2. Open View.xsl file
3. In the control property put xd:disableEditing="yes"
4. Save the file

SELECT
T0.ItemCode AS 'Item',
T0.ItemName AS 'Name',
CASE
WHEN T0.QryGroup37 = 'Y' THEN 'FG'
WHEN T0.QryGroup48 = 'Y' THEN 'SA'
WHEN T0.QryGroup11 = 'Y' THEN 'RAW'
END AS 'RAW-SA-FG',
T1.ItmsGrpNam AS 'Group',

CASE
WHEN T0.QryGroup55 = 'Y' THEN 'x - No Recount Need'
WHEN T0.QryGroup56 = 'Y' AND T0.QryGroup12 = 'N' THEN 'Ilya (Plastic)' /* Not CO2 */
WHEN T0.QryGroup56 = 'Y' AND T0.QryGroup12 = 'Y' THEN 'Ilya (CO2)' /* CO2 */
WHEN T0.QryGroup57 = 'Y' THEN 'Sofi (Chemical)'
WHEN T0.QryGroup58 = 'Y' THEN 'Ilya (Electronic)'
WHEN T0.QryGroup59 = 'Y' THEN 'Alex (Laboratory)'
WHEN T0.QryGroup60 = 'Y' THEN 'Shay (Salt)'
END AS 'Dept Manager',

CASE
WHEN T0.QryGroup12 = 'Y' THEN 'CO2'
WHEN T0.QryGroup13 = 'Y' THEN 'Ozonizers'
WHEN T0.QryGroup14 = 'Y' THEN 'Controllers'
WHEN T0.QryGroup15 = 'Y' THEN 'Heating'
WHEN T0.QryGroup18 = 'Y' THEN 'Berlin'
WHEN T0.QryGroup19 = 'Y' THEN 'Prizm'
WHEN T0.QryGroup20 = 'Y' THEN 'Prizm Pro'
WHEN T0.QryGroup22 = 'Y' THEN 'Merlin'
WHEN T0.QryGroup29 = 'Y' AND T0.QryGroup60 = 'Y' THEN 'Marine'
WHEN T0.QryGroup30 = 'Y' AND T0.QryGroup60 = 'Y' THEN 'Fresh'
WHEN T0.QryGroup24 = 'Y' AND T0.QryGroup57 = 'Y' THEN 'Food'
ELSE '--'
END AS 'Type',

CASE
WHEN T0.QryGroup38 = 'Y' THEN 'Labels'
WHEN T0.QryGroup39 = 'Y' THEN 'Charts'
WHEN T0.QryGroup40 = 'Y' THEN 'Bottles'
WHEN T0.QryGroup41 = 'Y' THEN 'Boxes'
WHEN T0.QryGroup42 = 'Y' THEN 'Manual'
WHEN T0.QryGroup52 = 'Y' THEN 'Packing'
WHEN T0.QryGroup54 = 'Y' THEN 'Box-Outer'
WHEN T0.QryGroup63 = 'Y' AND T0.QryGroup60 = 'Y' THEN 'Bulk Packs'
ELSE '--'
END AS 'SubType',

CAST(T0.SellItem AS VARCHAR(5)) AS 'Sale',
CAST(T0.QryGroup33 AS VARCHAR(5)) AS 'Import',
CAST(T0.TreeType AS VARCHAR(5)) AS 'Tree Type',
CAST(T0.PrchseItem AS VARCHAR(5)) AS 'Purchase'

FROM OITM T0
INNER JOIN OITB T1 ON T0.ItmsGrpCod = T1.ItmsGrpCod

WHERE T0.Canceled ='N' AND
T0.InvntItem = 'Y' AND
( T0.QryGroup58 = 'Y' AND T0.ItemName LIKE '%Zone%' )

ORDER BY T0.ItemCode

1.Extract InfoPath form
2. Open View.xsl file
3. In the control property put xd:disableEditing="yes"
4. Save the file

exec sp_attach_db @dbname = 'Portal', @filename1 ='C:\Program Files\Microsoft SQL Server\MSSQL$VISHAL\Data\Portal.mdf', @filename2 ='C:\Program Files\Microsoft SQL Server\MSSQL$VISHAL\Data\Portal_log.LDF'
go

exec sp_detach_db 'Portal'
go

SELECT * FROM sys.dm_os_cluster_nodes

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') ActiveNode

# Unpack XSN file using extract.exe utility to the local temporary directory.
# Find manifest.xsf file and open it as a plain XML file.
# Replace the corresponding URLs using the XML DOM.
# Save the modified manifest.xsf.
# Pack all files into the XSN using makecab.exe utility.
# Clean up your temporary directory.