Bet not Remi

Like the solution though

But aren't you teaching bad habits, using system tables, tut tut...

What account is SQL Server service running under, if it is Local System then it will not be able to access the network, see the following from BOL

When xp_cmdshell is...

You need to include the single quotes for the tablename data in the insert like this

EXEC ('Insert dbo.MgtTable_Records (Table_Name ,No_Records)

 Select ''' + @tablename + ''',Count(*) As Counter From ' + @tablename...

If you check Stewart's 2nd post he defines the format of imported column as yyyymmddhhmm or (yyyyddmmhhmm)   and therefore ISDATE will not work as...

In general I would agree with the xxx domain but agree with jay about some content may not wish to be there.

If this is to be voluntary then it would...

Ok I'll try (and wait for the fallout )

SELECT CAST(SUBSTRING(CardExpDate,1,2) as int) AS [CCExpMonth],

CAST(CASE WHEN SUBSTRING(CardExpDate,5,2) > '50'

THEN STUFF(SUBSTRING(CardExpDate,3,4),1,2,'19')

ELSE SUBSTRING(CardExpDate,3,4)

END...

But the question stated SQL Server 2005

if DTSSource("Col009") = null then

    DTSDestination("Col009") = null

elseif Trim(DTSSource("Col009")) = "" Then

    DTSDestination("Col009") = null

else

    DTSDestination("Col009") = mid(DTSSource("Col009"),1,4) & "/" & mid(DTSSource("Col009"),5,2) & "/" & mid(DTSSource("Col009"),7,2) & " " &...

OK assuming by your first post that

1. You do not know how many columns are in the table

2. The numbers in the column names are not consecutive

3. ID is always...