I have numerous DTS's which import data from text files - there are around
30-40 text files sources.

I have named them all with all capitals and would like to change them to all
lowercase via an update statement in msdb, rather than doing them all one by
one.

Is this possible my running an update statement in the msdb database?



Why? Well...

The reason is that in all caps, more of the connection name is shopped off
in DTS designer.

i.e.

"MYFILE_SERVER2000_SALESOUTPUT" is displayed as "MYFILE_SER..."

whereas in lowercase I can see moe of the name

"myfile_server2000_salesoutput" is displayed as "myfile_server2000_sale..."

OK

You can iterate through the Connections collection in each package, grab the
text file connections, grab their Name property and then
change it

Not dissimilar to

Function Main()

dim cn, cnTemp

for each cn in DTSGlobalVariables.Parent.Connections
if cn.ProviderID = "DTSFlatFile" then
cnTemp = cn.name
cn.name = LCase( cnTemp )
end if
Next



Main = DTSTaskExecResult_Success
End Function


--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Beema" <none (AT) supplied (DOT) com> wrote