Files are missing or not registered...files not registered

Hello,
I am having a problem connecting to SQL server 2000 through enterprise manager. Whenever i try to look at a table, view or DTS package I get the message...

"The query cannot be executed because some files are either missing or not registered. Run setup again to make sure the required files are registered."

I have tried to re-register, unregister and re-register.

I have tried to create a new instance of SQL server and attach the Data files to this.

I have tried to Re-install client tools.

The only option I am left with is totally removing SQL server and re-installing then restoring the Databases from a backup tape...
I just wanted to know if anyone has anyother ideas before i go ahead and do this.
Thanks in advance.

JF

One more thing...
I can access all of the tables through access and excel and other data analyzers as I normally would.hi
have you tried checking the error on microsoft tech net, they dont always mean what they say. have had lot of success in the past

all the best

Originally posted by josef fukano
Hello,
I am having a problem connecting to SQL server 2000 through enterprise manager. Whenever i try to look at a table, view or DTS package I get the message...

"The query cannot be executed because some files are either missing or not registered. Run setup again to make sure the required files are registered."

I have tried to re-register, unregister and re-register.

I have tried to create a new instance of SQL server and attach the Data files to this.

I have tried to Re-install client tools.

The only option I am left with is totally removing SQL server and re-installing then restoring the Databases from a backup tape...
I just wanted to know if anyone has anyother ideas before i go ahead and do this.
Thanks in advance.

JF

One more thing...
I can access all of the tables through access and excel and other data analyzers as I normally would.|||Originally posted by kpaynter
hi
have you tried checking the error on microsoft tech net, they dont always mean what they say. have had lot of success in the past

all the best

kpaynter

I found this article on microsoft tech net...

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b315868

On it has commands to be ran in command promt.
It did the trick, thank you very much for your reply...
You saved my 3 day weekend!!!!
Thanks again,
JF

File or assembly name Interop.DTS, or one of its dependencies, was not found.

I am trying to execute a DTS via COM according to the KB article
http://support.microsoft.com/?kbid=321525
but I am getting the exception "File or assembly name Interop.DTS, or one of
its dependencies, was not found." which is obviously a file not found
exception. I have sql server 2000 installed locally and I can run the
package from enterprise manager. Anyone got any ideas why I am getting when
I have the correct reference in the c# .net project?
--
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.Is the Interop.DTS.dll in your application bin folder? This should get
generated when you build your project.
You might also check out the examples at
http://sqldev.net/dts/ExecutePackage.htm
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
>I am trying to execute a DTS via COM according to the KB article
> http://support.microsoft.com/?kbid=321525
> but I am getting the exception "File or assembly name Interop.DTS, or one
> of
> its dependencies, was not found." which is obviously a file not found
> exception. I have sql server 2000 installed locally and I can run the
> package from enterprise manager. Anyone got any ideas why I am getting
> when
> I have the correct reference in the c# .net project?
> --
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>|||yeap it was noob error, no dll in the bin directory :)
Ollie
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:#$jJFpkJFHA.2136@.TK2MSFTNGP14.phx.gbl...
> Is the Interop.DTS.dll in your application bin folder? This should get
> generated when you build your project.
> You might also check out the examples at
> http://sqldev.net/dts/ExecutePackage.htm
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
> news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
> >I am trying to execute a DTS via COM according to the KB article
> >
> > http://support.microsoft.com/?kbid=321525
> >
> > but I am getting the exception "File or assembly name Interop.DTS, or
one
> > of
> > its dependencies, was not found." which is obviously a file not found
> > exception. I have sql server 2000 installed locally and I can run the
> > package from enterprise manager. Anyone got any ideas why I am getting
> > when
> > I have the correct reference in the c# .net project?
> >
> > --
> > Cheers
> >
> > Ollie Riches
> > http://www.phoneanalyser.net
> >
> > Disclaimer: Opinions expressed in this forum are my own, and not
> > representative of my employer.
> > I do not answer questions on behalf of my employer. I'm just a
programmer
> > helping programmers.
> >
> >
>

