Viewing 15 posts - 1 through 15 (of 17 total)
"In my CTP the next screen after you click Setup on the first screen tell you to select a certain database to install Messaging Objects" - I suggest you check...
January 3, 2006 at 3:13 pm
I second the DTSRunUI suggestion, it is a much easier way of getting a command line. /E is also good practice. Also be aware that the right-click schedule job, it...
December 20, 2005 at 1:30 pm
The DTS package owner is irrelevent. It is only ever used when deleting or saving a package, such that you must be a sa or the owner to modify/delete.
The owner...
November 12, 2005 at 3:07 pm
Here are a couple of articles that demonstrate looping-
How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)
How to export all tables in a database
(http://www.sqldts.com/default.aspx?299)
The problem you will have is...
November 12, 2005 at 3:03 pm
fromnaija, I belive you are wrong with regard to the Send Mail Task. SendMail uses a MAPI profile, and it is the name of the MAPI profile that you select...
January 8, 2004 at 12:26 pm
Could you please define Server Name? As sql servant has already pointed out the name of the local machine is not always the name of the SQL Server instance, since...
January 4, 2004 at 5:03 pm
quote:
Do you know where I can find the meaning of the error codes logged in sysdtssteplog?
September 11, 2003 at 12:32 pm
quote:
I ran it in our dev environment after copying some of our most complex DTS packages there. They were completely reorganized...
September 11, 2003 at 12:27 pm
"With DTS package automation, we naturally turn to SQL-DMO.". We actually turn to the DTSPackage Object library as opposed to the SQLDMO Object library. SQL-DMO offers no DTS control at...
September 9, 2003 at 10:30 am
Watch the RAID type you use. Unfortunately many vendors know about SANs, but not about SQL. Unless your application is appropriate, you don't want to end up with RAID 5...
March 26, 2003 at 2:46 pm
I know some of these points have already been covered, but just to show there is more than 1 person asking I've covered them again-
Reliable mail, not using MAPI. This...
March 2, 2003 at 11:38 am
Check out "DTS Transaction Fundamentals" in Books Online. This does a good job explaining the ins and outs of usong transactions in DTS. In particular you will see that the...
February 15, 2003 at 9:33 am
It's a known issue, fixed in SP2. See KB 247527
FIX: DTS May Truncate Characters When You Export a Table Column of Character Data Type to a Text File
http://support.microsoft.com/default.aspx?scid=kb;en-us;247527
Make sure ypou...
January 12, 2003 at 2:17 pm
Just remember that UDLs are only usefull in SQL 2000 because in SQL 7.0 they where consumed at design-time not run-time.
April 2, 2002 at 7:18 am
The limitation of the wizard not allowing you to transfer system tables can be overcome by building the package manually.
Transferring DTS Packages
March 20, 2002 at 1:35 pm
Viewing 15 posts - 1 through 15 (of 17 total)