Viewing 15 posts - 9,886 through 9,900 (of 13,874 total)
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
shrsan (5/17/2013)
I am also looking for the same...Please Help..I dont understand that website ...can anyone guide?
Which part don't you understand?
I don't think that there is a two-minute way of doing...
May 20, 2013 at 3:37 am
greeshatu (5/20/2013)
May 20, 2013 at 2:15 am
Your data comes in from Excel as Unicode.
If you are mapping it straight to varchar() columns, you will get an error.
Add a data conversion component to convert your columns from...
May 20, 2013 at 1:59 am
I couldn't find a way of doing this in an iTVF.
If you execute the following:
sp_executesql N'select * from products where name like @ProdName'
,N'@ProdName varchar(30)'
,@ProdName = 'Samsung%'
You'll get the idea of...
May 19, 2013 at 10:29 am
You could start by explaining what you mean by "not working."
Try rereading your message while imagining that you are not familiar with your environment. Do you think that you would...
May 17, 2013 at 2:03 am
Thanks Sean - that was the point that I was hoping to make.
May 16, 2013 at 8:16 am
Viewing 15 posts - 9,886 through 9,900 (of 13,874 total)