After a closer look, i see that the month is not working as expected. It's behaving like the week of year. So they both behave consistently, but not the way...

A Table-Valued function would be much more efficient than a scalar function. I agree we need a bit more information on how your tables are related.

should be pretty straight forward if you are not changing from 2005 to 2008. I usually create a blank database (no tables or anything). Then right click it and follow...

To the best of my knowledge, a 2008 SSIS package can not be run on a 2005 instance of SSIS. I'm assuming the problem is you can't open them back...

I don't think you need to be a DBA to be a good developer. I have been developing for 3+ years and certainly don't understand all the minute details under...

I recently passed two SQL 2008 certs for Business Intellgence, and Database Development. For both exams I read the Exam Tookit books from Microsoft press and purchased practice test from...

I also read this book in it's entirety. It doesn't cover every single detail, but enough to pass the exam. If you are putting in some serious time, i think...

Great! Glad I could be of some help.

shot in the dark, but have you checked permissions? Whatever name the package is running under will need bulk insert permission.

and SSC = SQL Server Central...it's kinda his level based on his input.

well, SSIS is a great way to setup a process that needs to be run repeatedly, but is definitely more work and a bit overkill for this. But like...

so you have a spreadsheet that has some column that need to be updated in the database table. and one of the columns in the spreadsheet provides a unique match...

I'm a little bored, so I put together a quick excel UDF in VBA that would do what you need.

This was done quickly, so there is probably a better way...

I don't think there is an easy way to do this. I believe you'd have to write a user defined function in Excel to make a connection to the database...

Agreed. IMEX=1 solved a very similar problem I had. This only seems to be an issue with the excel data source. Give it a try and let us know.