I have an old VB 6 program that I used to create new table partitions annually. The program used SQLDMO.
We've upgraded to SQL 2008 since I used it last and it no longer works with SQL 2008.
It’s time for it to be upgraded anyway, so I thought I’d see if I could use the script task in BIDS and create a task to do the same thing using SMO.
I haven’t developed a thing in C# so I’m very much a rookie, and all the examples I find are for using C# in VSS – not in BIDS.
Can anyone point me to a good place where I can see samples of C# code in BIDS?
Here is what my VB6 code looks like, that I’d like to replicate in BIDS 2008 in a script task.
I’d like to do it there because I don’t have VSS.
Is it possible?
Dim svr As SQLDMO.SQLServer2
Dim strFile As String
Set svr = New SQLDMO.SQLServer2
strFile = "c:\2011Tables.txt"
.Name = "MyServer"
.LoginTimeout = 15
.Login = "sa"
.Password = "MyPwd"
Open strFile For Output As #1
For Each View In svr.Databases("LIVE").Tables
If InStr(View.Name, "2010") >
View Complete Post