File or assembly name Interop.DTS, or one of its dependencies, was not found.

I am trying to execute a DTS via COM according to the KB article
http://support.microsoft.com/?kbid=321525
but I am getting the exception "File or assembly name Interop.DTS, or one of
its dependencies, was not found." which is obviously a file not found
exception. I have sql server 2000 installed locally and I can run the
package from enterprise manager. Anyone got any ideas why I am getting when
I have the correct reference in the c# .net project?
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.Is the Interop.DTS.dll in your application bin folder? This should get
generated when you build your project.
You might also check out the examples at
http://sqldev.net/dts/ExecutePackage.htm
Hope this helps.
Dan Guzman
SQL Server MVP
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
>I am trying to execute a DTS via COM according to the KB article
> http://support.microsoft.com/?kbid=321525
> but I am getting the exception "File or assembly name Interop.DTS, or one
> of
> its dependencies, was not found." which is obviously a file not found
> exception. I have sql server 2000 installed locally and I can run the
> package from enterprise manager. Anyone got any ideas why I am getting
> when
> I have the correct reference in the c# .net project?
> --
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>|||yeap it was noob error, no dll in the bin directory
Ollie
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:#$jJFpkJFHA.2136@.TK2MSFTNGP14.phx.gbl...
> Is the Interop.DTS.dll in your application bin folder? This should get
> generated when you build your project.
> You might also check out the examples at
> http://sqldev.net/dts/ExecutePackage.htm
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
> news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
one[vbcol=seagreen]
programmer[vbcol=seagreen]
>

File or assembly name Interop.DTS, or one of its dependencies, was not found.

I am trying to execute a DTS via COM according to the KB article
http://support.microsoft.com/?kbid=321525
but I am getting the exception "File or assembly name Interop.DTS, or one of
its dependencies, was not found." which is obviously a file not found
exception. I have sql server 2000 installed locally and I can run the
package from enterprise manager. Anyone got any ideas why I am getting when
I have the correct reference in the c# .net project?
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.Is the Interop.DTS.dll in your application bin folder? This should get
generated when you build your project.
You might also check out the examples at
http://sqldev.net/dts/ExecutePackage.htm
Hope this helps.
Dan Guzman
SQL Server MVP
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
>I am trying to execute a DTS via COM according to the KB article
> http://support.microsoft.com/?kbid=321525
> but I am getting the exception "File or assembly name Interop.DTS, or one
> of
> its dependencies, was not found." which is obviously a file not found
> exception. I have sql server 2000 installed locally and I can run the
> package from enterprise manager. Anyone got any ideas why I am getting
> when
> I have the correct reference in the c# .net project?
> --
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>|||yeap it was noob error, no dll in the bin directory :)
Ollie
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:#$jJFpkJFHA.2136@.TK2MSFTNGP14.phx.gbl...
> Is the Interop.DTS.dll in your application bin folder? This should get
> generated when you build your project.
> You might also check out the examples at
> http://sqldev.net/dts/ExecutePackage.htm
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
> news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
one
programmer
>

File or assembly name Interop.DTS, or one of its dependencies, was not found.

I am trying to execute a DTS via COM according to the KB article
http://support.microsoft.com/?kbid=321525
but I am getting the exception "File or assembly name Interop.DTS, or one of
its dependencies, was not found." which is obviously a file not found
exception. I have sql server 2000 installed locally and I can run the
package from enterprise manager. Anyone got any ideas why I am getting when
I have the correct reference in the c# .net project?
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.
Is the Interop.DTS.dll in your application bin folder? This should get
generated when you build your project.
You might also check out the examples at
http://sqldev.net/dts/ExecutePackage.htm
Hope this helps.
Dan Guzman
SQL Server MVP
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
>I am trying to execute a DTS via COM according to the KB article
> http://support.microsoft.com/?kbid=321525
> but I am getting the exception "File or assembly name Interop.DTS, or one
> of
> its dependencies, was not found." which is obviously a file not found
> exception. I have sql server 2000 installed locally and I can run the
> package from enterprise manager. Anyone got any ideas why I am getting
> when
> I have the correct reference in the c# .net project?
> --
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>
|||yeap it was noob error, no dll in the bin directory
Ollie
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:#$jJFpkJFHA.2136@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Is the Interop.DTS.dll in your application bin folder? This should get
> generated when you build your project.
> You might also check out the examples at
> http://sqldev.net/dts/ExecutePackage.htm
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
> news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
one[vbcol=seagreen]
programmer
>

