Maybe it wasn't clear, if you re-read my original post, I don't use the Script result constant within the ActiveXScriptTask (I don't think it would work, this would require a result constant along the lines of Main = DTSTaskExecResult_Failure or success etc etc, ie these require Task constants). I use this script within the Workflow […]
2004-02-16
You need to decide how you intend to read/update the data. If you are doing this is VB.net see a tool like LLBLGEN (http://www.sd.nl/software/) If you are using VB 6 see http://users.quista.net/thealey/download.htm (CodeGEN) for some samples on how to do this. I'm pretty sure your problem #1 has to do with with cursor type when you open […]
2004-01-14
Yeah, I was really leary. What did my German really translate to? My brother had a foreign exchange student live with him one year that was from Germany. He sends me emails from time to time and the translations are really screwy. He probably thinks the same thing when I send him a message. All […]
2003-08-26
1 reads
I never did this but I guess if you have an OLEDB Provider to access Lotus 123, it shouldn't be a problem using DTS to import the workbook.
2003-08-25
1 reads
2003-08-25
2003-08-21
1 reads
Yeah, cust_id is large enough without a doubt. the casting doesnt seem to hav an effect If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
2003-08-15
1 reads
If you are running SQL Server 2000, change it after the restoration using alter database command with modify file option. You can't do it in 7.0
2003-08-11
1 reads
Here is a simplified version of the task: Table Lottery AcctNo varchar(16) Cycle varchar(2) Bal numeric(9,2) EmpNo varchar(6) - starts as null - want to assign empno's to this field randomly Table Emp EmpNo varchar(6) Cycle varchar(2) I need to assign empno's to accounts matching on cycles (think of cycles as teams). I need to […]
2003-07-31
If you do want to use a Cursor for updating, you will need to ensure that the cursor is updatable. Some queries will return cursors where the cursor is not updatable. If you have an updatable cursor, then you use it like this: UPDATE MyTable SET MyField = @MyValue WHERE CURRENT OF c_MyCursor
2003-07-30
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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