I have a DTS  package that I'm running on a daily basis
It basically transfer records from one view (Yesterday transactions) into a
csv file
I have a filter on GetDate()-1 on the InvoiceDate column.

Hi...!
I need to know the last time a DTS package was executed, but this DTS do not
belong to any Job. This DTS is always executed manually, by an external
application .... never by a SQL Server Job.

I have ten scripts that are currently being run in Query Analyzer that
each return multiple query results and print statements.   Each of
these script resutls is then copied into an excel spreadsheet for QA
and recordkeeping purposes each month.   My current approach is to

I know that Enterprise Manager allow you to script a stored procedure to
optional include Descriptive Header.
Whenever I create a new script file for my Stored Procedure etc, I will
include comments in the descriptive header. This will be easier for us to

Hi, me again.  SQL2005 sp1, SSIS.
I have a nice package with several foreach enumerators.  Two are working
fine, against a folder d:\foo\bar\.  A third one refuses to find files in an
adjacent folder, d:\foo\baz\.  I even entered a new enumerator, fixed all the

Newbie here (again)!
Just went through creating my first XML configuration, worked like a charm.
Now thought I'd give a shot to a database configuration, but the dialog
creates a table, puts no rows in it, then demands a filter.  I can't find in

SQL Server 2000 - very old DTS package has 18 connections which are no longer
valid. (We often move this dts between multiple servers.) How do I "clean-up"
the dts package and remove the obsolete connections?

I have a DTS package and I want to write an event to the event log.
Set objShell = Wscript.CreateObject("Wscript.Shell")
objShell.LogEvent EVENT_SUCCESS, strMessage
However it keeps throwing a error.  So my question is, should I be able to run

Problem:
My data flow is jamming intermittently this was helped by reducing the
MaxInsertCommitSize to 100. but the problem still exists. I ran it several
days ago. it procesed somehting over 200 records then sat doing nothinig

Using SQL2000 my DTS job was to grab a files using Active-X script
from another server that was mapped. If I manually run the design
package it was successfully execute but once I schedule it to run
every 30 minutes interval this following error message was occur. Any

My SSIS package requires access to a network file in order to read data into
the local SQL server.
What is the most effecient and secure method to acheive this?
My developers can produce something in .net which I can add to a scripting

How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?

More newbie questions here, but is it true you can't do what we did in DTS,
like
select * from dbo.mytable where myfoo like '?'
... that what you do instead is to create a dynamic sql statement and

In DTS you could post comments on the design surface, but I can't seem to
find a way to do that in SSIS - is it there?
Thanks.
Josh

Do you know if it's possible on SQL Server 2000, to recover a DTS from the
.BAS generated ?
If not, I have the .mdf and .ldf (unfortunately backup is dead) from the
master and msdb file. How is it possible to use them but not on the same