file name or extension is too long

Hi All,
I am receiving the following message when I run Dts package which is
creating a cube.

Error Source : Microsoft Data transmission Services (DTS)
Package
Error Description: File name or extension is too long

Any help will be appreciated!
Thanks in advance,
Mohammed Sarwar
Ocp dba oracle 9i,8i,8.0

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Mohammed Sarwar <msarwar@.ubid.com> wrote in message news:<3fb3f814$0$193$75868355@.news.frii.net>...
> Hi All,
> I am receiving the following message when I run Dts package which is
> creating a cube.
> Error Source : Microsoft Data transmission Services (DTS)
> Package
> Error Description: File name or extension is too long
> Any help will be appreciated!
> Thanks in advance,
> Mohammed Sarwar
> Ocp dba oracle 9i,8i,8.0
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

You didn't mention which version of SQL Server you have, but if it's
7, then this KB article may apply to you:

http://support.microsoft.com/defaul...kb;en-us;243545

If the article isn't helpful, then you should post some more
information - your version of SQL Server, which step the package is
failing on etc. You might also want to post to
microsoft.public.sqlserver.dts.

Simon

File name includes file path in DTS Send Mail task - help

I have an issue with a DTS package. We create a zip file and then attach it to emails going out using DTS. The problem is that the attachment, when received, is named using the full path to the file, so it is quite long.

Has anyone seen this before? Is there a way out of this?

I am considering mapping a drive to the share holding the file to be named, but the fact is this will shorten the name but will still result in the path being included.

I am wondering if this is a bug, as I suspect this isn't the default behaviour.

Thank you in advance.

Davehow are you zipping the files? thru some command line statements? I dont think its related to DTS in any way.|||Are you talking about the file names inside the ZIP? or the name of the zip file?|||The files are zipped in a previous step. The values in the send mail step are dynamically set, but basically in the Add... for the attachment you get a path like:

\\computer\folder1\folder2\folder3\longzipfilename .zip

The attached file when received will be:

computerfolder1folder2folder3longzipfilename.zip

It is quite strange. The zip file name is only "longzipfilename.zip", and it is sitting in folder prior to the mail step, so I don't quite get it.

I hope that helps.

Thanks for the replys.|||It is strange, can you paste the send mail statements here? where name of the file is dynamically created.|||Originally posted by rohitkumar
It is strange, can you paste the send mail statements here? where name of the file is dynamically created.

I am stumpted. It looks like the file is displayed properly in Outlook but not in some other email clients, which makes me think this isn't a DTS issue after all. I am not at the site now, but essentially the value for the path of the file is getting passed along in the email. Since this is an intermittant problem (per Windows version or Outlook/Web Mail etc.) I don't believe it is something I can correct with any ease.

File name as yesterday's date

