I received from DTS File and related Excel Sheet from my customer. I could
be able to open the DTS File.

It showd a connection between Excel and OLE DB Data Sources.

Then I treied to run this , it says ' Trasform Data Task:Undefined '

Kindly let me know the procedure to run

Am totallay new to this.

Thanks
Krish

That is perfectly valid.

I presume where you saw this is in the little pop up UI with a list of tasks
to execute?

After the package had run did you see a Green arrow or a red cross ?

The "Transform Data Task:Undefined " is because the designer did not assign
a description to the Transform data task.

You can do this though by double clicking on the black arrow beween the two
connections.


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"RV.Krishnan" <krish (AT) rsi (DOT) ramco.com> wrote

Thanks Allan. It is working now. am able to Execute/setup DTS.......

"RV.Krishnan" <krish (AT) rsi (DOT) ramco.com> wrote

Can anyone assist in troubleshooting this code? I originally had it to move
all *.bak files from one folder to another and it worked. But now I want it
to check the file date before moving the files and if the file date is older
than 10 days then move to the other folder.
But it is not passing the file name.

' Move File
Option Explicit

Function Main()

Dim oFSO
Dim sSourceFile
Dim sDestinationFile
Dim oFile

Set oFSO = CreateObject("Scripting.FileSystemObject")

sSourceFile = "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Data\*.bak"
sDestinationFile = "C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\Oldbakfiles\"


Set oFile = oFSO.GetFile(sSourceFile)

If oFile.DateCreated < Date Then

oFSO.MoveFile sSourceFile, sDestinationFile

Else
Main = DTSTaskExecResult_Failure
End If



' Clean Up
Set oFSO = Nothing
Set oFile = Nothing


Main = DTSTaskExecResult_Success
End Function