Jeff, stop interfering in SSIS...

In the Script Task editor, set the package variable that you want to read in the read variables, and the one you want to set to 1 at the write...

If found somewhere on the web that the "Unable to generate a temporary class" can occur if the account doesn't have create permissions on the windows temp folder.

So maybe you'll...

Yes, you can script it out using the dtutil utility.

http://msdn.microsoft.com/en-us/library/ms162820.aspx

Double post, no replies please.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1079388-148-1.aspx

Does the SQL Server Agent user account have all the necessary permissions to connect to the instances and perform the tasks you implemented in the SSIS package?

Isn't that rather a personal question? How can someone know if BI is useful for you?

If you mean: can I build a career out of SQL ServerBI, than yes, you...

Regarding the Kimball SCD component, did you install it on the server?

Regarding the Excel connection: the JET OLE DB provider only works with 32-bit, so you'll need the run the...

Very interesting question, thanks.

How exactly are you scheduling the package in the SQL Agent job?

Are you using a Integration Services jobstep?

Nice question, thanks.

Are you sure you have permission to deploy to the server?

If you are connecting with a named instance, the url should have the following syntax:

http://myServerName/ReportServer_myInstanceName

opc.three (3/14/2011)

---

You can achieve this by using the Derived Column Component to add a blank column to your data set and then using a "Transformation Script Component" to populate...

Is the Reporting Services service up and running?

Are you connecting to the default instance or a named instance?