Viewing 15 posts - 31 through 45 (of 188 total)
ok i'm an idiot. i just answered my own question. sorry guys!
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"
...
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...
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...
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...
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...
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...
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
September 23, 2008 at 2:00 pm
Sweet! That is exactly what I needed!
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...
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...
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...
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...
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...
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?
April 25, 2008 at 10:37 am
Viewing 15 posts - 31 through 45 (of 188 total)