Did you by chance run a registry cleaner recently?  If so, please post which one so that others do not have this same problem.

-Mike Gercevich

You need to define you precidence to be "On Success" from your Transform Data Task to your Execute SQL Task.  If you want several Transform Data Tasks between S1 and...

Can you use something like this?  This could handle both unknown new requests as well as incremented sequence requests.  The @SequenceNum is returned as an output param. The Request_ID is...

Is there an error message? 

Is the Form showing up at all, but minus this textbox control?  If so, this control is derrived from the Windows Common Controls found in...

Change the line:

Set objShell = WScript.CreateObject( "WScript.Shell" )

 to

Set objShell = CreateObject( "WScript.Shell" )

-Mike Gercevich

The service that your scheduler is running under does not have permissions to the UNC path.

-Mike Gercevich

Can you view the package tasks and connections in Disconnected Edit?

If not, is there and older version saved in the Package History to hopefully recover most of your original package...

Since you are already shelling out to the command prompt twice during every loop of your package iteration... Maybe you could just code all your logic in a simple Visual...

Change both "22" type values with a "3" for a type Integer.

-Mike Gercevich

Use a workflow Active-X script on your SQL Task (task 2).  Check a global variable set in task 1.  If the vaiable is set have you Main function execute the...

Use a workflow Active-X script on your SQL Task (task 2).  Check a global variable set in task 1.  If the vaiable is set have you Main function execute the...

rsharma,  Great answer.. Thanks for posting this; I was not aware of this. -Mike

I'm not quite sure of what you are asking here... If you are asking how to pass a global variable to a stored proc that excepts a single parameter, @HeaderID,...

OK... If you really cannot find a better way of doing this... (like calling a VB Console App that does it much cleaner and faster, or even calling a vbScript...

ALWAYS trim your data prior to an Insert or Update.  Some day, for some reason, Someone WILL absolutely write a procedure that does the following:

SELECT * from MyTable WHERE LEN(Column1)...