Automate running a DDT Package


Author
Message
Cory Cookson
Cory Cookson
StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)
Group: Forum Members
Posts: 30, Visits: 416
I can see the command line for building a DDT package but am unable to locate any way of automatically running the package.

Are there command line options to the DDT to run the package?

Thanks,

Cory

Cory Cookson

Software Developer

Occupational Health Research

Ivan George Borges
Ivan George Borges
Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Cory.

Do you mean to run the DDT to deploy the structures and data from the command line? Not that I know.

But you can create a deployment application very easily and use any DDT package to be deployed. Have a look at the samples, under the DatabaseInstallerSample to give you some ideas.

Cory Cookson
Cory Cookson
StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)StrataFrame Beginner (30 reputation)
Group: Forum Members
Posts: 30, Visits: 416
Thanks for the Info Ivan Smile

Cory Cookson

Software Developer

Occupational Health Research

Ross L Rooker, Sr.(1)
Ross L Rooker, Sr.(1)
StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)
Group: StrataFrame Users
Posts: 50, Visits: 163
Is the DatabaseInstallerSample supposed to  compile error free? The one in the StrataFrame C# samples?
StrataFrame Team
S
StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
It should.  Is it giving you a bunch of errors about "Table is not defined" and "Database is not defined?"  Stuff like that means you don't have the property SMO assemblies available on your computer.
Ross L Rooker, Sr.(1)
Ross L Rooker, Sr.(1)
StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)
Group: StrataFrame Users
Posts: 50, Visits: 163
I am getting 1 error: Could not find 'Sub Main' specified for Main method.

The SampleDataInstallerClass rebuilds fine.

When rebuilding the SampleInstallerExecutable gives the error above.

The AppMain.cs has the following line in it:

[STAThread()]public static void Main()




So I am not certain what the error is about?
StrataFrame Team
S
StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Ross, you might have to change the "Startup Object" that is located on the Application tab of the project properties.  You should be able to select Program.cs in the combo box or something like that to set the entry point of the application.
Ross L Rooker, Sr.(1)
Ross L Rooker, Sr.(1)
StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)
Group: StrataFrame Users
Posts: 50, Visits: 163
Perfect! That worked.
Ross L Rooker, Sr.(1)
Ross L Rooker, Sr.(1)
StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)
Group: StrataFrame Users
Posts: 50, Visits: 163
That worked. Now my next issue: The DT package creates tables, views and also a UDF that 1 of the views refer to. The view and the UDF work perfect in SQL so there is no issue with Syntax of the View or UDF as far as SQL is concerned. But when I use the DT to dun the package I get an error when the View is being created:

Creating failed for view, Sql Exception: funcConvertVersionNumber is not recognized as a built in function name.

I played around with changing the "priority" of the UDF to be less than and also greater than the priority on the view with no luck.

Here is the view:

SELECT vc_int_codeid, vc_vcr_version, vc_dte_entry_date, vc_bit_mandatory, vc_vcr_ftp, funcConvertVersionNumber(vc_vcr_version) as VersionNumberValue FROM dbo.tblVersionControl




Here is the UDF as it appears in the dt:

(@VersionString varchar(30))
RETURNS decimal(20,3)
AS
BEGIN
 DECLARE @strVersionReversed varchar(30) -- holds reversed version number
 DECLARE @strVersionNumWhole varchar(30) -- holds whole number of converted version number
 DECLARE @strVersionNumDec varchar(20)   -- holds decimal number of converted version number
 DECLARE @decVersionConverted decimal(20,3)    -- holds converted version number
 
 -- reverse the version string
 SET @strVersionReversed =  REVERSE(@VersionString) 
 
 -- Separate the revision number from the major, minor, and build number
 SET @strVersionNumWhole = SUBSTRING(@strVersionReversed, CHARINDEX('.', @strVersionReversed) + 1, 30)
 SET @strVersionNumDec = SUBSTRING(@strVersionReversed, 1, CHARINDEX('.', @strVersionReversed))
 SET @strVersionNumWhole = REPLACE(REVERSE(@strVersionNumWhole), '.', '') -- reverse to proper order AND remove decimals
 SET @strVersionNumDec = REVERSE(@strVersionNumDec) -- reverse to proper order
 
 SET @decVersionConverted = CAST(@strVersionNumWhole + @strVersionNumDec as decimal(20,3)) -- build decimal value of version number


 RETURN(@decVersionConverted) -- return the number value
END


Why is this erroring?



Ross L Rooker, Sr.(1)
Ross L Rooker, Sr.(1)
StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)StrataFrame Novice (50 reputation)
Group: StrataFrame Users
Posts: 50, Visits: 163
Not sure what I did but after rebuilding the package it now works.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search