Thanks Dinesh for the quick response.

Hi Dinesh This ssis package is related to the excel file what we discussed last time.I have store the dtx package & the excel files used for this package are, stored in a MAP Drive. I scheduled this package to run under ''sa'' account. also I have added the package as file system. So if possible, can you just send me ...

I created ssis pakage & save it as a dtsx package in my local drive. so when I execute it from the local drive , it works successfully. but I need to schedule this as a job in the management studio. But when i run the scheduled job, I get the following error. ''the job failed. the job was invoked by the ...

Hi Guys,I came across this issue while trying to change the data type of output column in a Script Component.If I click on it, the window goes off without letting me to change or see anything. Has anyone know the reason for this?I found the thread at www.sqlservercentral.com about this issue but given answer is not valid in my case. Still looking ...

See this http://www.databasejournal.com/features/mssql/article.php/3503996

This is the SSIS presentation that is done on 04/07/2007 at Microsoft Sri Lanka.