You should edit the connection string of the Excel connection manager. Have you got an Excel connection manager in your SSIS-package?

The place to look is in the properties window of...

And the question is...?

If you want to read an Excel file, you probaby have already an Excel File Connection Manager set-up.

Do the following:

Click on the connection manager. Then, go to the properties window...

I'm afraid you can't merge the columns in the Bulk Insert Task.

You could set-up a data flow with a Flat File Source where you read all of the file contents.

Then...

I try to avoid the built-in SCD component in SSIS for performance reasons and policies do not allow custom or 3rd party components. So I'm basically stuck with T-SQL. I've...

For reading the Excel file you certainly need an Excel connection manager and an Excel Source component in your data flow. Make sure you surf the net a bit on...

Add a second step in your first job. There, you can use T-SQL with a stored procedure to call the other job:

USE MSDB;

GO

EXEC dbo.sp_start_job N'My other job'

GO

One easy point for me!

You are missing something.

The Having clause behaves as a where clause in this query. The maximum of col2 is 6, so each row sattisfies the condition, ergo, the having clause...

Nice question, although not that hard for me as I use SELECT INTO a lot.

Ed-86789 (6/11/2010)

---

The temp table should work with either type. A #table is visible only to the connection that created it. A ##table is available to all connections as...

You can try three things:

* format the columns in the Excel file to General.

* write a SQL query to the Excel file to fetch the data and format the data...

Normally, the best option is to use global temp tables, so with two #. (##temp_table)

Where do you create your temp table? In a task before the dataflow or in the...

The registry hack works. It should be best practice to set the value...

The Truncate/insert method will only work if your source data also keeps history. If not, you're stuck with incremental load.

Furthermore, at the beginning truncate/insert will surely work faster than the...