there is data in the column that will not convert to datetime as it is not a valid date

do as Kingston suggested and find out what the bad data is...

First of all you will need a way to work out the filename based on the day of the week and then assign this name to a variable. You...

If this is very urgent then you should provide some more information to help people help you.

Such as what exacltly do you mean by 'it does not work on the...

you can , as long as the files are the same format.

you need to add an expression to the file connection manager and make the connection string property dynamic.

have you looked at the SQL Server 2005 Setup Log Files?

there will be an entry in there with a description of the error

Also with 2008 you can now use C# as a scripting language, I found this better as C# is a lot more in demand as a skill.

You should really only rebuild indexes based upon fragmentation usually >30% is a rebuild and below 30 is a regorganise, its a waste of resources to rebuild every index....

are you rebulding all your indexes , or do you have logic put in place to rebuild based on fragmentation?

I would say that using profiler would not be the best idea as you should be able to get this information from the default trace

Ed Zann (10/15/2010)

---

That is not related to the structure of the file; it is related to how your windows client is set up. Excel is set as the default...

Excel wont auto-magically parse a .dat file, it will a .csv file becasue it knows about them. .Dat can have anything in it really so it would be...

beacuse if you don't know the difference you shouldn't be at...

well if we are trading war stories,

the last guy we interviewed we asked him how he would modify a query with a join to return all the...

are those columns in the data preview?

I have found similar, quite often 7 years experience = 7 x 1 year worth of experience.

But there a lot of excellent DBAs out there, its just a...