Viewing 15 posts - 9,526 through 9,540 (of 13,879 total)
suchitra.venkataramani (11/28/2013)
To be read and written to excel. Pls refer the above posts for more details.Thanks,
Suchitra
Why are you doing this in script? Use a dataflow.
November 28, 2013 at 5:26 am
suchitra.venkataramani (11/28/2013)
My select query will fetch me 2 rows. So what are the changes that should be made in ssis and vb code?
To do what, exactly?
November 28, 2013 at 5:11 am
hardikr (11/28/2013)
yes, Path and file both are exists when package runs.
OS installed on server is Windows Server 2008 R2.
My package runs under user SQLServices and I have...
November 28, 2013 at 4:57 am
hardikr (11/28/2013)
Can anyone please help me?
I have created SSIS package which exports data into excel file....
November 28, 2013 at 4:16 am
Remove the line
Private Const Location As String = "User::VarLocation" // declared as variable
And then ...
Dim var1 As String = DirectCast(Location, String)
should become something like
Dim var1 As String = Dts.Variables("Location").Value
I...
November 28, 2013 at 4:12 am
I can't think of a neat and tidy way of doing this without scripting. But with a script task, not difficult at all.
November 27, 2013 at 10:37 am
Koen Verbeeck (11/27/2013)
Phil Parkin (11/27/2013)
Koen Verbeeck (11/26/2013)
Can you post a screenshot? Normally all packages should run in parallel when executed from the master package.
You should bear in mind what the...
November 27, 2013 at 3:29 am
Koen Verbeeck (11/26/2013)
Can you post a screenshot? Normally all packages should run in parallel when executed from the master package.
You should bear in mind what the packages are doing when...
November 27, 2013 at 3:16 am
david.hao 17731 (11/26/2013)
The previous load is using XML Source in SSIS and there seems no problem. I queried the loaded data and did find invalid characters like "&"...
November 26, 2013 at 11:00 pm
Personally, I would put each extract in a different Excel sheet.
Me too.
Seems like a neater solution all round. Are you sure that this is not a possibility?
November 26, 2013 at 4:34 am
It sounds like a data error - as if the XML file is not well formed.
Do previous files still execute successfully? If so, that's almost certainly the problem.
November 25, 2013 at 1:54 am
..compare above time(lastmodify column) with himself...
What do you mean by this?
November 25, 2013 at 12:19 am
rarascon (11/22/2013)
November 22, 2013 at 7:20 am
rarascon (11/21/2013)
Right, this is more along the lines of what I'm trying to do - I want to know if ANYTHING is using those tables before I disable the package.
I'm...
November 22, 2013 at 12:25 am
ForumUser3 (11/21/2013)
I am using a UNC path, not a mapped drive.
My apologies, I misread the error.
Are you able to physically log in to the SQL Server server using the service...
November 21, 2013 at 6:41 am
Viewing 15 posts - 9,526 through 9,540 (of 13,879 total)