Viewing 15 posts - 9,886 through 9,900 (of 13,880 total)
Sergiy (5/24/2013)
Phil Parkin (5/24/2013)
Where is that post?
The first post of this topic.
But saying that you "cannot call insert like that" is clearly wrong.
Not if "like that"...
May 24, 2013 at 7:31 am
Bhaskar.Shetty (5/24/2013)
Sergiy (5/24/2013)
Phil Parkin (5/24/2013)
Where is that post?
The first post of this topic.
But saying that you "cannot call insert like that" is clearly wrong.
Not if "like...
May 24, 2013 at 7:21 am
Sergiy (5/24/2013)
Phil Parkin (5/23/2013)
Bhaskar.Shetty (5/23/2013)
You cannot call insert like that, = operator works while you are updating any row or table.
Before making blanket statements like this, I find that...
May 24, 2013 at 6:20 am
Your statement:
You cannot call insert like that, = operator works while you are updating any row or table.
Is plainly wrong - I proved it in code. And now you are...
May 23, 2013 at 1:18 am
Bhaskar.Shetty (5/23/2013)
You cannot call insert like that, = operator works while you are updating any row or table.
Before making blanket statements like this, I find that it is always...
May 23, 2013 at 1:01 am
sqlbi.vvamsi (5/22/2013)
REPLACE(LTRIM(REPLACE(field,"0"," "))," ","0") is the expression, this won't work if field value has space characters
Nice trick.
May 22, 2013 at 9:09 am
sqlbi.vvamsi (5/21/2013)
you could use replace function in ssis
To replace leading zeros but not others? Please demonstrate how.
May 22, 2013 at 1:13 am
Mordred (5/21/2013)
You'll need a default connection even if you are setting the actual connection with an expression that evaluates at runtime.
Where do I set the default connection? I'm going...
May 21, 2013 at 6:46 am
May 21, 2013 at 5:37 am
waralees (5/21/2013)
May 21, 2013 at 3:14 am
waralees (5/21/2013)
i have task to copy all data from source table to destination table (30 table), so i keep source table name and destination table name...
May 21, 2013 at 2:27 am
I think you might be overdoing the looping.
If your source folder structure looks something like this:
root
root\AA
root\BB
root\CC
etc
then you can configure your FEL to point at folder <root> and check the 'Traverse...
May 20, 2013 at 9:30 am
I apologise for the jargon. FEL is just an abbreviation for 'Foreach Loop Container' - it is used quite often here.
The example you mentioned looks like a good place to...
May 20, 2013 at 6:19 am
Debbie Edwards (5/20/2013)
Ahhh, C# skills arent up to much.I could possibly figure it out if I had an example to work from.
Is C# the only way to go on this?
Debbie
I'd...
May 20, 2013 at 5:44 am
Of course - almost everything is possible in SSIS, given enough development effort 🙂
How's your C#? I'd use a Script Task for this.
May 20, 2013 at 5:22 am
Viewing 15 posts - 9,886 through 9,900 (of 13,880 total)