?

Log in

No account? Create an account
DTS - The Cover Story
October 2013
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
 
Tue, Apr. 12th, 2005 08:45 pm
DTS

Within 48 hours of hitting the ground in Chicago, I have found myself once again at the task I have so often proved my worth at -- writing and maintaining DTS Packages. Today I had a number of interesting assignments in Access and VB, not remotely related to anything in my BackOffice training, but were leverages by my coordinator to take the Visual Burden off some of our people and put it on somebody who could better handle it; i.e., me. So once again, I am delving into the SQLDOM and ADODB to dynamic rewrite and retarget DTS Packages. Who would have thought I'd use that skill twice?

I have also noticed that it is very difficult to get around Illinois without a car. Everything here is built under the assumption that everybody will be driving -- there are no sidewalks, even on major streets, and there are no walk-up ATMs. Every mailbox has one of the car extenders on it. I've had to walk through more drive-thrus since I got here than I've ever had to before, just to get basic tasks (i.e., banking, eating, etc) done. Remarkable.

Tags: , , ,

7CommentReplyShare

mikecap
mikecap
Mike Caprio
Wed, Apr. 13th, 2005 12:48 pm (UTC)

Hey, let me know what you end up doing with DTS stuff - that could be useful on a couple of things I'm working on.


ReplyThread
bronzite
bronzite
Robert Bronzite
Wed, Apr. 13th, 2005 02:12 pm (UTC)

Basically I've been writing VB Scripts/Programs that run through the collection of DTS packages on a server and change their properties and the properties of their tasks to point to a new environment(i.e., so if we have a version of the system where everything (views, SP's, packages, etc) have Y04 (ie. ttVendor_Y04) somewhere in them, there will be new copies made with Y05, and all the views, SPs, and package tasks will be updated to reflect the new environment.


ReplyThread Parent
mikecap
mikecap
Mike Caprio
Wed, Apr. 13th, 2005 02:21 pm (UTC)

Yep, that's cool stuff. I'd love to see it when you're done developing.


ReplyThread Parent
bronzite
bronzite
Robert Bronzite
Wed, Apr. 13th, 2005 02:31 pm (UTC)

Its done now, I think. The damnable thing about developing in this place is test environments for this sort of code are virtually impossible to come across.


ReplyThread Parent
sirroxton
sirroxton
Adam Augusta
Wed, Apr. 13th, 2005 03:05 pm (UTC)

Poppycock! Just build a JUnit-JNI-C++-COM-VB bridge.
*cough*


ReplyThread Parent
bronzite
bronzite
Robert Bronzite
Wed, Apr. 13th, 2005 03:13 pm (UTC)

You are definitely on the fast track to management.


ReplyThread Parent
jjlc
jjlc
jjlc
Thu, Apr. 14th, 2005 12:21 am (UTC)

Many places in Illinois are designed for walking, though perhaps not so much Chicago. I do know that I have walked from one place to another in Chicago, too.


ReplyThread