Sounds like your package has been saved wth 'EncryptSensitiveWithUserKey', and produced by another user.

Try changing the package properties, saving again, and re-running the package.

http://www.google.com - that should get you where you need to be 🙂

Hi Jason,

How did the package perform when run from the command line?

There are overheads associated with running packages from BIDS and dtexec which will impact performance. Before you throw in...

Try adding the package to an agent job, and running the agent job.

Executing it using dtloggedexec

http://dtloggedexec.codeplex.com/

might shed some light on things..

You have no null handling on your string concatenation - try adding some, and see which section is failing.

It'd be simple enough to use the results of

sp_linkedservers

to return a list of all linked servers, and then loop through each server dynamically to update a specific property.

Why do you need to execute these in a batch file?

Perhaps SSIS might be a better solution?

For the sake of simplicity, you may want to nest your stored procs (not...

Please can you post the SQL the task is executing, and the error message returned?

I'm not totally clear on what you're trying to achieve here. If you're after a running total, how about this:

;With CteCumulativeSales

as( select *,

row_Number() over (partition by...

Post the create statements for your tables, and then we'll have a better chance of helping! 🙂

Try something like Team Foundation Server; or any of the other source control versions out there. They're invaluable.

Within your datasource (assuming you're using an OLE DB source), set the data access mode to "SQL Command". THen use the ? symbol to indicate where the variable will appear;...

The link below should give you a good idea of how to resolve things:

http://decipherinfosys.wordpress.com/2008/03/26/running-parameterized-sql-commands-using-the-execute-sql-task-i/

Try this:

http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx

Essentially, you:

1. Pass the values you want to loop through into a full record set

2. Map the record set to a variable

3. Reference the variable in your for each...

Depending on the version of SQL Server you are using, there are a number of options (after the fact):

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

You may also want to consider Change Data Capture, or...