DTS packages from 2008sp2 to SQL 2017 1

[Cpreston]

Hi

Not sure if this is the right forum.

We are moving from SQL server 2008sp2 to SQL 2017. In 2008 we have some DTS packages. I have 2 questions

1. Where can I see in 2008 when the packages were last run in SQL.
2. How do I transfer the DTS packages to 2017, I know it probably will mean moving them to SSIS, but is their a tool that does this.

THanks

 

[fredericofonseca]

no other option for you other than SSIS - support for DTS ended already.

as you are still on 2008 take that opportunity to convert them to SSIS - on newer versions the tool is not available.

https://kamakshisuram.wordpress.com/working-with-ssis/migrate-dts-package-into-ssis/

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[Cpreston]

Hi

Ok managed to get the DTS migrated. However when I load it in BIDS I am running into coding issue.

I did not realise but the DTS is using Active X script. After some googling I found the script needs changing into C# of which I know nothing about. Is there any way to simply convert the code or does it need re-writing completely in C# The Active X script is below. Thanks

Function Main()
' copy correct datafile to 'current'

Dim ofilesys, Y, M, oFileCopy
Y = Right("0000" & CStr(Year(Now())),4)
M = Right("00" & CStr(Month(Now())),2)

set ofilesys=CreateObject("Scripting.FileSystemObject")
If ofilesys.FileExists("D:\MILL_FILES\O1\STOCK_" & Y & "_" & M & ".CSV") Then
set oFileCopy = ofilesys.getfile("D:\MILL_FILES\O1\STOCK_" & Y & "_" & M & ".CSV")
oFileCopy.Copy "D:\MILL_FILES\O1\STOCK_CURRENT.CSV"
End If

set ofilesys = nothing
set ofilecopy = nothing

Main = DTSTaskExecResult_Success
End Function

 

[fredericofonseca]

you can select to have the script component in vb.net - similar syntax to what you have now.

but that is easy code which you should be able to do some investigation and convert to c#.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[Cpreston]

Hi

Not easy for me unfortunately, I have googled somewhat but cannot find anything that helps. if you have any links you know of that would be useful.

Thanks for your reply I appreciate it.