Guys,

I did the following:

- defined TaskName in ReadOnlyVariables input.

- called the following code from script: MsgBox(Dts.Variables("TaskName").Value)

And it worked, showing script task's name. I think it is incorrect to use System::...

If you can use third-party solutions, check...

Hi Andrew,

If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus. It is an extension of the standard Data Flow Task and it is designed to...

Check this discussion[/url].

What happens? Do you get an error or what?

As other knowledgeable people have said before me, parsing address information is not easy task and it is not a matter of one or two "smarty pants" expressions.

If you can...

Weird logic. But you can easily explain it will cost N times more to...

Ah, I...

Koen,

The programming solution will work. However it is too demanding for many users. Another solution would be the CozyRoc commercial solution Data Flow Task Plus. It can retrieve the source...

Koen Verbeeck (3/4/2011)Therefore the use of dynamic SQL. You construct the whole SELECT and INSERT statement on the fly.

But, to be true, this will only work if the destination and...

What is p04.xusr.g481ddw(0) ? File or folder ?

Try the following remote parameter:

/p04.xusr.g481ddw(0)

or

p04.xusr.g481ddw(0)

Koen Verbeeck (3/4/2011)

---

You can use a for each loop to loop over the table and store the tablename in a variable.

Then you can construct a dynamic SQL statement in an...

You are not going to see files, when you open the browser window. It is only used for browsing remote folders. If you want to download all files from specific...

Hi Sonal,

Do you have the tables from source created in the destination database? Or you have to create them first?

phamm (2/25/2011)

---

Hi all, just wonder if anyone has processed .NAF file? Would it be the same as processing .txt file? I right to load it into the db as...