|
|
Browse by Tags
All Tags » SQL Server » Variables
-
I was looking over a package today that a colleague had built and it contained the following code in a Script Task that was being used to return today’s day name:
Public Sub Main()
'
Dim sWeekday As String
sWeekday = Now().DayOfWeek.ToString
Dts.Variables(''User::DayName'').Value = sWeekday
...
-
That’s what I twittered recently upon first opening up Release Candidate 0 of SQL Server 2008. You may remember that back in March of this year I told you about a new feature that would be appearing in a future CTP; namely that a container would provide information about its parent container. Hence if you peer into the depths of this ...
-
Today I ran into a blocker when trying to do this. Having spent a reasonable amount of time taking all of my sql statements out of the OPENQUERY argument and putting them into a string variable I then found it didn't work. The reason (from BOL) it turns out is that, and I quote; "OPENQUERY does not accept variables for its ...
|
|
|