Not as far as I know...however, it is easier than you think to rename the file...

Dim objfso

Set objfso = CreateObject("Scripting.FileSystemObject")

Dim objfile

If objfso.FileExists(("\\myserver\myfiles\myfile.txt")

) Then

objfile.copyfile "\\myserver\myfiles\myfile.txt", "\\myserver\myfiles\newfilename.txt"

'CopyFile method will leave the original...

Turn on package logging and let the job run...the log will give you the start and stop times and duration for each step...or at least the duration for each step...

You should contact Steve Allen at Zap Technologies...his company might have what you are looking for and he is a knowledgeable contributor to this list. I believe his company's web...

I am opening the package and executing the task and then checking the value of the global variables in the package properties, Tom. Have done this a lot in the...

Hi Tom,

Yes...I am testing it from withing DTS Designer...

Michael

Michael Weiss

Bring your file into a staging table. Then in your insert query [into your final destination table], do something like:

INSERT INTO maintable(pk_field, field1, field2, etc...)

SELECT s.pk_field, s.field1, s.field2, etc...

FROM stagingtable...

Try wrapping your query in your Execute SQL Task in a stored procedure and then pass in the parameter...this should work fine using the EXEC usp_mysproc ? syntax...

hth,

Michael

Michael Weiss

Well let's say that your dimension table has the following fields:

currency_key, currency_type

With data such as 1, US Dollar

2, Euro

Could you not have a data member that would look like 3,...

Hi Ryan,

Can you add a catch-all level in your dimension table with a value of something like "N/A"? Then you could default all nulls to this level's key value...just a...

Hi Tracy...

I think you had it in your first post, didn't you?

Exec UpdateInfo @EmpId = "'" & Forms!frmEmployee!txtEmpID & "'"

I am not sure, but you could try it without the...

Hi Tracy!

In a stored procedure, you can have both input variables and output variables. If you modify your stored procedure such as:

CREATE PROCEDURE UpdateInfo

@EmpID int

AS

Select * from tblEmployee where...

But why run [essentially] the same query twice? How about if you do the following in your stored procedure?

Create Procedure usp_mysproc

@somevalue int = 1

AS

--Place your query here for example:

INSERT mytable(field1,...

The OLAP Administrators group should have been created automatically when you installed Analysis Services. On your computer running Analysis Services, go to control panel, users. The OLAP Administrators group should...

You can reference global variables in your ActiveX task a couple of ways. The first is to reference them through the DTSGlobalVariables collection such as:

DTSGlobalVariables( "GV1" ).Value = myvalue

You can...

Sorry...should have added that Data Analyzer will pull data from many different sources. Analysis Services is one of them.

~Michael

Michael Weiss