September 17, 2003 at 3:07 am
I've just created a dts class in vb to automate a lot of my flat file importing. I just used the save to vb and then cut and pasted stuff to do this.
Trouble is I was developing it on a machine with SQL2000 installed (for the nice query analyser) whereas we need to use the sql7 dlls. (doh!)
Anyway, I've changed all the references back to the SQL7 objects but when I go to add a new connection like so...
Set oDTSConnection = dtsPackage.Connections.New("DTSFlatFile")
...it doesn't seem to recognise the DTSFlatFile.
Does anyone know what the equivalent is in SQL7. I haven't been able to find any documentation.
cheers,
Mike
September 17, 2003 at 6:45 pm
Seems I asked a difficult one.
Don't worry about it. I'm going to run with the 2000 dlls and make sure the client is never intalled on the server - or if it is i'll do it piecemeal.
cheers,
mike
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply