I export with DTS to Access database. I delete table on SQL7. I import with DTS to SQL7. All my design fields are changed to nchar, n... etc... (Unicode).... I need a way to turn this off. My Acc...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10205292.html
Basically my operation is simple.
I have to import Datas in to the table with certain validations from Server side.
For instance i will be importing(from text file) only particular records which ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10308019.html
I have a DTS package that I want to schedule to run once a day. I right clicked on the package and chose my schedule. Now, there should be a job scheduled but I don't see one. Where did it go? Any ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10808901.html
We have a Novell Server with DataEase database (DOS) running (SERVER A). The other server is an NT Server 4.0 running SQL Server 7.0 (SERVER B).
SERVER A is the SOURCE and SERVER B is the DESTI...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11277694.html
Is there any whay to execute DTS package on the server from the client?
I heard smth about setting a flag in the table for the client but i don't know how.
I can execute it from my VB app but onl...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11391738.html
I was trying to use shell (bcp.exe) within DTS and always fail. can someone help me with the know-how?
sohn
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11639758.html
Here's the situation:
We have been successfully running a DTS package on our SQL 7 server for the last 6 months or so.
Today we stopped the server so that we could use SQL6.5 to troubleshoot ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11859518.html
I've created a DTS on a SQL Server.
I need an easy example to run it from
Visual Basic. Please do not send me the example that comes in Visual Studio samples.
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_11955738.html
Can someone tell me what the code is that I require to run a MS SQL7.0 DTS script from the OnClick event from a button in MS Access please.
Many thanks
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20068971.html
Hi,
I import from CSV files into MSSQL tables.
My hierarchy absolutely wants to keep the CSV standard format.
Some string have quotes inside.
With Sybase it jumps these corrupted lines.
With...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20087939.html
