The flatfile manager may need to be changed,

go into the advanced settings and select the column that is casuing the issues. set the length of this column to the...

Pretty much what Jack said, a product like Informatica can cost tens of thousands of dollars wheras SSIS is free with sql 2005.

I was an Informatica developer for years...

Yes the best advice would be to not run this code at all, esp. on a production box

check out this excellent article on db shrinking and the problems it can...

1. Shrink

2. Re-Index

Shrinking causes fragmentation in the data/indexes. so you need to re-index after shrinking.

In the data conversion properties,

Select the input column, give this coulmn an output alias.

Select the data-type (eg. string [DT_STR])

Set the Length to the same length as in your...

run a server-side trace on your sql server, make sure you aply appropriate filters to help you isolate what the potential issues could be.

Have a look at the...

Add a dataconversion transofrmation into your data-flow and use this to truncate your column before you insert the data into the destination table.

It depends on what sort of validations are needed.

For data type and sizes, use the data conversion transformation and you can re-deirect the error rows that do not conform...

Okay thanks, that is pretty much the exact opposite from what you described in your first post, where you wrote that you need to export Excel --> Sql server.

For...

You should then ask the client if they can use another method to identify the primary keys, such as a suffix / prefix (PK_) as this will make...

It makess the code hard to maintain and read if you it include references to objects that no longer exsit so I would comment out or delete the...

you can use the color property of Font to work out what the font colour of the cell is. You can loop through the worksheet and then change the...

So are you saying that the only way to identify the primary key is by the colour of the text in excel?

this will not be possible with the standard...

it is used in SQL 2005 to only install the features of SQL server that are needed, this reduces the risk of a security threat,

http://msdn.microsoft.com/en-us/library/ms161956.aspx

with sql 2005 you can use try catch blocks for error handling, and then pass the error number and message back to the developer.

http://msdn.microsoft.com/en-us/library/ms175976.aspx