Viewing 15 posts - 1 through 15 (of 31 total)
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.
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
February 15, 2012 at 9:53 am
http://www.google.com - that should get you where you need to be 🙂
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
January 24, 2012 at 4:55 am
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...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
January 24, 2012 at 4:09 am
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..
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
January 23, 2012 at 6:17 am
You have no null handling on your string concatenation - try adding some, and see which section is failing.
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
January 23, 2012 at 4:42 am
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.
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
January 20, 2012 at 6:42 am
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...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
January 20, 2012 at 5:09 am
Please can you post the SQL the task is executing, and the error message returned?
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
January 19, 2012 at 4:59 am
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...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 23, 2011 at 4:47 am
Post the create statements for your tables, and then we'll have a better chance of helping! 🙂
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 21, 2011 at 9:25 am
Try something like Team Foundation Server; or any of the other source control versions out there. They're invaluable.
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 21, 2011 at 8:55 am
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;...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 15, 2011 at 10:13 am
The link below should give you a good idea of how to resolve things:
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 15, 2011 at 9:01 am
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...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 15, 2011 at 8:55 am
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 using triggers...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 15, 2011 at 2:33 am
Viewing 15 posts - 1 through 15 (of 31 total)