hi,

i think that in SQL 2008 R2 the compression is now included in Standard version also.

Yaron

hi,

in Express managment you cann't edit DTS packages

the easyst way to do it (as far as i know )

is to install the Managment studio and the Visual...

hi,

do you use scripts ?

what other components do you use ?

is it One package or all of your packages ?

what version do you have ? (with SP )...

hi ,

did you try to rebuild indexes for the database

sometime when the indexes are fragmented , SQL try to get data directly from the table and you will get...

hi,

what you are asking cannot be answered in a forum

the easyest way to tart is to use the tutorials in the SQL help

this will explain to you how to...

hi,

Can you be more spesific

how do you backup the database ?

what the error message of the tool ?

Yaron

hi,

you should create a new SSIS package and use Export Column component in the data flow tab

to export the images to file.

yoo can do it in one phase both...

hi,

the problem is that you have to reindex you indexes

if you have a standard version then use the maintancce tool to rebuild the index

other wise you have...

Hi,

Your question is too complex to answer in a forum ,

i recommand you to install a SQL Server 2005 Trail version

(Full package ) and then in the book...

hi,

you should use this

SELECT COUNT(RecordNumber) AS TotalRentalsForMonth FROM RentalHistory

WHERE TransactionDate BETWEEN DATEADD(M, -1, getdate()) and getdate()

Year and Month return integer and putting them with comma between

will result an...

hi,

there are some methods to do it but i think the easyest way

is to use SQL Server agent

and create a new task

HTH

yaron.

Hi,

the DTS is from SQL 2000 client tools

in SQL 2005 this tool was replaced by the Integration service

and is not supplied with the express version

if you...

hi,

to use balk insert in OLE DB destanation

please use the data access mode

the "Tabe or view - fast load "

that would do .

Yours

Yaron.