balasach82 (2/13/2013)

---

My database files are in 1 drive. My database has grown huge andwill keep on increasing in size. To better utilise the disk space and to manage the db,...

Kevin Drysdale (2/13/2013)

---

Running SQL Server 2008 R2.

I have a rather large table (122M records) and I need to add a new column - not just to the end, but nestle...

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?