Hello Hari Narayan Sharma

I got the following error message in BIDS:

Cannot read the next data row for the data set reports_test.

The conversion of the nvarchar value '505555555555' overflowed an int...

Thanks Hari Narayan Sharma

I got the navigation alright, but i am having problems with the retrieval of the requested records based on the OrderID, when i click an OrderID, it...

Thanks Guys for looking at it, but i got it fixed eventually after doing a little more digging, and i ended up using the following script:

USE DB_Reporting

SELECT T_OrderLine.StockID, T_OrderLine.Quantity AS...

Thanks Guys for looking at it, but i got it fixed eventually after doing a little more digging, and i ended up using the following script:

USE DB_Reporting

SELECT T_OrderLine.StockID, T_OrderLine.Quantity AS...

Hey Guys

Thanks for all your replies which has been very helpful, but when I tried it this way i got the following message, can anyone tell me what I doing...

Hi

Have a look at the following link:

http://community.discountasp.net/default.aspx?f=16&m=8808

That should shed more light on what you are doing wrong

Also you will be given the chance to choose which db table you want to transfer into the destinated table or db

Open a SSIS project, create a new package, right click on "SSIS Package" and click on "SSIS Import/Export Wizard".

Once you have it started the wizard you can then select your...

To create a simple data transfer, I will advice you to use the SSIS import/export wizard of version 2005, and save it as a SSIS package which can reused

Yeah, thats the answer to my second question, permission are affected when a database name is renamed.

Thanks Gail

It basically means that db's ment for read only purposes can be cmpressed using the NTFS compression feature.

Which also means that it wont be a good idea to use...

I created the script with sql back up, but when i try to insert that sccript into a maintenance plan with SMS, there is no option.

Like i said the ability...

I agree with you Ramon, but the problem with the maintainance plan is that it wont enable me to encrypt the db backup when completed?

There is a possibility of the backup job running concurrently with another process, I'll suggest you use filemon or ProcessMonitor, to find out what process is obstructing the backup.

There is...

If you created a job to back up ther db's with a third party application; it is likely that the failed job, has logged an error log, SMS will not...