I'm running a DTS daily that needs to create a file with a unique name, as
yesterday's date. (Ex: 20050223)
I figured out how to get the date part of it:
CONVERT(char(32),DATEADD(DAY,-1,GETDATE()),112) = 20050222
but I can't seem to get it to create a table with that unique name each day.
Any ideas?
CREATE TABLE 'Date'
Ed>> I'm running a DTS daily that needs to create a file [sic] with a
unique name, as yesterday's date. (Ex: 2005-02-23) <<
No. no. no.
1) You have just re-discovered the old IBM tape system management
convention, which used a "yyddd' numbering scheme on the tape labels.
It was one of the thing that blew up in the Y2K disaster. You are over
50 years behind current IT standard practices.
2) We do not alter a schema by adding new tables without a good
reason. Altering a schema on a daily basis is sure sign of a major
design flaw.
3) This design flaw is called attribute splitting. you have taken the
value of a temporal attribute (date of creation) and split it into
separate tables. Would you keep a personnel table in two parts, male
and female employees? Of course not. You need one table with a date
column in it.|||Create an os file or a table?
***** OS File *****
Working with files and the FileSystemObject
http://www.sqldts.com/default.aspx?292
***** TABLE *****
Use dynamic sql.
Example:
declare @.tn sysname
declare @.sql nvarchar(4000)
set @.tn = N'tbl_' + convert(nvarchar(8), dateadd(day, -1, getdate()), 112)
set @.sql = N'create table ' + @.tn + '(colA int, colB datetime)'
execute sp_executesql @.sql
go
The Curse and Blessings of Dynamic SQL
http://www.sommarskog.se/dynamic_sql.html
AMB
"Edo" wrote:

> I'm running a DTS daily that needs to create a file with a unique name, as
> yesterday's date. (Ex: 20050223)
> I figured out how to get the date part of it:
> CONVERT(char(32),DATEADD(DAY,-1,GETDATE()),112) = 20050222
> but I can't seem to get it to create a table with that unique name each da
y.
> Any ideas?
> CREATE TABLE 'Date'
> Ed|||Thanks for your help on that matter.
But how would this apply to inserting, especially when appling sums and
inner joins.
INSERT INTO CONVERT(char(32),DATEADD(DAY,-1,GETDATE()),112)
Select COLMAT_TRACK_EMPS.EMPLOYEE_NAME,
SUM(CASE SUBSTRING(ITEM_MAST.CATEGORY, 4, 1) WHEN 'H' THEN
TRACK_DETAIL_CI.QTY ELSE 0 END) as 'H',
SUM(CASE SUBSTRING(ITEM_MAST.CATEGORY, 4, 1) WHEN 'M' THEN
TRACK_DETAIL_CI.QTY ELSE 0 END) as 'M',
SUM(CASE SUBSTRING(ITEM_MAST.CATEGORY, 4, 1) WHEN 'P' THEN
TRACK_DETAIL_CI.QTY ELSE 0 END) as 'P',
SUM(CASE SUBSTRING(ITEM_MAST.CATEGORY, 4, 1) WHEN 'A' THEN
TRACK_DETAIL_CI.QTY ELSE 0 END) as 'A',
SUM(CASE SUBSTRING(ITEM_MAST.CATEGORY, 4, 1) WHEN 'V' THEN
TRACK_DETAIL_CI.QTY ELSE 0 END) as 'V',
SUM(CASE SUBSTRING(ITEM_MAST.CATEGORY, 4, 1) WHEN 'L' THEN
TRACK_DETAIL_CI.QTY ELSE 0 END) as 'L',
SUM(CASE SUBSTRING(ITEM_MAST.CATEGORY, 4, 1) WHEN 'S' THEN
TRACK_DETAIL_CI.QTY ELSE 0 END) as 'S',
SUM (TRACK_DETAIL_CI.QTY) AS QTYSUM
FROM COLMAT_TRACK_EMPS INNER JOIN
TRACK_DETAIL_CI ON COLMAT_TRACK_EMPS.EMPLOYEE_NO =
TRACK_DETAIL_CI.EMPLOYEE_NO
INNER JOIN ITEM_MAST ON ITEM_MAST.EDP_NO = TRACK_DETAIL_CI.EDP_NO
WHERE TRACK_DETAIL_CI.TRANS_DATE =
CONVERT(char(32),DATEADD(DAY,-1,GETDATE()),112)
GROUP BY COLMAT_TRACK_EMPS.EMPLOYEE_NAME
INSERT INTO CONVERT(char(32),DATEADD(DAY,-1,GETDATE()),112)
SELECT 'TOTAL' AS EMPLOYEE_NAME, SUM (EDS_TRIAL.H), SUM (EDS_TRIAL.M), SUM
(EDS_TRIAL.P), SUM (EDS_TRIAL.A), SUM (EDS_TRIAL.V), SUM (EDS_TRIAL.L), SUM
(EDS_TRIAL.S), SUM (EDS_TRIAL.QTYSUM)
FROM CONVERT(char(32),DATEADD(DAY,-1,GETDATE()),112)
"Alejandro Mesa" wrote:
> Create an os file or a table?
> ***** OS File *****
> Working with files and the FileSystemObject
> http://www.sqldts.com/default.aspx?292
> ***** TABLE *****
> Use dynamic sql.
> Example:
> declare @.tn sysname
> declare @.sql nvarchar(4000)
> set @.tn = N'tbl_' + convert(nvarchar(8), dateadd(day, -1, getdate()), 112)
> set @.sql = N'create table ' + @.tn + '(colA int, colB datetime)'
> execute sp_executesql @.sql
> go
> The Curse and Blessings of Dynamic SQL
> http://www.sommarskog.se/dynamic_sql.html
>
> AMB
> "Edo" wrote:
>

