Viewing 15 posts - 601 through 615 (of 927 total)
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...
May 9, 2014 at 1:58 am
you mean u need to execute the dynamic script u do not need the select statement, its is right?
May 9, 2014 at 12:59 am
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...
May 9, 2014 at 12:58 am
your schema tells that you are working on Oracle, it is a SQL SERVER related site.
May 9, 2014 at 12:38 am
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...
May 9, 2014 at 12:23 am
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...
May 6, 2014 at 11:17 pm
My mistake , i wanted to write "ExecuteSQL task" :-)...
Thanks Phil ...
i will update my response
May 6, 2014 at 4:32 am
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...
May 6, 2014 at 4:21 am
Koen Verbeeck (5/6/2014)
Usually it's better to start a new thread for a new question.
+++1, there are also many excellent article available here, you just need to search them really.
May 6, 2014 at 12:35 am
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...
May 5, 2014 at 4:00 am
Koen Verbeeck (4/24/2014)
SSIS expects a specific format.YYYY-MM-DD HH:MIS:SS
Just a thought really, In addition to Koen respone if your source is sql server, you can perform this convert on database level....
April 24, 2014 at 12:41 am
Confusing Queries (4/24/2014)
twin.devil (4/24/2014)
Confusing Queries (4/24/2014)
Eirikur Eiriksson (4/23/2014)
Any restrictions or limits, i.e. as numeric only, alpha numeric, max length and such?
It should be numeric or alpha numeric with maximum of...
April 24, 2014 at 12:32 am
redcn2004 (4/24/2014)
I want to Print all the records to a XML Page,So I Need to convert select result to variable
there is a limitation on Print statement that your value...
April 24, 2014 at 12:27 am
Confusing Queries (4/24/2014)
Eirikur Eiriksson (4/23/2014)
Any restrictions or limits, i.e. as numeric only, alpha numeric, max length and such?
It should be numeric or alpha numeric with maximum of 16 characters. Thanks...
April 24, 2014 at 12:17 am
redcn2004 (4/23/2014)
use a variable not a file to output the result
xml type columns are shown in the SSMS because it easy to read the data just by clicking it. when...
April 23, 2014 at 11:49 pm
Viewing 15 posts - 601 through 615 (of 927 total)