Hi Sabya,

I have already configured the configuration file now how can I get the

"Execute SQL Task" point to this C:\PackageConfigurations\Environment.dtsConfig file. Please advise. Thanks.

Actually I have another question related to this post. I have each connection.dtsconfig connection file that located on Test and and Prod servers resding on E:\. The purpose is to...

He is grreat guy. Unselfish act. Miracle can happen do not give up.

O

What I am going to do is to replace the attributes values that contain <= with the value references below and then create the XML file parse it

Character

Entity References

...

yes I found my solution. Here is the website

http://www.fao.org/docrep/008/ae908e/ae908e06.htm

Thanks.

Hi

I have fixed the problem. I am good to go . Below is the solution. Thanks.

Set FSO = CreateObject("Scripting.FileSystemObject")

Set objDirectory = FSO.GetFolder(strPath)

...

Hi All,

Thanks for your help. I have used Famson last post and it works. Thanks for this site.

pcq0125

I have it as User::Path on ReadonlyVariables and on the Expression I have it as @[User::Path]. Still got the same error.

Hi Vishal,

I tried both ways with and without the Readvariables and still return an error. Also I have an expression as ReadonlyVariable on my script task as @[User::Path]

Below is the...

Hi Vishal

It was my typo mistake. I did use DTS.variables("Path") but I now I am getting the error "failed to lock variable" on the script task. Any helps is apprceiated....

Hi Famson,

I did what you stated but when I tried to pass it to the Script task and display in the msgbox using VB.NET abd it gaves me an error....

THanks.

Hi FerasGer83

Thanks for your tips. This is what I thought to place the trigger on the last child table. Another question if I delete from the last child table then...

Hi Grasshoper,

Thanks for your help. You have answered of my question. I apologize I did not not make myself clear. I wanted to know where should I place my trigger...

Hi ksullivan

I resolved my own problem by narrowing down that row that had given me problem and I found out the Dynamic sql has a case statement that has integer...