http://www.mssqltips.com/tip.asp?tip1238

Check this tip...interesting...

Rgds

JFB

Hi

Maybe this is your problem...

http://support.microsoft.com/?kbid=290077

set all ActiveX scripting tasks that invoke the Windows Scripting Host shell object to execute on the main package thread.

I hope this help.

JFB

Here is the solution

http://www.webservertalk.com/message101815.html

JFB

Here is the other way, but you probably can get the idea from here.

http://www.sqldts.com/?243

Rgds

JFB

Maybe you can use lookups for this challenge

http://www.sqldts.com/default.aspx?277,4

Rgds

Johnny

I can help you to translate but here is a better example.

http://support.microsoft.com/?kbid=319951

Rgds

JFB

Sorry... I never get this notice on my email....

Tks to everyone for reply... I will go over...

Johnny

Ok Brian,

So I need to open port for this traffic in ISA server.

Tks for the explanation, It was strange because this is my backup server and no clients connects to...

Tks for reply,

File Version : 2000.080.2039.00

As you see my sql server has sp4.

Any other ideas?

Rgds

Johnny

Hi John,

I can't help more if I don't see any code.

Check this tutorial http://www.sqldts.com/default.aspx?218

You probably need to reset the properties of your steps after the package ends of...

Hi,

I am trying to use this tool in one of my sp extracting xml text data and my problem is that I have an image to get but varchar variable...

Ok then the other option should be OLE DB error. The error 80040e21 indicates that the field is too small to accept the amount of data you attempted to add....

This is permission error problem.

Check all the permissions that you are using on the network or store procedures that you are using.

Rgds

JFB

You should use completion on you workflow.

http://www.sqldts.com/default.aspx?287

Rgds

JFB

You should have not problem to create text files with more than 15 columns.

Maybe if you create a dts pkg with 15 columns the first time and you want to...