Any feedback guys?

Need your help about this.

Thank you.

Hi,

Here is the code that I used.

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.ComponentModel

Imports System.Diagnostics

<Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute()> _

<System.CLSCompliantAttribute(False)> _

Partial Public Class ScriptMain

Inherits Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase

Enum ScriptResults

...

Hi,

Thank you.

What I want to achieve are:

a) get the first day date of the previous month based on current date

b) get the last day date of the previous month based...

Hi,

You mean like this?

(DT_WSTR, 30) DATEADD("dd", -1, (DT_DATE)((DT_WSTR, 4)YEAR(GETDATE()) + "-" +RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()),2)+"-01"))

I'm sorry. Just a newbie in SSIS.

Thank you.