From whatever I have tried/looked into/researched, atleast in DTS 2000, ActiveX Script alone seems to solve this problem. I use an environment variable because, I do not want to change...

Step 1

======

Create an Environment variable

Name:   PathToExcelFiles

Value:  c:\whatever\

Step 2

======

Drop an Excel connection onto the DTS designer

Give the path to the Excel File. This path could be anywhere. (d:\whatever\ for example)

We...

yes, as long as there is a header line and it is a comma separated csv file, Robert Davis's solution is the one and it could be very simple.

But if...

good that you solved the problem yourself.

but if you need the vbcrlf, you can have it. Either type the whole thing in one line or use the 'line split...

Nice analysis Steve!

Whether someone gets fired or not, the list is definitely a chance to test oneself and make amends if necessary before the d-day arrives.

Thankz for keeping us reminded...

one clarification:

this is what I meant to say. You cannot use this construct to get the output of a stored procedure into a table variable.

declare @table_variable table(f1 varchar(100), f2 varchar(100))

INSERT...

Very nice article!

Addresses a key problem area in SQL Server!

Sorry to butt in Phil. You cannot do that.  Even if you change the name in sysdtspackages the designer still has the readonly only GUID and versionid which will not...

I know only Steve. Had no interaction with Andy and Brian. They must be great guys two

I am averse to browsing the internet...

my two cents please.

whatever is the status of the schedule, as long as the job is disabled, there is no activitiy that goes on in the SQL Server.

I did some...

P1, P2 and P3 refer to Period1, Period2 and Period3.

In a real situation, they could be labelled week1, week2, week3,.....weekN

so if you have data collected for 2 years (i.e. 52...

Real nice article. It exactly mirrors reality. I worked

in Oracle 8i very extensively...

Good Job Steeve,

Will be nice for new comers, and a nice recap for old dummies.

I have more counters, but it includes all the counters you have listed.

Sincerely, I had to...