I notice you...

If you put all your actions in one procedure with if statements you also eliminate the benefit of having a cached execution plan.

Can you post some source data so I can run the query myself and create a report to see how it works?

I'd create an archive folder and then use a foreach loop using the for each file enumerator. Process the file and then move it to the archive folder using...

How'd you map the variable to the parameter? Please post exactly.

Here you go:

Set @filedate = Replace(Convert(varchar(10), getdate(), 101), '/', '') +

Replace(Convert(varchar(6), getdate(), 114), ':', '')

The first convert gets MMDDYYYY and the second gets HHMM

Okay the premise remains the same, you'll just need to parse the file nam eto get the extension to use the right data flow task.

Did you use "drive:\folder" in the linked server? If you did you probably want to share the folder and use a UNC path (\\server\share).

Do you have a known number of file extensions or is it random? Are the files all in the same folder?

Here's one way if there is a known number...

I'm just grasping at straws. Odds are the only solution is to run DBCC CHECKTABLE() with REPAIR_ALLOW_DATA_LOSS or restoring from a good backup. It just seems odd to...

How about running an update against that column setting the value correctly. I know it's okay now, but running the update can't hurt.

You need the indid in the query as well.

I would still restore a backup to a test server and drop and recreate the clustered index to see if that cleans...

What do you get when you run:

Select * from sysindexes where object_id = Object_Id("table name")

If there is a clustered index on the table then DBCC CheckTable should not return an error for indexid 0, so I don't think there is a clustered index on...

I'm guessing you are migrating from the DTS world to SSIS. Let me assure you that you will like SSIS better. There are some annoyances, but it is,...