I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is just appending to the file instead of overwriting it. Here is how I have the package setup:

1.. SQL task that uses "drop table" on the Excel connection.
2.. SQL task that uses "create table" on the Excel connection.
3.. Transform data task that pumps the data from SQL to Excel.
How can I get this to overwrite the file instead of append to it?

Thank-you,
Rubens

I figured it out. I had two problems. First of all, the length of my table name was too long for an Excel workbook. Secondly, there was only 1 sheet in the workbook which Excel cannot drop because you need at least 1. So I added an additional sheet and it now works.

Thank-you,
Rubens
"Rubens" <rubensrose (AT) hotmail (DOT) com> wrote

I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is just appending to the file instead of overwriting it. Here is how I have the package setup:

1.. SQL task that uses "drop table" on the Excel connection.
2.. SQL task that uses "create table" on the Excel connection.
3.. Transform data task that pumps the data from SQL to Excel.
How can I get this to overwrite the file instead of append to it?

Thank-you,
Rubens

I figured it out. I had two problems. First of all, the length of my table name was too long for an Excel workbook. Secondly, there was only 1 sheet in the workbook which Excel cannot drop because you need at least 1. So I added an additional sheet and it now works.

Thank-you,
Rubens
"Rubens" <rubensrose (AT) hotmail (DOT) com> wrote

I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is just appending to the file instead of overwriting it. Here is how I have the package setup:

1.. SQL task that uses "drop table" on the Excel connection.
2.. SQL task that uses "create table" on the Excel connection.
3.. Transform data task that pumps the data from SQL to Excel.
How can I get this to overwrite the file instead of append to it?

Thank-you,
Rubens

I figured it out. I had two problems. First of all, the length of my table name was too long for an Excel workbook. Secondly, there was only 1 sheet in the workbook which Excel cannot drop because you need at least 1. So I added an additional sheet and it now works.

Thank-you,
Rubens
"Rubens" <rubensrose (AT) hotmail (DOT) com> wrote

I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is just appending to the file instead of overwriting it. Here is how I have the package setup:

1.. SQL task that uses "drop table" on the Excel connection.
2.. SQL task that uses "create table" on the Excel connection.
3.. Transform data task that pumps the data from SQL to Excel.
How can I get this to overwrite the file instead of append to it?

Thank-you,
Rubens

I figured it out. I had two problems. First of all, the length of my table name was too long for an Excel workbook. Secondly, there was only 1 sheet in the workbook which Excel cannot drop because you need at least 1. So I added an additional sheet and it now works.

Thank-you,
Rubens
"Rubens" <rubensrose (AT) hotmail (DOT) com> wrote

I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is just appending to the file instead of overwriting it. Here is how I have the package setup:

1.. SQL task that uses "drop table" on the Excel connection.
2.. SQL task that uses "create table" on the Excel connection.
3.. Transform data task that pumps the data from SQL to Excel.
How can I get this to overwrite the file instead of append to it?

Thank-you,
Rubens

I figured it out. I had two problems. First of all, the length of my table name was too long for an Excel workbook. Secondly, there was only 1 sheet in the workbook which Excel cannot drop because you need at least 1. So I added an additional sheet and it now works.

Thank-you,
Rubens
"Rubens" <rubensrose (AT) hotmail (DOT) com> wrote

I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is just appending to the file instead of overwriting it. Here is how I have the package setup:

1.. SQL task that uses "drop table" on the Excel connection.
2.. SQL task that uses "create table" on the Excel connection.
3.. Transform data task that pumps the data from SQL to Excel.
How can I get this to overwrite the file instead of append to it?

Thank-you,
Rubens

I figured it out. I had two problems. First of all, the length of my table name was too long for an Excel workbook. Secondly, there was only 1 sheet in the workbook which Excel cannot drop because you need at least 1. So I added an additional sheet and it now works.

Thank-you,
Rubens
"Rubens" <rubensrose (AT) hotmail (DOT) com> wrote

I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is just appending to the file instead of overwriting it. Here is how I have the package setup:

1.. SQL task that uses "drop table" on the Excel connection.
2.. SQL task that uses "create table" on the Excel connection.
3.. Transform data task that pumps the data from SQL to Excel.
How can I get this to overwrite the file instead of append to it?

Thank-you,
Rubens

I figured it out. I had two problems. First of all, the length of my table name was too long for an Excel workbook. Secondly, there was only 1 sheet in the workbook which Excel cannot drop because you need at least 1. So I added an additional sheet and it now works.

Thank-you,
Rubens
"Rubens" <rubensrose (AT) hotmail (DOT) com> wrote

I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is just appending to the file instead of overwriting it. Here is how I have the package setup:

1.. SQL task that uses "drop table" on the Excel connection.
2.. SQL task that uses "create table" on the Excel connection.
3.. Transform data task that pumps the data from SQL to Excel.
How can I get this to overwrite the file instead of append to it?

Thank-you,
Rubens

I figured it out. I had two problems. First of all, the length of my table name was too long for an Excel workbook. Secondly, there was only 1 sheet in the workbook which Excel cannot drop because you need at least 1. So I added an additional sheet and it now works.

Thank-you,
Rubens
"Rubens" <rubensrose (AT) hotmail (DOT) com> wrote

I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is just appending to the file instead of overwriting it. Here is how I have the package setup:

1.. SQL task that uses "drop table" on the Excel connection.
2.. SQL task that uses "create table" on the Excel connection.
3.. Transform data task that pumps the data from SQL to Excel.
How can I get this to overwrite the file instead of append to it?

Thank-you,
Rubens