Is there a way to dynamically change a column mapping in a DataPumpTask transformation using an Active Script task? I am passing several SQL statements into a package and need to "refresh" the transformations each time. Thanks for your help.
2001-10-23
Hi all, I understand that only if we backup the database, the log space is freed. This is regardless whether the truncate log on checkpoint option is true or false. My doubt is, i found somewhere that this option (truncate log..) should not be set to true. If set to true, then, all the transaction […]
2001-10-22
All properties in SQL 2000 & agent have been set to auto restart if SQL 2000 is shutdown. SQL Server agent is not restarting. It can be manually started. Have numerous jobs assigned to 2 different servers and need to have this auto restart. Both have Win2k and are recently upgraded databases from 6.5. Any […]
2001-09-27
23 reads
Hi all, I can backup my databases into my local drives. But, if I'm moving my database bkup from the local machine to another mach from where I do a tape backup, can this entire process be automated? Cheers Parasuraman Parasu Raman
2001-09-08
2 reads
I have table A with three fields. Emp_Code Char(3), Emp_Name varchar(15), Policy_Change_Date datetime GetDate() . If any one record changes in table A, i wish to get the system date into the Policy_Change_Date. How will i create this trigger?
2001-08-27
2 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/bknight/review:rentageekbookwithiqreference.asp
2001-08-27
1 reads
I am running a local copy of EM and trying to connect my SQL Servers from home.. I am able to ping the boxes when connect through our vpn but I cannot register the dataservers. "access denied" Any ideas?? TIA, Matt
2001-08-16
5 reads
Hi guys, does anyone know how to populate the page's text boxes and pull down menus using an initial pull down menu at the top without using a button? Is there any such way? Or do I really have to use the button thing? Right now, I have one that uses a button after the […]
2001-08-10
2 reads
2001-08-10
14 reads
Hi, Everyone I have a question for U. I have one SQL6.5 box that has 2 applications on it. I want to upgrade. What is the best way to do it? I have one test box that has SQL7.0 installed. I read lots of upgrading papers but I want some ideas from fields.:-)))I want use […]
2001-07-30
3 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers