A quick question, does the out of box FTP Task support secure FTP transfers? If not does any one know of a (free) third party FTP Task that does?

The mailbox errors are coming from this SSISOpsNFObj_SendAlert, which is a part of this Pragmatic Works Auditing Framework, called BI xPress, we insert into our packages. That is the...

Thanks Koen, I looked in all the tabs of the job step and for some reason did not see that check box.

Thanks guys for the help...

A developer here showed me a trick in Notepad++. You can take your query paste into Notepad++, make sure it is highlighted, go to the...

Bob, Thanks soo much for the query, this will definitely come into handy...

From the application side of it, when the application times out is there any way to automatically kill...

Gaurang, Thank you very much this works perfectly. Thanks to everyone else for the replies.

Thanks gentleman for the replies, but using what you guys suggested is not what I am looking for. I am still getting an empty set back.

My goal...

Thanks for the reply Jeff. I completely understand what you are saying. I have a PM that thinks there are un-needed triggers in a database that are causing...

Thanks everyone for the replies, I have been Googling this as well and think I should be good to go. My only other problem is that my "Advanced" tsql...

Ok, since I've posted this, I have found that they DBA before me did have jobs set up to check integrity, optimize the DB, re-index the tables, and update the...

Jason, I will get this information for you, but in the meantime...what does it mean when I look at the Activity Monitor at the time of the lock for my...

Hey Jason,

Thanks for the reply, I am a little know to this site and SQL server as a whole. Are you asking me for my exact SQL queries? ...

Thanks Henry for the reply...

My problem end up being that I installed a Third Party "Task" on my local machine, used it in my package, ran successfully from my local...