Viewing 15 posts - 1 through 15 (of 28 total)
Yes the package will fail if the database names within the package don't exist. You will have to open the pakage in DTS Designer and repoint the database connections to...
September 16, 2004 at 12:03 pm
Make sure that the domain account that you are using for the SQL Server Agent is a member of the local administrator group on the server.
July 20, 2004 at 6:24 am
Gerrit,
You need to have the Oracle client & networking components loaded on the server in order to get DTS to connect your Oracle database. Although there is a Microsoft OLE...
July 20, 2004 at 6:18 am
Save the DTS pkgs as a structured file and it will be saved as a file with a .DTS extension. To migrate the pkg go into the DTS designer and...
March 1, 2004 at 1:58 pm
Hey Jonathan,
ThE PARSENAME() solution looks good. I'm validating the results. Thanks everyone for the contributions.
November 14, 2003 at 2:05 pm
Sure, below is the field heading and some sample data.
INDNAME
----------------------
ROSE DONALD BRUCE
GAMACHE RICHARD HERVE
CARLSON...
November 12, 2003 at 8:23 am
Hey Allen,
I installed MDAC 2.7 and that took care of the problem. Thanks for the assist.
October 8, 2003 at 8:55 am
HEY Alamir,
The MDAC 2.7 took care of the problem. Thanks for the assist.
Ted Scott
October 8, 2003 at 6:56 am
Hey Allen,
How would MDAC affect my installation?
October 7, 2003 at 6:52 pm
Hey Allen,
How would MDAC affect my installation?
October 7, 2003 at 6:52 pm
I added the SQL Server Agent system account to the domain Administrators group and added it to the Excel file itself with full control rights. I'm still getting the same...
April 2, 2003 at 11:28 am
I work with both SQL Server and Oracle. Oracle overall has a higher TCO. I mean a Server SQL DBA fetches around $70,000 and a Oracle DBA yanks about $85,000....
March 31, 2003 at 9:40 am
As far as certs go, the only use I have for it is that when you have the letters behind your name on your resume it immediately stands out. Now...
March 21, 2003 at 8:32 am
Antares686,
The VB app scans a table that stores requests for data for recently inserted records, then generates flat files on the fly, then FTPs the flat files to a directory...
December 2, 2002 at 6:35 am
Simon,
How would I get the VB application to operate under a new thread?
November 25, 2002 at 8:29 am
Viewing 15 posts - 1 through 15 (of 28 total)