At a guess, I would say that as sp_generate_inserts is in the master database, it is looking in there (i.e. master) for a table.

You should qualify the table name with the...

What you are asking for is conditional processing based on a return value rather than fail a step.  There was a post on here somewhere (can't find it at the...

Whenever I have had to do this sort of thing, I have always used an empty template of the excel workbook (often there are macros or other worksheets which have...

Yes:

if exists (

select filename

from tableA

where Filename = 'SomeFile') begin

 

raiserror('File found', 16, 1)

end

J

If you generate the execution plan (paste the code into Query Analyser and press CTRL-L or select Query and then Display Estimated Execution plan on the menu), it will tell...

A better way would be to use a function to separate the text column by the delimeter so that you can avoid exporting directly.

CREATE FUNCTION dbo.FAQ_ListToSingleColumn

(

    @cslist VARCHAR(8000)...

One way of doing this is as follows:

SELECT id, resulted_test_desc, result_value, units, update_date

FROM dbo.lab_result LEFT OUTER JOIN

dbo.mpi ON dbo.lab_result.blind_key = dbo.mpi.chart LEFT OUTER JOIN

dbo.mpi_xref ON dbo.mpi.chart = dbo.mpi_xref.blind_key

WHERE resulted_test_desc =...

So why don't you convert the list of values from your application into a table and then use this through an inner join?

See http://databases.aspfaq.com/database/how-do-i-simulate-an-array-inside-a-stored-procedure.html for details - my preference would...

You will have to use a left outer join to ensure that you get all the categories from FDIS_CLAIM:

SELECT distinct

substring (fdis_claim.claimset_id, 1,8) as "DATE",

CASE

 when substring (fdis_claim.claimset_id, 1,8) =...

I guess that if you connect to the TRANSROM server through Query Analyser you have no problems accessing the source table?

If so, then I can only imagine that there is...

I'm not exactly sure.

I think you can connect to an ODBC database within ActiveX which would allow you to execute queries (check exists, update or insert). 

Alternatively, you could have...

If you use 3 level naming (database.owner.tablename) then it will not be a problem which connection you use.  If the tables are on different servers or instances on the same...

Personally I would not do the upsert (update/insert) in ActiveX because it is row by row processing and you may have performance problems.

A better solution, IMHO, would be to load the...

What you will need to do is to create one server connection per task - if you want to run 4 tasks in parallel you will need 4 separate connections...

Why not use BULK INSERT? It is essetially BCP but runs as T-SQL so you would not be running a script - just a 'normal' SQL statement.

J