Again?

EricEyster (3/18/2014)

Stuart Davies (3/18/2014)

BWFC (3/18/2014)

SQLRNNR (3/18/2014)

EricEyster (3/17/2014)

Eric M Russell (3/17/2014)

JAZZ Master (3/17/2014)

Ed Wagner (3/17/2014)

Cheesemaker...

Hot Chocolate

I like to use sp_who2 - get most of the information I need from that.

Gerard,

Take a look at this link and see if it helps.

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

Good Luck,

Darrell

If you prefix the value with a single quote/tic Excel will recognize that you intend the value to be text instead of numeric. I beleive that the older versions of...

Does the end table double as a printer then???

Perry,

you have nailed it pretty much on the head. There are (in several cases at least) multiple options of "dirived" scripts and I do need to be able to determine...

Try something like this:

if exists(SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS

 WHERE TABLE_NAME = 'RESULTS'

 AND COLUMN_NAME = 'TOTAL_VOTES')

BEGIN

        SELECT 0

END

ELSE

BEGIN

 exec('ALTER TABLE [dbo].[RESULTS] ADD [TOTAL_VOTES] int not NULL DEFAULT (0);')

 exec('UPDATE RESULTS SET TOTAL_VOTES = (OPTION1 +...

Take a look at this link. They have a sample on disabling steps.

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

Good Luck,

Darrell

Another trick I have used is to do a MoveLast in the RecordSet and then check the RecordCount then finally do a MoveFirst.

Good Luck,

Darrell

Another option would be to use a Dynamic Properties Task to set a Global Variable to a Count or Return value from a Query. Then in an ActiveX Task check...

The only thing I can think of is to save the packages as VB and then print out the BAS file from there.

Good Luck,

Darrell

Rob,

If you right click in the designer window and chose the Disconnected Edit option you can copy the description of each task and step to the name field under Tasks and...

You could try the bulk copy and set the codepage there.

Also,

If you have Visual Studio installed you can put a STOP command in any ActiveX Script and it will prompt you for debugging (it is well worth trying to get...