So in my DTS task I would select the records that are => 'current max(entrydate)'? I don't want to bring over duplicates. So perhaps it needs to be...

Yes, but it will not return 1 row. Here's what I'm trying to do: Write a DTS package that will append only Inserts into a SQL table from an...

Okay another caveat, I need the record back with not only the max(id) but also the max(entrydate). How can I get SQL to return just one row, fast?

Aurora

Thanks guys, that worked like a charm! Oddly enough, I made the mistake no DBA should ever make and that is assume. Naturally I thought the index was already...

Thanks Phill, you have been a big help pointing me in the right direction. I truly appreciate it.

Thanks! But is the default 0 grabbing all it needs?

The binary file I speak of is simply the Oracle log. Is there anyway to read this so I can determine which records need to be loaded. Does...

What about when locks are configured with the default values such as this result from sp_configure 'locks':

name ...

Not sure if this is what your are looking for:

But the ODBC drivers ship with SQL Server.

If you are in SQL Server and wanting to set up the correct connection...

Hi everyone,

Me too, I would like to view the scripts. I too have a similiar situation where I am connecting to a secure FTP and pulling down a CSV...

I could certainly use either of those options, but still unsure how to tackle reading the binary file.

Ideas?

Great, but although I have written a few ActiveX task before, its never been to read a Binary file. Any advice or resources I can turn to for assistance?

Thanks...

Are you appending the data to the existing table? Or are you truncating the table, recreating it and loading it?

I agree VSS is now more intergrated with SQL server making it easier than ever to keep version control. There is another product that I believe ships with Rational...

Also, what version of SQL Server are you running? If you are running SQL 7.0, there is a known issue regarding shrinking the transaction logs in this version. ...