For you question you cannot delete rows from excel using t-sql, you can only update the rows to empty.

can you explain your scenario in detail why u want to delete...

you mean u need to execute the dynamic script u do not need the select statement, its is right?

use 'Data Conversion' in you Data Flow, try to convert the ID column in Int,

click Configure Error Output, on Error Column Change the Fail Component to Redirect Rows.

Create a...

your schema tells that you are working on Oracle, it is a SQL SERVER related site.

usually when you say u need a computed column, u need to know how u want to have a resulting value For example if u have a table 'Order'. you...

There is always a difference between a good technical resource and a good leader, its the most common mistake, its just like R-BAR in Sql Server, 🙂 and i cant...

My mistake , i wanted to write "ExecuteSQL task" :-)...

Thanks Phil ...

i will update my response

There are two ways to achieve for update

1. Use this Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services[/url] which is a slower way because...

+++1, there are also many excellent article available here, you just need to search them really.

if the package is failing in between, like few rows are transferred but got error, that may be due to some data type issue. if this is the issue then...

Just a thought really, In addition to Koen respone if your source is sql server, you can perform this convert on database level....

Confusing Queries (4/24/2014)

twin.devil (4/24/2014)

Confusing Queries (4/24/2014)

Eirikur Eiriksson (4/23/2014)

It should be numeric or alpha numeric with maximum of...

there is a limitation on Print statement that your value...

Confusing Queries (4/24/2014)

Eirikur Eiriksson (4/23/2014)

It should be numeric or alpha numeric with maximum of 16 characters. Thanks...

xml type columns are shown in the SSMS because it easy to read the data just by clicking it. when...