Viewing 15 posts - 10,831 through 10,845 (of 13,872 total)
I had to go back and see what I say since this post is so old.
I do that sometimes ... it's not always a happy experience - sometimes you realise...
March 23, 2012 at 1:23 pm
jasminipatel51181 (3/22/2012)
Thanks for the reply.my File name is not fixed it varies every day.
Thanks,
J
Well that clears things up.
Personally, I'd keep the file name as-is and instead use...
March 22, 2012 at 8:36 am
Thanks to all who replied, particularly Phil, who's method has worked for me.
😎
March 22, 2012 at 7:14 am
Koen Verbeeck (3/22/2012)
Just guessing here, but what if you store e -aoa in a variable?So your arguments expression is:
@[User::Arguments] + @[User::FileName]
Otherwise, whip out the plain old script task. 🙂
Thanks for...
March 22, 2012 at 3:13 am
Try this. Use a Script task and add the following two Usings:
using System.Net;
using System.IO;
Then change your Main sub - here's something I copied from elsewhere on the Web:
...
March 21, 2012 at 9:41 am
aaron.reese (3/21/2012)
RANK() OVER(Partition by CustomerNo order by CustomerNo ASC, Date ASC) as 'RANK'
Or this
with x as (select CustomerNumber = '0001',
...
March 21, 2012 at 7:32 am
We don't like cursors much here 🙂 Can you tell us what you are trying to achieve & we'll almost certainly find a faster way to do it.
March 20, 2012 at 9:23 am
Aha, I should have thought about that.
Well done on figuring it out.
March 19, 2012 at 2:49 pm
Maybe you should set the breakpoint on the pre-execute of the data flow - it may be that your breakpoint is being hit before the variable's value has been set.
If...
March 19, 2012 at 2:34 pm
Is there a way to quickly search some freetext in all sp/fn within the database? I often need to search for a sp but just couldn't find it, I have...
March 14, 2012 at 11:24 am
sellonster (3/14/2012)
Maybe I'm not explaining exactly what i really want to achieve. You see on my c# program, I have 2 connections pointing to two different DB servers. From...
March 14, 2012 at 6:31 am
Notwithstanding the fact that SSIS is the wrong tool - ditto comments already made ...
Have you investigated the 'Execute Process' SSIS task - this might run the .VBS scripts (never...
March 13, 2012 at 11:43 am
Right - that makes it a little harder. It also illustrates the risk of oversimplifying your questions 🙂
This requires two separate dataflows to two separate files.
After that, use the standard...
March 8, 2012 at 10:31 am
What do you want the file to look like?
Just modify your proc to UNION the two result sets and you're good to go.
March 8, 2012 at 9:44 am
Viewing 15 posts - 10,831 through 10,845 (of 13,872 total)