Hello Everyone.

I basically want to do an insert.

Here's my insert script which works when the database is empty.
In the destination table i created another index (siteid).

' Copy each source column to the destination column
Function Main()
DTSDestination("wexchid") = DTSSource("exchid")
DTSDestination("wexTitle") = DTSSource("exTitle")
DTSDestination("wexSku") = DTSSource("exSku")
DTSDestination("wexDescription") = DTSSource("exDescription")
DTSDestination("wexPrice") = DTSSource("exPrice")
DTSDestination("wexPrice2") = DTSSource("exPrice2")
Main = DTSTransformStat_InsertQuery
End Function

I don't know how to check if the DTSDestination("wexSku") exist.
If it does exist then skip that row during an insert.

If i was writing this in normal asp then it won't be an issue but i'm
struggling here.

Would it be just to write someting like this

If (DTSLookups("skuCHECK").Execute(DTSSource("wexSku" ))) Then
Main = DTSTransformStat_InsertQuery
End If


My lookup checks the destination table and then matches it with the source.

I need some help here.

Thank you

April

Yep you can certainly do that.

Have you thought about linked servers?




Allan

"Best Practice" <aprilfool2005 (AT) gmail (DOT) com> wrote

The databases are all on the same server.

When i run the package it bombs out.

I'm i missing something simple????

Please any feed back would be appreciated.

April


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

I'm having a syntax error day here...any suggestions.


' Copy each source column to the destination column
Function Main()
DTSDestination("wexchid") = DTSSource("exchid")
DTSDestination("wexTitle") = DTSSource("exTitle")
DTSDestination("wexSku") = DTSSource("exSku")
DTSDestination("wexDescription") = DTSSource("exDescription")
DTSDestination("wexPrice") = DTSSource("exPrice")
DTSDestination("wexPrice2") = DTSSource("exPrice2")

If (DTSLookups("skuCHECK").Execute(DTSSource("exSku") )) Then
Main = DTSTransformStat_InsertQuery
End If

End Function


The lookup is set to check the destination against the source.

I guess this is where my problems lies.

If "what goes in here"
(DTSLookups("skuCHECK").Execute(DTSSource("exSku") )) Then


I'm stuck any help would be appreciated.

April

If the databases are on the same server then do not use lookups.

How about you simply say

INSERT TABLE(COLUMNS)
SELECT (COLUMNS)
FROM DATABASE.OWNER.TABLE DB1 LEFT OUTER JOIN dbo.TABLE T1
ON DB1.(Id Columns) =T1.id Column)
WHERE T1.(Is Column IS NULL)

Obviously you will need to play with the syntax for your environment.
This then would site in an ExecuteSQL Task

If you did this

SELECT (COLUMNS)
FROM DATABASE.OWNER.TABLE DB1 LEFT OUTER JOIN dbo.TABLE T1
ON DB1.(Id Columns) =T1.id Column)
WHERE T1.(Is Column IS NULL)

You could use a DataPump task


You say "Bombs Out". With what error?


"Best Practice" <aprilfool2005 (AT) gmail (DOT) com> wrote