Ahh, missed which Forum we were in. Cheers.

You could also try reverting it back to an SSIS Step Type and on the Execution Options Tab checking 'Use 32 bit runtime.' The requirement to pass the uid and...

Agent Jobs are not built to generate popups on user's machines unless you consider NET SEND an option. The overall point however is that Jobs run on servers. If there...

kingdonshel (2/13/2013)

---

Hi opc.three, the truth is your code makes no difference the code works in the same way with or without your code as long as the file path is...

Welsh Corgi (2/13/2013)

---

opc.three (6/6/2012)

---

Win32_Volume is more appropriate in some server environments. I use Win32_LogicalDisk in this environment as Win32_Volume is not a class on all the servers that I support....

Just confirming that you can run Winzip from the command line directly, or did you mean when you run winzip that it was interatively?

Try stepping through the code by setting a breakpoint and running the package, see what the variable contains before evaluating the IF.

64-bit workstation? Make sure your Project property Run64BitRuntime is False.

Try this instead, changes bolded (edit: and underlined):

[font="Courier New"]

Public Sub Main()

        'MsgBox(Dts.Variables("Username").Value.ToString)'

        Dim myHtmlMessage As MailMessage

        Dim mySmtpClient As SmtpClient

        'Dim vars As Variables'

        Dim mailAuthentication As System.Net.NetworkCredential

        mailAuthentication = New System.Net.NetworkCredential(Dts.Variables("Username").Value.ToString(), Dts.Variables("Password").Value.ToString())

        myHtmlMessage = New...

Enabling a Trace Flag is not the same as running a Trace. If you do not have a deadlock graph and you cannot enable the Trace Flag and the trigger...

Is the process running under your Windows security context when run through the Execute Process Task, i.e. through BIDS or SSDT, or is this error coming from an unattended process...

If you meant you want to install software so you can develop SSIS then you can attain that by running setup.exe from the SQL Server installation media. If SQL 2005...

:ermm: Did you try the code PMwar posted?

Can you post the deadlock graph?

If you do not already have one captured enable trace flag 1222 and then one occurs again you can retrieve it from the SQL Error...

david.ostrander (2/13/2013)

---

Hello -

Developers at the company I work for want to access one of our databases to create an iPad app for entering your timecard. I have a copy...