File Manipulation from MS SQL Server

I am working on an application which uses DTS to move data into temporary tables. I would like to be able to rename/relocate the source file in order to maintain a historical reference. The process which creates the source file is not flexible at all. Is there a way to manipulate the file's name and/or relocate the file by using SQL Server.

Thanks in advance!

Daniel
Austin, TexasTry looking into xp_cmdshell stored proc in BOL. This will allow you to use DOS commands from a TSQL script. We had to use this stored proc to rename delimited files we created from a DTS to be exported to a marketing company. Works pretty good.

HTH

DMW|||Hi DMW,

Thank you very much! I will give this a try.

Sincerely,

Daniel
Austin, Texas|||USE Northwind
GO

SET NOCOUNT ON
CREATE TABLE myTable99(RowNum int IDENTITY(1,1), Data varchar(8000))
GO

INSERT INTO myTable99(Data) EXEC master..xp_cmdshell 'Dir C:\*.*'

SELECT * FROM myTable99
GO

SET NOCOUNT OFF
DROP TABLE myTable99
GO|||I use sp_oaxxx with FileSystemObject, because xp_cmdshell will require for a user to have privileges on the target file system.

File Generation through the DTS

I have created a DTS package (SQL 2000) that generates an Excel file.
The first time it works great but every time after that the DTS would
append the data to a file and not overwrite it. I need to be
overwritten. I tried to replace the generated file with the empty one
but it doesn't put any date in it.
How can I have my DTS package overwrite the excel file as opposed to
append to it?
Thank you,
T.
I assume you are using the Export Data wizard to create the DTS
package. Start this process and choose an EXISTING spreadsheet. When
you get to the step where you select the table(s) to be exported, the
last column on the table line is headed Transform. Once you have
checked off the table to export, a button appears in that column;
click on that button. In the window that appears, on the Column
Mappings tab, there are options for Delete and Append. Choose Delete.
Be sure to Save the package.
Then you can either use the package it created, or inspect that
package to see how the Delete step was coded and copy that.
Roy Harvey
Beacon Falls, CT
On 8 Mar 2007 08:54:43 -0800, "tolcis" <nytollydba@.gmail.com> wrote:

>I have created a DTS package (SQL 2000) that generates an Excel file.
>The first time it works great but every time after that the DTS would
>append the data to a file and not overwrite it. I need to be
>overwritten. I tried to replace the generated file with the empty one
>but it doesn't put any date in it.
>How can I have my DTS package overwrite the excel file as opposed to
>append to it?
>Thank you,
>T.
|||On Mar 8, 12:18 pm, Roy Harvey <roy_har...@.snet.net> wrote:[vbcol=seagreen]
> I assume you are using the Export Data wizard to create the DTS
> package. Start this process and choose an EXISTING spreadsheet. When
> you get to the step where you select the table(s) to be exported, the
> last column on the table line is headed Transform. Once you have
> checked off the table to export, a button appears in that column;
> click on that button. In the window that appears, on the Column
> Mappings tab, there are options for Delete and Append. Choose Delete.
> Be sure to Save the package.
> Then you can either use the package it created, or inspect that
> package to see how the Delete step was coded and copy that.
> Roy Harvey
> Beacon Falls, CT
> On 8 Mar 2007 08:54:43 -0800, "tolcis" <nytolly...@.gmail.com> wrote:
>
I am using a query to generate a resultset. In DTS I have a
connection object and destination spreadsheet. In the mappings I
don't see any delete or append.
|||On 8 Mar 2007 10:48:19 -0800, "tolcis" <nytollydba@.gmail.com> wrote:

