Groups | Blog | Home
all groups > sql server dts > march 2007 >

sql server dts : Read a text file froma script task in SSIS


John Mason
3/14/2007 7:39:47 AM
I am trying to read a text file from an SSIS script task. I've seen a few
examples of how to do this on the web but cannot set up my script environment
to work.
Specifically, all the examples I use have the Inherits UserComponent
statement, which gives me a 'type UserComponent is not defined' error.
I have various imports statements:
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Data.SqlClient
Imports System.Net
Imports System.Net.Mail
Imports System.Data.Common
Imports System.IO

but I can't seem to get rid of the error.
Can someone please point out the inevitably simple answer to my problem?

John Mason
3/14/2007 7:55:13 AM
I've figured it out.
I was using script in the Control Flow and what I'm trying to do will only
work (I think) in the Data Flow.

[quoted text, click to view]
AddThis Social Bookmark Button