If the footer text is static and unique within the file, you can import everything including the footer into the temp table and delete that row which pertains to the...

Basically, you need 2 connections (1 for excel, 1 for sql), 1 data flow task & 1 derived column transformation (within data flow task) that splits the value into multiple...

Please don't double post, continue discussions here

I guess there is an option in QA as well as in SSMS to enable/disable column headers display in results window.

Doesn't you mean to INSERT new records from TableA to TableB than to UPDATE? If not the latter case, then you have to do something like this.

INSERT INTO TableB

SELECT...

To make the connection dynamic, you have to set the "Connection String" property through the Expressions of Connection Manager to a User Defined Variable that will contain the connection string....

Jo's solution should work, except that you need to change PATHINDEX to PATINDEX. And also make sure you check for the string existence getting the LEFT or RIGHT of...

There are a lot of ways to transfer data from one source to another.

1. Import-Export Wizard

2. DTS Packages

3. Linked Servers

4. OPENROWSET

Since you already implemented the parent-child recursion using CTE, you can post that query along with some information about the output required for the given input. You mentioned that...

I don't think that the WHILE statement (or any conditional statements like IF/ELSE, GOTO etc.) is allowed in any CTE block. May be only DML statements are allowed in...

Since you are doing a comparison of string data and not the numerical data, and in string comparisons the value "10 marla" comes before "8 marla" (or "10" comes before...

I agree with Chris, I don't think that this looks like a real world scenario. Or may be you have posted a simpler version of the scenario. If...

You can do it by using a derived table (within the query) to get MIN of Col1 for each Col2 value and then doing an INNER JOIN of this table...

Most of the performance issues arises because of badly written query, improper indexes or excess fragmentation or no enough statistics etc.

So, if you can you provide us with the...

You can make the concatenation in the oledb source by using the sql command as the data access mode. Do a SELECT and return the a derived column by...