It seems like your userid  does not have privileges to login to the sever.

make sure that callcentre\guest has admin privileges on the box

-Meghana

I am not sure if you can do that. When you restore from the back up file , it would ask to overwrite the existing DB if  the db with...

It came down to 12 minutes for the query i took example of

Actually this code was written way back in year 98. I am actually asked to tune the...

Thanks your suggestions helped in optimizing many other queries

yes the wrkaccountingdocument has following non clustered indexes

Idx1  on columns  (AccountingDocumentNbr, AccountingDocumentTypeCode, MSGLCompanyCode, FiscalYearNbr, PostingDate)

idx2   on columns  (AccountingDocumentNbr, FiscalYearNbr, MSGLCompanyCode)

idx3 on columns (InterfaceReferenceKeyId, InterfaceReferenceCode, AccountingDocumentNbr, FiscalYearNbr, MSGLCompanyCode)

please find the...

If you dont want double apostrophe and want only a single apostrophe  you can set the quoted_identifier off  and get the required results

following is what you can do

SET QUOTED_IDENTIFIER...

Syed

Also try to write your error rows  to an exception file  so that you can analyse if the problem lies with your source file.

you can do this  by doing...

Dinuj

If you want the view in the source to be created as a view in destination db , use the option

"copy objects and data between SQL servers" instead of...

Yes Dinuj, Using this option "Copy table(s) and View(s) from source database", the views in the source database get created as tables in the destination database.

Regards

Meghana

It seems as if you do not have permission to open the csv file. Is it on a different fileshare for which you do not have access to.

Are you scheduling...

Your question is not clear.

Do you match NPA, NXX from the Numbers table to some other table ?

Regards

Meghana

The output parameter would show ReturnValue (without @) because you have selected it that way in your SQL task.

I mean

Select @returnvalue AS ReturnValue

If the following is exactly what...

if it is for a single table you can use this

sp_spaceused <tablename>

DBCC SQLPERF(LOGSPACE)

GO

DBCC SQLPERF(Logspace) can be used to monitor the amount of space used and indicates when to back...

You Can do something like this using an activex script

Function Main()

Dim oPKG

Set oPKG = DTSGlobalVariables.Parent

 Dim oFSO

 Set oFSO = CreateObject("Scripting.FileSystemObject")

 'vars for date calcs

 dim dt, sdt

 dim dtyr, dtm, dtd

 dim dtlimit

 'filename

 dim filename

 dt...

you can do something like this

where Description LIKE '% arco%' or Description LIKE '%arco %'

HTH

Meghana