Even after I moved Microsoft.Office.Interop.Excel.dll file to GAC (C:\Windows\Assembly) folder, I'm still not able add it as a reference to my script task. Do I need to reboot the server?

LocaleID property will let you handle such kind of conversions.

On the source flat file connection manager properties set localeid to English (United Kingdom).

Use data conversion transforormation task to...

I think you should check if metadata of both external columns and output columns is same or not on excel source.

Use OLE DB Command Task to issue updates against your table in Data Flow task.

For more info look into

http://technet.microsoft.com/en-us/library/ms141138.aspx

http://www.sqlis.com/post/OLE-DB-Command-Transformation.aspx

Check this link -

http://decipherinfosys.wordpress.com/2008/09/16/deploying-ssis-packages-in-sql-server-2005/

SSIS packages are in msdb.dbo.sysdtspackages90

For details go to http://msdn.microsoft.com/en-us/library/ms181701(SQL.90).aspx

To launch Import/Export Wizard - Go to Start > Run > dtswizard

Check this link:

http://www.sqlis.com/55.aspx

Try Setting "Retain Same Connection" to true for connection properties in connection manager.

You can use row count component, to store row counts in a variable.

what is the operation you are trying to perform after you get row counts?.

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/upgradingsqlserver2000dtspackagestossis/2201/

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032285811&CountryCode=US

Do you have any Oracle sources?. Are you going to deploy SSIS on a 32-bit or 64 bit?. Tell us more about your environment,...

To obtain only date part using script component use code below -

Row.Fieldname = Row.Fieldname.Date

I think you should use Data Conversion transformation

For Row count component you don't have to check any input columns. To obtain row count, just include variable name.

Valek,

In your case create two variables 1)SqlStatement (string)

2)Schema (string).

For SqlStatement variable - in the properties - change "evaluate as an expression" to true and assign expression as

"SELECT * FROM...

I think you would like to implement checkpoints in your package.

check for "checkpoints" in control flow properties window.

For more