Viewing 15 posts - 11,311 through 11,325 (of 13,872 total)
bpowers (6/20/2011)
June 20, 2011 at 10:22 am
Great input. Makes my post only 50% correct & taught me something in the process, thanks.
June 20, 2011 at 6:52 am
GSquared (6/20/2011)
Phil Parkin (6/17/2011)
June 20, 2011 at 6:45 am
Not at all - feel free to post back with findings/issues.
June 20, 2011 at 5:13 am
robinrai3 (6/20/2011)
Just need a steer on this ..what is best way to do this or has somebody out there already done it
i was thinking of calling a sp that...
June 20, 2011 at 4:38 am
JustMarie (6/17/2011)
Phil Parkin (6/17/2011)
June 17, 2011 at 10:38 am
drew.allen (6/17/2011)
Phil Parkin (6/17/2011)
June 17, 2011 at 8:55 am
If you write a lot of T-SQL, consider doing yourself a favour and omit the readability words (AS is one) - it soon becomes second nature and as AS has...
June 17, 2011 at 7:44 am
Actually, I was wondering about that. Does that mean the problem is that she has to get a full blow version of SQL Server to get the SSIS functionality to...
June 17, 2011 at 4:29 am
Ah indeed. OK, try this one (it's a big page, search for fuzzy and you'll find it towards the end of the page).
June 16, 2011 at 9:16 am
Brandie Tarvin (6/16/2011)
Phil Parkin (6/15/2011)
You need SQL Server Enterprise Edition to use fuzzy lookup.
Phil, where did you get the idea that fuzzy lookup is only available to Enterprise Edition? SSIS...
June 16, 2011 at 8:18 am
Your screen shot does not show the right hand side of the properties box ...
June 16, 2011 at 7:48 am
I suggest that you scope the variables at the package level to ensure that they are persisted between tasks.
Your expression will contain variable names, not ?s.
June 16, 2011 at 7:46 am
You should be able to do this just fine by using an SSIS Expression as the SQL for your Execute SQL task.
June 16, 2011 at 2:55 am
Not that I know of - maybe someone else will have some ideas.
June 15, 2011 at 9:33 am
Viewing 15 posts - 11,311 through 11,325 (of 13,872 total)