If I use NOT Exists, I get SQL-DMO(SQLState: 42000) SQL error 156: Incorrect syntaxt near the keyword Exists.

If I use FROM       PropMaster A Where A.ListingID NOT IN ( Select LSID...

Thanks!! That worked!

JN

Hello,

I am trying the SP method and facing an INSERT issue...

Why does the following Insert INTO statement inserts NO records?

***********************************************

INSERT INTO Prop

                      (ListingID, Address, City, Zip, ListPrice, PropCID, PropTID)

SELECT

LSID, B.Address, B.City,...

What happens if your package fails before completion and doesn't execute the DROP ?

Solution is simple. I DROP the table in the same script that creates the table so every...

Instead of Truncating can't I just DROP the table after I am done prossesing the values out of it? This way I create the table/indexes each time I impor the...

Thanks, Phil, for your response and suggestion.

If there are different ways to do this, please also post it here otherwise, I will use the way I was already thinking about...

Nikki,

Following is part of my code copied from ActiveX Transformation. You can modify it to your needs. Hope it helps you.

'**********************************************************************

'  Visual Basic Transformation Script

'************************************************************************

'  Copy each source column to...

Thanks for the replies.

If I put Default = NEWID() in the table desing then it works fine. I insert other records and a GUID is generated using NEWID() for default values...

I called Microsoft with this and was told this is a bug in DTS and that there is no fix at the time, but following is the work-around they offered:

cast('\\nat1-iac5-sql\k$\production\output\client\'...

Just wanted to give an update...

I was able to solve the process commandLine issue I posted in my 2nd to last post. Basically, I am supplying all the values (for the...

That's very strange, because the following statement works fine:

Select '\\ghf1-ndc8-sql\l$\production\output\lob\' + convert(varchar(6), convert(varchar(6), getdate(), 112) - 1) + '\LOB_CF_forDrilldown_All_' + convert(varchar(12), getdate(), 112) + '.zip \\ghf1-ndc8-sql\l$\production\output\lob\'...

Nicholas,

I have a couple questions...

First, when I execute the dynamic task to populate the values of the variable and assign them to the Execute Process Task, both Win32 Process Task...

I do have another question, for Nicholas or anyone else...

In the same DTS package, I have an Access connection with DB location where the output files are exported. This DB...

Yeah, I figured it out after a few trial & errors. Thanks much for your help and suggestions.

JN

I made the following changes to the statement:

Select '\\ghf1-ndc8-sql\l$\production\output\lob\' + convert(varchar(6), getdate(), 112) - 1 + '\LOB_CF_forDrilldown_All_' + convert (varchar(12), getdate(), 112) + '.zip \\ghf1-ndc8-sql\l$\production\output\lob\200406\LOB_CF_forDrilldown_All.mdb'

I get this error:

Syntax error...