You can use SSIS package or Import/Export in SQL Server Management Studio to import Excel file into a temp table such as TMP_YTD table. Then build a query to update...

Maybe, you should provide more information:

- Structure of table

- Conditions to retrieve data (6 Input parameters)

...

I have recommendation here:

- Do you have indexes on conditions which are using to retrieve...

Maybe, the issue is in your flat file. You can create a example file with some data lines and try to test it. You should also check mapping columns from...

You can access Reporting Services Configuration Manager to check your configuration.

- Permission

- URL to access reports

...

Maybe, I use a simple query to return the expected results. Something like "priority" JOIN

CREATE TABLE #temp

(

id int,

name1 varchar(50)

name2 varchar(50)

desc varchar(1000)

)

INSERT INTO #temp

SELECT s.id,s.name1,s.name2,d.[desc]

FROM Test_Join_Source s

INNER JOIN Test_Join_Destination ...

I'm sure that with the sample data and your query. The result is always 2 records

idname1name2desc

1test1 test2 ...

To improve performance, you should limit data while inserting into temp table. It means that we only insert

ClassifiedId

,MemberId

,SubCategoryId

which match our searching condition

Then get info which we want by joining temp...

I try to test with your case

Create table

CREATE TABLE [dbo].[Test_Join_Source](

[id] [int] NULL,

[name1] [varchar](50) NULL,

[name2] [varchar](50) NULL

)

CREATE TABLE [dbo].[Test_Join_Destination](

[id] [int] NULL,

[name1] [varchar](50) NULL,

[name2] [varchar](50) NULL,

[desc] [nchar](10) NULL

)

Insert data

INSERT INTO Test_Join_Source(id,name1,name2)

VALUES(1,'test1','test2')

INSERT...

Could you tell me the purpose of this query? I'm not clear about this why you use OR condition to join 2 tables.

How to prevent it? => It means that...

Can you post error log file?

Maybe, you configured the SQL Authentication Mode in SSIS package and you used sa user.

When the job runs and calls your package, it will use the sa user...

1/ Check SQL Server service is running or not

2/ Check SQL Server Name you're connecting to. If you select Defaut Instance Name while installing, you only need to use the...

Because value of Address contains the character "," which is using as column delimiter. You must also define text qualifier with double of single quote in ssis

You should have SQL2000 Enterprise Management Tool.

- Open SQL2000 Enterprise Management Tool and connect to any SQL Database server you want (must be in 2000 version)

- Right click on Data...

1/You can build a package in SSIS (Integration Service) to do that automatically.

- Extract the group file into the folder where you want to store

- Use import/export components in SSIS...