DTS customization

Dear techs,

Hmm...I have a little problem using DTS. I made a simple DTS
package where it extracts data from my database using a Stored
Procedure and then exports it into a list. But everytime I export, it
overwrites the file ('caused by statically entering the location of
the file in Enterprise Manager) but I don't want it to do that. I want
it to do something like this:

1. After exporting the first time, I want it to label as
sample20030904.csv
2. The next time I export again, I want it to create another file and
label as sample20030905.csv

Is it possible to do something like that?

Ansonanson.zeall@.quicken.com.au (anson) wrote in message news:<7a13e84c.0309032008.7824d3be@.posting.google.com>...
> Dear techs,
> Hmm...I have a little problem using DTS. I made a simple DTS
> package where it extracts data from my database using a Stored
> Procedure and then exports it into a list. But everytime I export, it
> overwrites the file ('caused by statically entering the location of
> the file in Enterprise Manager) but I don't want it to do that. I want
> it to do something like this:
> 1. After exporting the first time, I want it to label as
> sample20030904.csv
> 2. The next time I export again, I want it to create another file and
> label as sample20030905.csv
> Is it possible to do something like that?
> Anson

One way is to use a global variable for the file name, then you set it
and assign it to the connection in an ActiveX step, or with a dynamic
properties task. This should help you get started:

http://www.sqldts.com/default.aspx?200

Simon

DTS / Export Data in Sql2005 Mgm Studio

Dear all,

I have a SQL 2000 and SQL 2005 servers separately, but by whatever reason, I can't use SQL 2000 Enterprise Mgr anymore now so I have to use SQL 2005 Mgm studio to open up my SQL 2000 databases now.

However, I'd like to export data from Sql 2000 to another Sql 2000 server, but via a Sql 2005 mgm studio interface right now. How can I do so? I can't find "Export Data" from the "Task" context menu in Sql 2005 mgm studio.

Thanks,

Hi,

if you want to use the SQL Server MS for that you have to right click on whatever database on choose Tasks..Export data. That should be straight forward for you like in SQL 2k days.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

Dts

Dear All,

I want to create DTS using an excel file is source and destination is DB-Table.

Please help me, how to proceed.

Thanks,
Tosyed

Quote:

Originally Posted by tosyed

Dear All,

I want to create DTS using an excel file is source and destination is DB-Table.

Please help me, how to proceed.

Thanks,
Tosyed

Hi there,

Please do not double post. You are using MSSQL or MySQL? Which one?|||

Quote:

Originally Posted by sashi

Hi there,

Please do not double post. You are using MSSQL or MySQL? Which one?

I am using MSSQL.|||Use DTS Import/Export Wizard and then save it to the SQL Server msdb database