Viewing 15 posts - 5,371 through 5,385 (of 7,187 total)
You can specify in your package at design time which configuration filter to use. If you want to specify a different one at run time, I don't know how...
May 19, 2011 at 8:31 am
If your parameters are stored in a table that looks like the [SSIS Configurations] table that is created when you enable package configurations for a SQL Server table, then you'll...
May 19, 2011 at 6:28 am
Since all those rows are from the same date, how do you decide which order they are in to calculate the running total? Please provide full table DDL (including...
May 19, 2011 at 4:44 am
Where is the drive to which you are backing up (D) - on your office server or on the SQL Server? If it's not on the SQL Server then...
May 19, 2011 at 3:37 am
Milda
If you have enabled package configurations in your package then those "parameters" should be passed in automatically whenever the package is loaded.
John
May 19, 2011 at 3:27 am
Make sure your SQL Server service account and/or SQL Server Agent service account have write access to the location to which you are trying to back up.
John
May 19, 2011 at 3:24 am
When you set up the trace, you need to make sure that the Audit Login Failed event is included.
John
May 17, 2011 at 3:23 am
Your best bet is to run a trace, either server-side or through Profiler. Make sure you capture the Application column (I think that's what it's called). How helpful...
May 16, 2011 at 3:54 am
Richard Williams-416852 (5/16/2011)
Only in IT could being a decent human being be described as "soft skills" 😉
Point taken, Richard, but I don't think it's only in IT:
http://en.wikipedia.org/wiki/Soft_skills
John
May 16, 2011 at 3:50 am
SanDroid (5/13/2011)
John Mitchell-245523 (5/13/2011)
Koen Verbeeck (5/13/2011)
Nils Gustav Stråbø (5/13/2011)
False, since they can be a mixed extent (or even an extent that has not...
May 13, 2011 at 7:23 am
You'll need to select the distinct values and join the result set back to the original table in order to get the value for name. You'll need to decide...
May 13, 2011 at 4:46 am
Koen Verbeeck (5/13/2011)
Nils Gustav Stråbø (5/13/2011)
False, since they can be a mixed extent (or even an extent that has not been allocated). Perhaps...
May 13, 2011 at 4:11 am
Look up the syntax for bcp - it needs to take a query that returns a result set. ALTER INDEX does not do that. Therefore your only option...
May 13, 2011 at 1:34 am
Looks like occasional network problems are preventing your PULSE server from being reached - either that or something is wrong with the server itself.
John
May 12, 2011 at 8:53 am
If I'm understanding you correctly, I think you need to use sqlcmd instead of bcp. And take the @Command outside the inverted commas in the way that I showed.
John
May 12, 2011 at 8:51 am
Viewing 15 posts - 5,371 through 5,385 (of 7,187 total)