You could use a derived column task, to change the field from the datasource to match the field in the data destination.

I'm guessing you mean VARDECIMAL.

Google is a wonderful website:

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/11/13/enabling-vardecimal-storage-format.aspx

🙂

Looks like you've got it covered 🙂

Does it take 9 minutes to select it in management studio, or nine minutes to open the report in SSRS?

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...

Hi,

Are you using variables for the...

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...

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?

Hi vkundar, can you show us the query you are using to fetch the data? (The one that's taking long)

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...

This link might assist you: http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic16744.aspx

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...

Nevermind, I found it... 😀

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...

Re-installing worked just fine. 😉