Hi David,

I'd try just removing the proxy declaration and method...

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Public Class ScriptMain

Public Sub Main()

...

Do you use a proxy? You might have to add one to your code?

The following has worked for me...

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Public Class ScriptMain

Public...

Very funny!

Try dtutil.exe There are more instructions on how to run it on BOL...

Command will look something like this:-

It's a neat little tool, but the problem I've had with it is that you can't import templates that contain a script component or an Execute Process task... I didn't...

Hi,

Chances are you'll want two connection managers - one to manage your connection to the source data, and the other to manage your connection to the configuration table/s.

It sounds like...

See Books on line...

http://msdn2.microsoft.com/en-us/library/ms141053.aspx

Nicely done - might be worth sending it in as an article... there aren't enough walk throughs out there for this...

I know from my own website that this is a...

Hi Paul,

Here are 2 scripts that do the same thing... One uses the .net 1.0 system.web.mail class and the other the .net 2.0 system.net class.

Hope this helps...

Looks like you've done most of the work already, you just need to use the RIGHT function with your expression.

Also, add month and day to 100, and take the rightmost...

I think Jessica's issue is that you cannot assign a NULL value to SSIS variable. So what we are doing is coalescing in the dataflow to a known value that...

You're right - it needs a typecast (DT_DBTIME)"1900-01-01" should do it.

PS: Just editing to add one other point - make sure that your sql statement uses the same dateformat as...

Hi, you've probably already done this, but I'm just saying it because looking at the sproc Michael has written he has the SET NOCOUNT ON statement at the top where...

Hi,

What you should use is a surrogate key, rather than your composite key (you should be able to find a whole load of info on tinternet) on your dimensions. This...

Hi Jessica,

I'm not sure what you're doing in the ForEach loop but if you're using a SQL task, then you can use a variable as the SQL command. Then what...