Never mind the last question, found it here:

http://www.sqlservercentral.com/articles/Administering/changingroguedatabasecollations/994/

Dan

Hello all.

The link above:

http://www.sqlservercentral.com/columnists/mpearson/changingroguedatabasecollations_printversion.asp

does not work. I am interested in seeing this document/column/white paper if it still exists on the SQLServerCentral site. Can someone please tell...

Matte,

I recently had the same problem with a script similar to yours:  Oracle OLE DB connection, Transform Data Pump task, to SQL Server.  It ran fine when I ran it...

To Anatol -- I finally got some time to implement your suggestion above.  It is working almost flawlessly.  I believe the problems (which required the "almost") are due to what...

Thanks for the clarification.  I understand how your suggestion is different now.  I will give it a shot and let you know.

Thanks,

Dan

Anatol,

Thanks for your suggestion.  I think that's what I'm trying to do.  I plan on getting that ActiveX script working within a DTS package and then schedule that job.

Unfortunately, my...

I found this thread because I was searching for something that would help me with the use of date parameters in the SQL Query section of the source tab of...

Andy,

Thanks for the response. I was in meetings most of the day yesterday.

The log doesn't say anything extraordinary, just that it is running xp_qv from xpsqlbot.dll. We are...

This is the way I handle knowing whether or not the key value for the data in my text file is a duplicate of what is in the database, though...

Oops, please note, with above script, forgot to close and deallocate trav_cursor. Sorry.

Dan

Thanks for the input, all.

I considered the dynamic SQL approach suggested by Antares686, which I read about yesterday when I was looking for a solution in the voluminous set of...

I have a similar load issue. I want to take one row of monthly budget data from a flat file and use a Data Driven Query to break that...