stricknyn (12/1/2010)

---

If the "good" data doesn't start until the 3rd column, then you actually don't need a script task to correct this. You can just use an excel source,...

As suggested by Phil, Raunak you can do. Also you can do this using script task. Some sample code below.

Dim address1, address2...

I have sort out the issue now.

I have tried with domain name rather than ip address. Then my agent job is working fine now. But i don't know why it...

No this path not have such. its like \\<ipaddress>\<folder name>

yes, i am the owner of this. Its runs using my personal credential. Moreover, if i run this package using dtexec command its running fine here.

Oh... yes, thanks you very Vikas! 🙂

Some times From and To Date be a...

sqlusers (10/5/2010)

---

Leo Suresh (10/5/2010)

---

I guess you are using table variable inside your SQL query. If that is the case, then OLEDB source task will not generate the columns.

Use a stored...

Why not this

select statement

where FromDate >= '2010-10-02' and ToDate <= '2010-10-05'

?[/quote]

yes, Thanks Phil. I am going like Horse eye. :w00t:

Exactly i want to get all the data's. That'y i use loop through.

Here in table my...

Leo Suresh (10/5/2010)

---

I guess you are using table variable inside your SQL query. If that is the case, then OLEDB source task will not generate the columns.

Use a stored procedure...

Actually, i need to get the data's according to From and To Date from a table. So for that i...

If it is true then it has to validate only at the run time right? Please correct me if i...

Take the File Name in an variable and add the following in the Script Task.

Dim vFileName, vDate, vFilePath As String

...

Dim strfile As String = "C:\File.txt"

Dim fs As New IO.FileStream(strfile, FileMode.Open, FileAccess.ReadWrite)

Dim read As...