Sadly, you can't use ? with like.

Put an ExecSQL task upstream that finds your table name based on the like criteria.  Dump today's...

HTH!  That looks much prettier.

just a thought...

declare @myPercent numeric(9,2)

declare @myNum int

set @myNum = 1

declare @myDenom int

set @myDenom = 0

set @myPercent = isnull((@myNum/nullif(@myDenom,0)),0)

select @myPercent

You can edit the connection timeout property in Disconnected Edit.  Right click in the white space in your package to get there.

I like the ActiveX approach and use it a...

ROFLMAO

That is exactly how I do it, but to make the coding really fast and easy, just write your precedence basis and value to globals.  Then move from the active...

You can dynamically choose to skip past the import step when it is not needed:

Use Calvin's script to evaluate the file size.  Based on that, you can choose to either...

In the future, when you schedule a dts package as a job - say using dtsrunui, simply don't check "encrypt" when you generate the command string.  Or create the string...

No, sorry, not familiar with the tool. 

Do you simply need to query sysjobsteps?  The command field has the dts run command in it.

In the DTS GUI, the package and version GUIDs are in the package properties dialog box.  You can find the package name in msdb..sysdtspackages like this:

SELECT     name

FROM         sysdtspackages

WHERE     (id = '{55521ACB-1643-45CD-B882-A6AB20FF59F8}')...

Don't forget, you can specify exactly how many rows to transfer in the transformation data task properties dialog box on the options tab.

Here...

Great tip Phill!  We have been working with SQL Server for years and never thought of doing this.  I just shared with my team.  Thanks!

You can use and refer to the DTS connection object programmatically in the ActiveX script using the DTS object model.  Once you think of it like that, you realize that...

declare @iVar int

select @iVar = ?

When using OLEDB, I get a syntax error.  When using ODBC, I get "sql statement does not contain any parameters.  How are you getting this...

Control tables are a very nice way to control execution and flow in DTS.  They can also be used to pass information to external packages.  You can also use the...