Viewing 15 posts - 196 through 210 (of 420 total)
I would use a script task to compare the 2 vars after I do the counts. Then, if they don't match, you can fail that step by just putting...
June 26, 2008 at 8:47 am
I'm glad you got it working.
Yeah, firing events in script code is easy...
DTS.Events.FireError(0, e.Message, "No Folder Found", "", 0)
You can look up the EXACT syntax, but that's pretty close off...
June 26, 2008 at 7:48 am
While I'm not adept at it, I'm sure SMO has an object you can call...
and who knows, it may be the same object call as you're using now.
Have...
June 25, 2008 at 11:39 am
The only thing the A attribute does to a file is flag it so that windows can do a differential backup. It has nothing to do with any apps.
A...
June 25, 2008 at 10:55 am
You can convert it in your query and that should pick it up just fine, or you can set your .net datatype to datetime...
in SQL you'll convert like this...
convert(datetime, ColumnName)
However,...
June 25, 2008 at 10:14 am
FileNewest doesn't have to be an object to compare it to the current file. Just store the current file's info in a variable or 2. So like for...
June 25, 2008 at 9:48 am
I'm not entirely sure what to say to that. I've never seen that. The way I did it in the vid is exactly how I've done it for...
June 25, 2008 at 9:37 am
Hey tom can you show me exactly what you're talking about and I'll wrap some gray matter around it...
June 25, 2008 at 9:19 am
One trick to my vids is if you right-click on the control and view the properties, you can pull the filename and download it by hand. I'm trying to...
June 25, 2008 at 9:04 am
Oh, I suppose I could make my way through all the options in the package config menu... make it a little series on package configs or something... sure, I'll see...
June 25, 2008 at 8:53 am
Oh geez I don't know man... let me think... I'm sure by now that you've covered the basics of making sure the users have windows rights, right? If you're...
June 25, 2008 at 8:51 am
OK man, that video's ready for you...
This shows you exactly what you need to do to setup a conn string in
an xml file...
http://midnightdba.itbookworm.com/SSISConfigFileConnString/SSISConfigFileConnString.html
June 25, 2008 at 8:39 am
Here's some code I use to change the properties.
You should be able to use it to just check them. And this does exactly what
you're looking for.
Dim f...
June 25, 2008 at 8:32 am
That's almost exactly what I said... whatever...
And I also believe I said that you could count the rows ahead of time both with the row count and the exec sql...
June 25, 2008 at 8:22 am
My mistake then... thanks for pointing that out olga... I've only used stopat for marks so I must've just skipped past that...
and yeah, he'll need a log parser for that.
June 24, 2008 at 4:49 pm
Viewing 15 posts - 196 through 210 (of 420 total)