>I am using a query to generate a resultset. In DTS I have a
>connection object and destination spreadsheet. In the mappings I
>don't see any delete or append.
My example applied to the windows in the Wizard. I still suggest
following my example to see how the wizard codes the DELETE so that
you can copy the method in your DTS package.
Roy Harvey
Beacon Falls, CT

File Generation through the DTS

I have created a DTS package (SQL 2000) that generates an Excel file.
The first time it works great but every time after that the DTS would
append the data to a file and not overwrite it. I need to be
overwritten. I tried to replace the generated file with the empty one
but it doesn't put any date in it.
How can I have my DTS package overwrite the excel file as opposed to
append to it?
Thank you,
T.I assume you are using the Export Data wizard to create the DTS
package. Start this process and choose an EXISTING spreadsheet. When
you get to the step where you select the table(s) to be exported, the
last column on the table line is headed Transform. Once you have
checked off the table to export, a button appears in that column;
click on that button. In the window that appears, on the Column
Mappings tab, there are options for Delete and Append. Choose Delete.
Be sure to Save the package.
Then you can either use the package it created, or inspect that
package to see how the Delete step was coded and copy that.
Roy Harvey
Beacon Falls, CT
On 8 Mar 2007 08:54:43 -0800, "tolcis" <nytollydba@.gmail.com> wrote:
>I have created a DTS package (SQL 2000) that generates an Excel file.
>The first time it works great but every time after that the DTS would
>append the data to a file and not overwrite it. I need to be
>overwritten. I tried to replace the generated file with the empty one
>but it doesn't put any date in it.
>How can I have my DTS package overwrite the excel file as opposed to
>append to it?
>Thank you,
>T.|||On Mar 8, 12:18 pm, Roy Harvey <roy_har...@.snet.net> wrote:
> I assume you are using the Export Data wizard to create the DTS
> package. Start this process and choose an EXISTING spreadsheet. When
> you get to the step where you select the table(s) to be exported, the
> last column on the table line is headed Transform. Once you have
> checked off the table to export, a button appears in that column;
> click on that button. In the window that appears, on the Column
> Mappings tab, there are options for Delete and Append. Choose Delete.
> Be sure to Save the package.
> Then you can either use the package it created, or inspect that
> package to see how the Delete step was coded and copy that.
> Roy Harvey
> Beacon Falls, CT
> On 8 Mar 2007 08:54:43 -0800, "tolcis" <nytolly...@.gmail.com> wrote:
> >I have created a DTS package (SQL 2000) that generates an Excel file.
> >The first time it works great but every time after that the DTS would
> >append the data to a file and not overwrite it. I need to be
> >overwritten. I tried to replace the generated file with the empty one
> >but it doesn't put any date in it.
> >How can I have my DTS package overwrite the excel file as opposed to
> >append to it?
> >Thank you,
> >T.
I am using a query to generate a resultset. In DTS I have a
connection object and destination spreadsheet. In the mappings I
don't see any delete or append.|||On 8 Mar 2007 10:48:19 -0800, "tolcis" <nytollydba@.gmail.com> wrote:
>I am using a query to generate a resultset. In DTS I have a
>connection object and destination spreadsheet. In the mappings I
>don't see any delete or append.
My example applied to the windows in the Wizard. I still suggest
following my example to see how the wizard codes the DELETE so that
you can copy the method in your DTS package.
Roy Harvey
Beacon Falls, CT