|
|
Browse by Tags
All Tags » SSIS » Expressions » SQL Server Inte... » SQL Server
-
When casting to a non-unicode textual value (i.e. DT_STR) in SSIS you might often have seen something like the following: (DT_STR, 50, 1252) (<expression>) and wondered what on earth the 1252 was referring to. Well the SSIS documentation on MSDN tells us that that third parameter is the code page to be used for the cast but we may ...
-
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
...
-
Someone emailed me today asking:
I have an SSIS package that outputs data that can’t be inserted into destination tables into flat log files [JT: I presume he means that error rows are redirected to a flat file]
What is the easiest way to then after processing has completed:
A) Check to see whether there has been any data that could not be ...
|
|
|