Viewing 15 posts - 22,081 through 22,095 (of 22,184 total)
This worked:
"C:\\Documents and Settings\\fritcheyg\\My Documents\\Visual Studio 2005\\Projects\\SSIS\\Chapter6\\test_" + (DT_WSTR,2)DATEPART("Hh",GETDATE()) + (DT_WSTR,2)DATEPART("mi",GETDATE()) + ".txt"
That's set in the ConnectionString property.
February 21, 2006 at 6:15 am
The classes exposed by Microsoft.SqlServer.Dts.Runtime should do the trick. There are samples in ASP & C# in the Wrox book (http://www.amazon.com/gp/product/0764584359/sr=8-1/qid=1140525802/ref=pd_bbs_1/002-4538442-1224846?%5Fencoding=UTF8)
February 21, 2006 at 5:47 am
Check out Solid Quality Learning (solidqualitylearning.com). We've scheduled an inhouse class with them in April, so I can't report on the specifics of their SSIS course. However, we've used them...
February 21, 2006 at 5:46 am
I haven't worked with it yet, but I just finished reading about the new managed code interface. The new class name is Microsoft.SqlServer.Dts.Runtime. It has an encapsulated class called Package....
February 21, 2006 at 5:38 am
Take a look at the Stealth Collector from Quest. It basically uses Profiler data to create the exact kind of aggregates & drill down you're looking for.
It would be nice...
February 20, 2006 at 6:41 am
Here's the info we recieved from Microsoft:
Based off the case that we had opened with MS, the best recommendation we have from PSS is to monitor MTL using "DBCC...
February 17, 2006 at 11:48 am
Holy Cats! We just ran into MemToLeave issues to. I had no idea what a limit there was on the servers due to memory management prior to hitting that problem.
I...
February 17, 2006 at 11:46 am
I can't believe you've got me working in Access to try this out, but here goes...
I did it by simply converting the data for both columns to a string, then...
February 17, 2006 at 11:04 am
I'm no Oracle expert, but I thought that was set in the TNSNAMES file.
February 17, 2006 at 6:11 am
We've been using Quest Stealth Collector to get aggregate information out of Profiler data on the fly and with history. If there was a way to make this tool more...
February 17, 2006 at 5:37 am
Just a guess, but when I used the configuration wizard, it stored the Oracle password as "******" instead of the actual value. When I edited that to an actual password...
February 15, 2006 at 7:57 am
Despite having had the ability to cascade delete for years, I haven't set it up, not one single time. It is too scary and completely out of control. At the...
February 15, 2006 at 5:28 am
Cascading deletes are a different requirement than that if a parent is deleted, so must the children. The question is one of automated actions vs. intentional actions. With DRI in...
February 14, 2006 at 9:54 am
There's a nice little task that was created for just this purpose at SQLIS.com (http://www.sqlis.com/default.aspx?23). I've used, not in production yet, and it works very well.
February 14, 2006 at 9:33 am
There are also some decent little samples out at SQLIS.com
February 14, 2006 at 9:29 am
Viewing 15 posts - 22,081 through 22,095 (of 22,184 total)