I need to be able to set the DTSDestination column dynamically using a variable for the column name. Here is the code I am using: strColName = cstr(DTSSource("ColName")) DTSDestination(strColName ) = DTSSource("QVal") I am getting the error "Invalid procedure call or argument: 'DTSDestination'". I'm sure that I am just missing something.Thanks!
2004-10-04
3 reads
take care that you might face some problem if you make SQL Server and SQL Server Agebt work on Local account ...it is recommended to set it to a Domain account (and must be from the adminstarors Group)I hope this help u
2004-08-15
We've had similar issues with using IBM's Client Access drivers for the AS/400. The only resolution was to reboot the server, both from IBM and MS. The memory size of 128 si shared by ALL data access drivers, and can be easily eaten by a linked server. I'd schedule a restart and change the parameter […]
2004-04-05
2 reads
Can you post the last few lines (20 or so) of the sqlsp.log file? You'll find it in %SYSTEMROOT% on the system you attempted the install from. Make sure you sanitize the entries so you don't reveal anything sensitive about your environment.
2004-03-30
How large your log backup typically from 9PM to 9AM without performing database shrinking?DBCC SHRINKDATABASE moves the data and index pages within the database files and such activites should be logged for recovery purpose.
2004-01-08
Not that I know of. It looks like you're out of sync somehow. Trying turning on the verbose logging for the distribution agent so you can some more details. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-09-02
You may also want to note that the SQL Server 2000 instance will not run on the default port. (1433) Depending upon your network configuration, you may be required to specifically denote the port number in any client connection strings, particularly if your systems operate across multiple subnets.
2003-08-06
Would these be packages that are running as part of a job or packages that someone is currently running manually? Diane
2003-08-05
2 reads
2003-08-04
Got the solution to the problem. My SQL Server agent was running with system account. Modified the login info..logged on as .\administrator. That solved my problem. Your reply helped us in thinking in that direction. Thanks for your reply.
2003-07-30
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