quote:

---

Please clarify re don't see all the products. When I run the sql I get one line per row in Table -...

Are you sure this the complete trigger statement?

What sets the @cName and @cType variables?

Thanks

Phill Carter

I'd go with Disabling the steps and setting the Precedence details. At least that way you can be sure that things will run in the right order.

I've had some weird...

Try this list

http://www.knowledgestorm.com/search/keyword/sql%20server%20reporting%20tools/iickwd/Sql%20Server%20Reporting%20Tools/

Thanks

Phill Carter

You could probably try an ActiveXScript in the transformation to build the output row prior to writing it to the file.

Something like,

Function Main()



Const sQt = """"...

Are you sure you have the name of the connection right?

The line

Set oConn = DTSGlobalVariables.Parent.Connections("Text File (Source)")

is looking for a connection called "Text File (Source)"....

I don't think you'll find anything that automated. Restarting the job would mean it has to finish first, either successfully or not.

If package logging has been turned on, you could...

There's nothing provided to extract any meta data.

You could put together a little ActiveXScript to extract the info from the Transformations collection of the DataPump task.

Thanks

Phill Carter

You can also execute the package using the sp_OA stored procedures as shown in the following article.

http://www.databasejournal.com/features/mssql/article.php/1459181

Thanks

Phill Carter

Instead of the Cast statement, use DateSerial. I'd also use the full 4 digit year.

So your statement would end up like,

DTSDestination("SOL_BIRTH_DT") = DateSerial( Left(DTSsource("SOL_BIRTH_DT"),4), mid(DTSsource("SOL_BIRTH_DT"),5,2), right (DTSsource("SOL_BIRTH_DT"),2))

Thanks

Phill Carter

What are you trying to achieve here? The SET statements in your example wouldn't produce anything because they are after the CREATE command.

Setting STATISTICS TIME and NOCOUNT in the query...

You would need to handle the restart point within the child packages.

Basically, if the package fails you log what step it failed at. On restarting you check if there was...

You've already got the hard part with the logical model. The Physical model is the database representation of the logical model. It defines how the entities and attributes map into...

Probably not really addressing you real problem, but based on your code, why not use a computed column for the staff_random_num column?

Then you don't need proc or trigger.

Thanks

Phill Carter

You could also use transactions within your stored procedure. That way any changes it makes will be rolled back on failure.

Thanks

Phill Carter