Have you checked the SQL errorlog and the Windows evenlog for error messages?

John

What is the data type of the column you're importing the data in to?

John

Mmmm... that doesn't explain why the second and third rows...

Are you running the package interactively (through BIDS)? Are there any Warning messages on the Progress page?

John

Unrestricted file growth will depend on whether your database shares the disk with other databases that may also want to grow. If it does, then it's wise to set...

What is the relationship between the data in table1, table2 and table3? You can't just put some columns from one table and some from another in the same row...

Yes, that's right. But of course once it's consumed or reduced, it's closer to 0% than to 40 or 99.

John

Free space isn't relevant since autogrow is what happens when the free space runs out. It doesn't force any space to be used. 1% is probably rather low,...

Probably best to monitor file size proactively but set autogrowth just in case. The fragmentation levels I've seen used most often are to reorganise indexes above 5% and rebuild...

Because it can cause the value of DATEFIRST to be different, which is what your CASE expresssion relies on.

Have a read...

I would guess this is caused by a difference in the local settings for each user - you and the user that connections to the linked server are made as....

Yes, maintenance plans will do that for you. You don't have any control, as far as I know, over the actual name of the file, but you'll get each...

Oops! Double post.

I'm sure you've already typed "protect database backup with password" into your favourite search engine, and that you noticed that the top result was Microsoft's MSDN page Security Considerations for...

If you change to int, what's to stop invalid dates such as 13132011 getting into your data? Also, if you index on integers like that, you're not going to...