Viewing 15 posts - 31 through 45 (of 189 total)
ok i'm an idiot. i just answered my own question. sorry guys!
[font="Courier New"]ZenDada[/font]
November 24, 2008 at 5:02 pm
Maybe try this?
Imports Microsoft.SqlServer.Dts.Runtime
Public Class ScriptMain
Public Sub Main()
Dim vars As Variables
Dts.VariableDispenser.LockOneForWrite("vMyVar", vars)
vars(0).Value = "Hello World"
...
[font="Courier New"]ZenDada[/font]
November 24, 2008 at 4:57 pm
The answer is overhead, but I guess that's obvious - maybe someone else can chime in about exactly what all the overhead is. Save the data flow task for...
[font="Courier New"]ZenDada[/font]
October 17, 2008 at 11:39 am
Steve Jones - Editor (10/10/2008)
Why can't anyone write to the db? Not to question your idea, but I'm wondering if there is something else we can come up with.
Spec comes...
[font="Courier New"]ZenDada[/font]
October 10, 2008 at 9:45 am
Adam Angelini (10/9/2008)
you could put the database in single user mode, but I'm not sure if it would work from an SSIS package. Worth a try I suppose
Thanks. Forgive...
[font="Courier New"]ZenDada[/font]
October 9, 2008 at 3:37 pm
Lynn Pettis (9/25/2008)
It went away. Do to that now you need, at a minimum, Visual Studio 2005 Professional Edition (Standard Edition isn't good enough).😎
Ah okay, I have VS...
[font="Courier New"]ZenDada[/font]
September 25, 2008 at 11:12 am
Ah! Sure enough! Silly me!
I guess you could compare the two dates with dateadd(year, 1, '2008-10-01')
though, right? I am thinking that would account for leap years...
[font="Courier New"]ZenDada[/font]
September 23, 2008 at 2:32 pm
or using the year part,
where datediff(year,startdate,dateadd(d,1,enddate))>=1
or datediff(year,startdate, enddate)>=1
depending on which one actually meets your definition
[font="Courier New"]ZenDada[/font]
September 23, 2008 at 2:00 pm
Sweet! That is exactly what I needed!
[font="Courier New"]ZenDada[/font]
September 23, 2008 at 12:25 pm
sql_er (7/25/2008)
I have noticed a few things happening with the excel spreadsheet, as I am using this approach:
1. The excel file is increasing in size, even though the data inserted...
[font="Courier New"]ZenDada[/font]
July 25, 2008 at 1:59 pm
Oh and first thing - the data you have in there right now... how did it get there? was that with your create table statement and insert? Or...
[font="Courier New"]ZenDada[/font]
July 22, 2008 at 12:39 pm
sql_er (7/22/2008)
I don't think it is working. I tried it. Even though the DTS package executes with no errors, nothing happens - the original data remains in the...
[font="Courier New"]ZenDada[/font]
July 22, 2008 at 12:34 pm
sql_er (7/21/2008)
Thank you for the reply - I am still a bit confused though.
My question was referring to the approach used by the original article. If I follow...
[font="Courier New"]ZenDada[/font]
July 21, 2008 at 3:22 pm
sql_er (7/21/2008)
If we do not have the Microsoft Excel installed on the server where the template (created on my local machine with MS Excel installed) resides, will this approach still...
[font="Courier New"]ZenDada[/font]
July 21, 2008 at 12:10 pm
Darn. Not the answer I wanted to hear. How about modifying the XML? Can I add a style tag or something?
[font="Courier New"]ZenDada[/font]
April 25, 2008 at 10:37 am
Viewing 15 posts - 31 through 45 (of 189 total)