No real risks as long as you choose the correct Execution Policy for your environment.

dlangschied (2/27/2013)

---

I am using the DTS Wizard. I am pulling in the worksheets from Excel and the Wizard is assigning fields by column and then is some how setting...

What method are you trying? Please post the code and a sample Excel file so we can recreate the problem on our side.

Yep.

If that's the case, why when dealing with Clustered instances of SQL Server do we have...

Excellent! That is how the GAC is supposed to work. Happy to know you got it sorted. Thanks for posting back.

SQL also will the DTC if you try using explicit transactions with Linked Servers. I also use it with SSIS transactions, not technically the database engine but another use of...

If you had a large CPU workload in the first place the worker threads used by the additional mirroring sessions (not negotiable) could have pushed you beyond a tipping point...

When the package runs on the server it does not have access to your drives. Does D:\MyFiles exist on the server?

If you want more help zip your SSIS package and...

It sounds related to a mismatched SID between the Server Login and Database User. By any chance was the database in question restored to this server from a backup taken...

What changed? Your last post said error code 9, but this post says exit code 1. Looks like you're calling a different exe now.

What mainframe? Is that just a job...

You'll need to use an Expression. In the Variables window, click on the Variable in question and hit F4 to bring up the Properties for that Variable. Set EvaluateAsExpression to...

The query will scan every row in the table unless the column happens to be the leading column in an index. Scanning large tables can impact performance. You may want...

Can you please explain your reasoning a bit as to why you think a virus huard might help...

hsmanandhar 33101 (2/21/2013)

---

I solved my issue.

Steps I made for Job run successful :

Create a Credential in SQL Server with the windows User Name.

Create Proxy with this Credential.

Run SSIS with Proxy.

This...

Are you saying that you are developing in BIDS on the same machine where SQL Server Agent is running? What account is the SQL Agent service running as? Log into...