Short and Sweet

Give a client the ability to go to web page.

Click create Report. Then be able to drag and drop Tables/fields to create reports.

I do understand we could use...

Here is the answer I thinks this makes me the expert now!!

Try

Dim MySQLString As String = Dts.Variables("AdjustDescription").Value.ToString

...

Just tried this jack still getting errors.

Am I the first to execute a update statement from Script?

There is documention out there but its all over the place.

Some person does...

Made a couple of changes Jack.

I changed the index of the Dts.Connections(0).

From

Dim connName As String = Dts.Connections(0).Name

To

Dim connName As String = Dts.Connections(1).Name

From

Dim conn As Odbc.OdbcConnection = CType(Dts.Connections(1).AcquireConnection(Nothing),...

Hey Jack Something I just noticed?

You declare/Dim ConnName but never use it??

Are we missing something?

Awesome that fixed those issues.

Now It is blowing chunks on:

Dim conn As Odbc.OdbcConnection = CType(Dts.Connections(0).AcquireConnection(Nothing), Odbc.OdbcConnection)

Says:

DTS Script Task RunTime Error

Unable to cast COM object of type 'System.__ComObject' to class...

Jack Still need your help come on man its Friday we can it!!

Michael

Jack first thanks for your help.

Still have an issue on the following

If conn.Status <> Open Then

conn.Open()

End If

da.ExecuteNonQuery(sMsg)

I get blue line under conn.Status when I hover...

Is this correct don't seam to like it?

Try

Dim MySQLString As...

The was great into.!!!!!!!!!

Need a little though. I have doing same thing except I need to add a where clause to SQL in the Excute SQL Task!

How does that work?

I...

Man this is driving me crazy.

Ok I added a Script under a Flat File Source

Now what I need to do in this Script is get the file Name Strip...

Ok I still need help ASAP!

I have the foreach loop container, set to For Each file in the directory your files will be stored in!

I create a Variable to hold...