Viewing 15 posts - 31 through 45 (of 73 total)
stricknyn (12/1/2010)
December 2, 2010 at 5:13 am
As suggested by Phil, Raunak you can do. Also you can do this using script task. Some sample code below.
Dim address1, address2...
November 29, 2010 at 5:06 am
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...
November 25, 2010 at 2:38 am
Phil Parkin (11/25/2010)
Does the path include drive letters? If so, can you use a UNC path instead?
No this path not have such. its like \\<ipaddress>\<folder name>
November 25, 2010 at 1:15 am
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.
November 25, 2010 at 1:09 am
Oh... yes, thanks you very Vikas! 🙂
November 10, 2010 at 4:19 am
First, see this thread.
Second, as I gave you a pure T-SQL solution, why are you still using a stored proc to do this?
Some times From and To Date be a...
October 6, 2010 at 6:26 am
sqlusers (10/5/2010)
Leo Suresh (10/5/2010)
Use a stored...
October 5, 2010 at 6:47 am
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:
October 5, 2010 at 6:14 am
Why not a WHERE clause? Sounds like you're getting the records one at a time?
Exactly i want to get all the data's. That'y i use loop through.
Here in table my...
October 5, 2010 at 5:50 am
Leo Suresh (10/5/2010)
Use a stored procedure...
October 5, 2010 at 5:44 am
Phil Parkin (10/5/2010)
Why does your data source contain a WHILE loop?
Actually, i need to get the data's according to From and To Date from a table. So for that i...
October 5, 2010 at 5:14 am
Raunak Jhawar (9/20/2010)
Probably because you still have the DelayValidation as true
If it is true then it has to validate only at the run time right? Please correct me if i...
September 21, 2010 at 12:26 am
Take the File Name in an variable and add the following in the Script Task.
Dim vFileName, vDate, vFilePath As String
...
September 9, 2010 at 5:01 am
Dim strfile As String = "C:\File.txt"
Dim fs As New IO.FileStream(strfile, FileMode.Open, FileAccess.ReadWrite)
Dim read As...
September 9, 2010 at 4:40 am
Viewing 15 posts - 31 through 45 (of 73 total)