Thank you All,

we did similar to Daz.. suggession

Cheers

RB

ignore warnings, there is no harm, even msoft gave the same ans 🙂

you have to use excel interop name space to interact with excel and change the text to number format,

or

use activeX script task to change the text to number...

divyanth (8/4/2010)

---

Do you want to read the Complete data in that field or just the 30000 characters ? If you want to read complete field i might be able...

Thnx. So you used the approach 1 for the solution. I thought you used in built function similar to substring to get this done. Hope there is no method to...

Baskar B.V (8/3/2010)

---

Please let us know how you resolved this issue so that it would be...

I would do the following ...

1. use computer name environment variable at starting point of the tasks based on that assign set of variables from config to actual variables for...

Andrew,

for quick dislay

in script task use : msgbox Dts.variables("VariableName").Value.Tostring()

in Active-X scrit task use : msgbox DTSGlovalVariables("VariableName").Value

if you are not familier with Breakpoint ...

Baskar B.V (8/3/2010)

---

Is it possible to push the data value to a .txt file...

Substring is not returning more than 8000 chars, i wanted to read 30000 chars data. tks

Catch ex As Exception

Dts.Events.FireError(1, ex.TargetSite.ToString(), ex.Message.ToString(), String.Empty, 0)

Dts.TaskResult = Dts.Results.Failure

means, move failure line to end of statement i.e before end catch...

Build ConnectionString proptery of DB source connection via expression with full details like Server, instance (if you have) and Database name, user id and pwd(if u r using), dynamically,...

I'm running using DTEXEC command, dtsx file is stored in structured file format in a folder

1. getting set of files from ftp

2. running my dtsx pkg for every 4 seconds,...

get all files using system.io

compare modified date, take latest file into variable

loop thru all files..

import that file..

OR

Each time you process a file, save the file name in database

loop thru all...

I ran(still running), 1 package with 15 instances per minute, 1 run for every 4 seconds, execution will last about 10 seconds

this is about.. moving files to different folder based...