Just as a side note to the opinions above, you should be aware, that Profiler can be quite resource intensive. If this banking application is stable and you set profiler...

Hello,

This is my take on it, first add this to your INSERTS:

INSERT INTO [dbo].[Test]([SiteID],[Priority],[Value]) VALUES(3,1,0.00)

INSERT INTO [dbo].[Test]([SiteID],[Priority],[Value]) VALUES(3,2,16.00)

INSERT INTO [dbo].[Test]([SiteID],[Priority],[Value]) VALUES(3,3,25.00)

The above code ensures that you have a Priority =...

I don't think you can have a ROWTERMINATOR = '', shouldn't it be ''? Or, maybe ROWTERMINATOR = '''+CHAR(10)+'''? BOL, has a pretty comprehensive page of info on BULK INSERT.

You know, people are going to think I'm a freak, but I really love my job, optimisation is one thing I love most about SQL and I really wish I...

Not sure what the question is here, what do you want? Do you want us to tell you how to format the result in SSRS? Or, are you asking why...

Hi,

Wont all of your "Common Objects" be used in creating the letter anyway? The only thing that might differ is the context of the message you are sending. What I'm...

I have to agree with everybody here. Browsing to such a low level is not what a cube is meant for. Rather create a stored proc that queries the data...

I guess the reason why I asked you the last question is because I was hoping it was possible to add the SKU field and searchstring field to your Manufacturer...

I have pretty much the same idea as kevriley

declare @invaliddate varchar(6)

set @invaliddate = '081709'

declare @validdate datetime

select @validdate = convert(datetime, '20'+right(@invaliddate,2) + '-' + left(@invaliddate, 2) + '-' + substring(@invaliddate, 3,2))

print...

I'm not really sure. But I'm thinking this is a web dev thing. I think (but I'm probably wrong) that you'd need to create 2 reports, exactly the same but...

Hi, are the reports getting data from a cube or from tables in a db?

Hello,

Variables are your friend. Assign the command line args to one or many variables(depending on circumstances) in the script task.

To run the batch file, you can use a execute...

There are many ways to skin a cat, have you thought of using vbscripting to update the sql database directly at the click of a button. You could build a...

Is SKU unique to Product ID, one to one match?

Harry, I would change the data type from decimal to integer for your destination column. Then in SSIS, use a derived column task to convert your distribution_type to an integer,...