I deleted script and recoded, still the error exists. I can follow your suggestion but it was working before. I have loaded data in to tables using this script. I...

Thank you for the reply. I have the following code:

Row.vchImportCustomerPhoneNumber = nonumbers.Replace(phone, String.Empty)

Error says 'disallow implicit conversion of string to integer'.

So, I am trying to change the data type...

If it is not a bulk insert then you can use 'OLE DB Command' and transfer to the destination. Hope it is clear.

If I understand your question clearly then I think you can use a derived column before the actual load task. There shoul be some value which differs the imput...

Never mind, I forgot to unlock the variable 'vs'. If any user needs the code I declared the variable as 'Dim vs As IDTSVariables90'.

Thanks

That sounds good. I have used the following code now in preExecute:

VariableDispenser.LockForRead("User::TableName")

Me.VariableDispenser.GetVariables(vs)

TName =...

Thank you for the reply. I have declared a package variable User::TableName which holds the tablename created from GUID (ex: tbl4e0dfc2c8389488ca2d050c202233871). It is runtime so we don't know each time...

Any comment on this issue please?

Thank you for the reply. Other peopl would like run my SSIS, simply by calling it. When I run the xp_cmdshell, I am getting 'The xp_cmdshell proxy account information cannot...

Thank you so much for the response. I got the following version:

Microsoft SQL Server 2005 - 9.00.4285.00 (X64) Feb 8 2010 23:31:46 Copyright (c) 1988-2005...

It is VS 2005 but, professional edition. So, no other option then?

Thank you for the help.

You are right. Thank you for the advice.

As i have mentioned it is an existing database. I can't change at my end to a view. Thank you for your response.

Thank you for the response. I am working on the existing database. Whenever the database developer add a new column, my project is giving errors and I have to redo...