Viewing 15 posts - 766 through 780 (of 887 total)
Error:
"Executed as user: 123. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started: 6:12:20 PM Error: 2011-09-22 18:12:21.60...
September 23, 2011 at 9:53 am
mat.elkington (9/22/2011)
I'm attempting to run a package with a fuzzy lookup in it. This fuzzy lookup runs in debug, but it does not run in a package. According to the...
September 22, 2011 at 8:05 am
Ninja's_RGR'us (9/21/2011)
Martin Schoombee (9/21/2011)
Seems like Visual Studio has a config file for the Report Designer. I've made the change on my side, and it seems to...
September 21, 2011 at 8:58 am
I found the following: http://blog.summitcloud.com/2010/05/disable-reporting-services-data-cache-in-development/
Seems like Visual Studio has a config file for the Report Designer. I've made the change on my side, and it seems to be working thus...
September 21, 2011 at 8:50 am
You need to specify the full path of the executable, otherwise it will look in the default SQL Server file location.
i.e exec master..xp_cmdshell '"C:\tablediff.exe".....'
September 17, 2011 at 2:19 am
Sorry for jumping on this a little late, but it happens to me sometimes too. The problem is only with the report preview in Visual Studio, and I think it...
September 17, 2011 at 2:13 am
Mark Kinnear (9/16/2011)
Can someone please explain exactly how SSIS security works? I have a project that generates data into an Excel workbook to a destination on our network. I...
September 16, 2011 at 8:53 am
Ninja's_RGR'us (9/15/2011)
bestep420 (9/15/2011)
I don't know how or why but it started working all of the sudden, can't explain itSOMETHING changed. There's no luck in unchanging code ;-).
And it isn't...
September 15, 2011 at 7:25 am
fmardani-786425 (9/14/2011)
yes, there are 18 different dates. One in each record for the mydate field.
Verify that there are no data filters on the chart and that the data values are...
September 14, 2011 at 10:21 am
Hi,
It is a little difficult to say for sure without some test data, but there are some things I can point out:
1. Using the following statement as the parameter that...
September 14, 2011 at 10:06 am
fmardani-786425 (9/14/2011)
The x-axis shows date i.e. 30 jun 2010, etc...
The dataset returns 18 records and each one has a field...
September 14, 2011 at 9:46 am
Hi,
One or two things that needs to change:
Your code should look like this: Note the change in the variable/value sets.
ALTER PROC DBO.usp_ProcessClientData (@ClientID int, @ProductLine int)
AS
BEGIN
DECLARE
@PackagePath varchar(256)
,@Cmd varchar(4000)
SET NOCOUNT ON;
/*...
September 13, 2011 at 1:19 pm
john.sliwinski (9/13/2011)
I am logging the errors to a text file which display:
1. error code - the negative number I posted
2. error column - always zero
3....
September 13, 2011 at 12:38 pm
good_c_ryan_19 (9/13/2011)
I also tried to Run this package as a job on...
September 13, 2011 at 10:53 am
john.sliwinski (9/13/2011)
I am trying to load a...
September 13, 2011 at 10:46 am
Viewing 15 posts - 766 through 780 (of 887 total)