"The female application processors would also approve and change the billing address to send the bills to his wife"

And she would make sure the mistress's name somehow managed to make...

Remi,

I believe sushila was referring to Noeld's post in the Yukon Development site (the original post was from another thread where the two of you were going at each other...

This should do the trick:

Function Main()

DIM oPkg

 SET oPkg = DTSGlobalVariables.Parent

 DTSGlobalVariables("g_PackageName").Value = oPkg.Name

 msgBox("Package Name = " & DTSGlobalVariables("g_PackageName").Value)

 Main = DTSTaskExecResult_Success

End Function

Good Luck,

Darrell

I have seen the same issue but haven't researched the solution.

Sorry I couldn't give you a better answer.

Darrell

Vishal,

Take a look at this link:

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

Good Luck,

Darrell

I haven't tried that but I believe that would give you the "new" name in any log files that get generated.

Good Luck,

Darrell

Try something like this:

Create Procedure dbo.Create_Database

@DBNAME VARCHAR(50)

AS

DECLARE @SQL VARCHAR(100)

SELECT @SQL = 'CREATE DATABASE ' + @DBNAME

EXEC(@SQL)

RETURN

Shouldn't this be done client side (I know that VB has a vbProper function that would handle it)?

I believe your only option to rename a DTS package is to do a SAVE AS.

You can try this from an ActiveX Transform:

Function Main()

DIM sTemp

DIM sSource

DIM sOutput

 sTemp = "000000"

 sSource = "1234"

 sOutput = LEFT(sTemp,(LEN(sTemp) - LEN(sSource))) & sSource

 msgbox"Value = " & sOutput

 Main = DTSTaskExecResult_Success

End Function

This code would go into the ActiveX task. You will also need a connection to the database and two Execute SQL Tasks (just put -- in for the query)

Function Main()

DIM...

You can use an Execute SQL Task to drop the table and then use an ActiveX script to create an OpenRowSet query (see BOL for use) that does a SELECT...

Create your Global variables and then in the Execute SQL task key in your query, then select the Parameters option and assign them from there. Now the ActiveX script can...

If the wait puts to much of a demand on the server (I don't think it will) you could try something like this.

Create a table with three columns (one for...

I believe that if you make a few modifications to Remi's code like this:

Dim MyCmd 

Set MyCmd = CreateObject("ADODB.Command")

And do the same thing for each Dim/Set referencing the ADODB objects.

Good Luck

Darrell