Viewing 15 posts - 46 through 60 (of 87 total)
You could use a derived column task, to change the field from the datasource to match the field in the data destination.
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 17, 2009 at 1:08 am
I'm guessing you mean VARDECIMAL.
Google is a wonderful website:
🙂
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 14, 2009 at 1:00 am
Looks like you've got it covered 🙂
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 14, 2009 at 12:02 am
Does it take 9 minutes to select it in management studio, or nine minutes to open the report in SSRS?
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 13, 2009 at 11:56 pm
Hmmm, can you give us an example of the data in the tables for 1 of the products?
First thing I would do, query the tables directly to see if...
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 13, 2009 at 11:53 pm
Warning: 0x80070003 at Detail, DTL SOURCE [2895]: The system cannot find the path specified.
Error: 0xC020200E at Detail, DTL SOURCE [2895]: Cannot open the datafile "".
Hi,
Are you using variables for the...
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 13, 2009 at 11:34 pm
Ok, I tested it both in SSIS and SSRS. SSIS works fine, it returns the result you expect. And as you say, SSRS doesn't work... Have you tried creating a...
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 13, 2009 at 9:06 am
KSB, are you able to execute any commands using xp_cmdshell? Are you getting this message everytime you execute a command or only on the BCP Job?
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 13, 2009 at 4:29 am
Hi vkundar, can you show us the query you are using to fetch the data? (The one that's taking long)
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 13, 2009 at 2:54 am
I stand to be corrected on the following, but I believe the maximum memory amount on your server settings should be about 2 Gigs less than the total memory on...
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 13, 2009 at 2:49 am
This link might assist you: http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic16744.aspx
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 13, 2009 at 2:35 am
Okay, for those who would like to get the info here is a step by step:
1. Open Management Studio and connect to the server you require the info from.
2. Expand...
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 12, 2009 at 8:39 am
Nevermind, I found it... 😀
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 12, 2009 at 6:23 am
Hi Guys,
Similar problem here, I need to find out if the database logs will indicate that a database has been recovered and I need to show the log as proof...
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 12, 2009 at 6:14 am
Re-installing worked just fine. 😉
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 11, 2009 at 8:16 am
Viewing 15 posts - 46 through 60 (of 87 total)